Data Integration
Discussion List
-
How to access data management load rule log file using EPM REST APISummary: We are using REST API to trigger a data lod rule and we are able to expose the output as a REST API CSV content but we need to access the corresponding log file…NarayananS 125 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Downloading file from OCI sub-directory using Pipeline Object Store JobsSummary: Using EPM Pipeline - Object Store Jobs, I tried downloading a file from root folder of OCI bucket, it worked fine. I need to download the SOURCE file from sub-d…Mohit Sharma-73954 91 views 14 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Where i can find sequence option available on Target application in DM in Data ExchanageDear Experts, I want to change order/ sequence of processing order for dimention in data load mapping. Earlier Squence option was available in DM target App screen now i… -
Metadata load from Data Management fails for Replace in Import and Export modesSummary: Metadata load from Data Management fails for Replace in Import and Export modes, it works for Replace and Merge when executed from Pipeline. Error is 'Plan type…
-
Warning status in Data ManagementSummary: In Data Management, processes can finish successfully with a warning indicated by a yellow icon. This usually happens when there are no records imported from th…
-
Import Fusion Supporting References in EPMSummary: Is there a way to import Fusion Journal Supporting References as attributes/use them as LOOKUP mappings in EPM applications (FCC)? Content (please ensure you ma…
-
Period name - Source filter in Data load ruleSummary: The EBS on-premise data base is integrated with FCC using the EIA agent . We have used the EBS adaptor for the integration which internally uses two parameters …
-
EPM Integration Agent encryptionSummary: EPM Integration encryption Content (required): Client's network security team requires to know how EPM Integration Agent secure the data transfer and protect th…Gary-consultant 101 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
FDMEE Error: ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1260046)Summary: Hi, in FDMEE, using: Data Source: ERP Cloud Target: EPM Local Clicking on the import phase, the system returns no "fishes" (image below) and the log returns the…
-
Pipeline Migration MethodSummary: Is it supported to migrate pipelines by exporting via a snapshot and importing to the Target? Content (please ensure you mask any confidential information): We … -
Data Export to File does not workSummary: Hi Team, In FDMEE, when using Data Export to File as Target, the first step of the Data Load Workbench (Import+Validate) does not load any data! I tried to use …DavidePacilio 115 views 9 comments 0 points Most recent by Kumaresh Sankar-Oracle EPM Platform and Freeform
-
Data Exchange screen not renderingSummary: For some users, when they go to Data Exchange, the screen is completely blank. The pane doesn't load. Have tried with different browsers, but same behaviour. Ha…
-
ARCS Snowflake Query - Make period name parameter instead of hardcoding monthSummary: I am trying to pass in period name to my Snowflake query in ARCS. I am not sure what I should be trying to use in the Query when setting this up. I have tried t…Erik_Olson 13 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Data Management - Multi Column IntegrationSummary: Import format dimension not visible or mapped in Workbench Content (please ensure you mask any confidential information): I've configured a multi-column all dat…
-
Conditional in Source/Target expressionHello there! Where I can find all the possibilities for the Conditional statement in Source/Target expression? In the documentation, there is only one example with the t… -
Replacement of Data Management features by Data IntegrationStarting in release 23.07 (July 2023) we will begin to incrementally turn off features in Data Management and direct users to use the similar features in Data Integratio…Mike Casey-Oracle 1.4K views 76 comments 5 points Most recent by Al Marciante-Oracle Enterprise Performance Management Resource Center -
Using SSO Users or Oauth2 for Connections in Data Integration Planning CloudSummary: We are not allowed to use Native users - SSO from corporate Azure servers are the company policy. Is there a way to use an SSO user also for the connections/ ta…
-
Object storage namespaceHi I'm interested in using the new Pipeline feature to move files to and from Object Storage. How do I find out the namespace for my respective tenancy? I read the docum…
-
Drill through to GL Essbase cube using custom data load processSummary: We have decided to proceed with a custom data load process and not use the standard GL adapter to source GL balances. This has led for us to consider a custom d…
-
Data integration job between Workato Rest API to EPM Cloud not working.Summary: Data integration job between Workato Rest API to EPM Cloud not working. Content (required): We recently migrated ARCS classic to Cloud. now we are establishing …Srinivas Nuthi 21 views 7 comments 0 points Most recent by Omar Shubeilat. EPM Platform and Freeform
-
Removal of Custom ApplicationsSummary: Removal of Custom Applications Content (required): Hi Team, When will the Custom applications be completely removed in FCCS. Please let us know the timeline pla…
-
How to load mutiple currencies from Fusion to EPBCS?Summary: Loading multiple currencies from Fusion to EPBCS Content (required): Hi, we need to load different currencies from Fusion to EPBCS. Can someone assist on how th…
-
How to add a prefix to specific members in Data Load MappingSummary: Having trouble mapping a prefix and no prefix while loading employee data. Content (required): I am trying to load employee data using employee number. In our s… -
The member [NONE] does not exist for the specified cube or you do not have access to it.Summary: The member [NONE] does not exist for the specified cube or you do not have access to it. However, there is nothing in the data load workbench with that value. C…
-
There is no Fusion Hierarchy Top Node in Options tab in Data Integration ? (Metadata Integration)Summary: There is no Fusion Hierarchy Top Node in Options tab in Data Integration Content (required): Hi , I Would to integrate metadata fusion to pbcs, but there is no …
-
Where is Data management custom application option in Data ExchangeSummary: Where is the Data management "custom application" option in the Data Exchange Content (required): After Oracle replaced data exchange instead of Data Management…Jaiganesh K 31 views 2 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Not able to see Hierarchy Top Node in Options tab in Data IntegrationSummary: Trying to setup metadata integration using ERP COA Application Content (required): Not able to see the TREE (Hierarchy) which is created in ERP in option tab. A… -
hardware requirements and the required connectivity requirements for EPM Integration AgentSummary: We need to know what the recommended hardware requirements are for the machine where the EPM Integration Agent will be installed. Additionally, we need to under…
-
When Export error (from GL to FCCS) appears in Data management, can no data be loaded into FCCS?Summary: When Export error (from GL to FCCS) appears in Data management, the successfully exported data can be loaded into FCCS. For those export error lines they cannot…Xu, Angela Menglei 51 views 2 comments 0 points Most recent by Xu, Angela Menglei EPM Platform and Freeform
-
Need a file based integration functionality (automation required)Customer has set of data which needs to be uploaded in FCCS application (budget data) without any manual intervention. SmartView is not helpful here and we have has requ…