Data Integration
Discussion List
-
More than one year and period combination to schedule integration from Fusion to EPBCS?Summary: Is there a way to select more than one year and period combination to schedule an integration to run from Fusion to EPBCS? Content (please ensure you mask any c… -
Is there any way to Extract Dynamic time series data to file from EPM planning (Not Smartview)Summary: Is there any way to Extract Dynamic time series data to file from EPM planning .Not using Smartview. Data Management or any other way? Content (please ensure yo…
-
Including alias in data exportSummary: How to get alias into data export Content (please ensure you mask any confidential information): We have a job in Data Exchange that exports our data to a flat …
-
There is no Total Geography under Tree view to select hierarchySummary: in EPM Test there is no Total Geography under Tree view to select hierarchy - We need to have the Hierarchy to open and close periods. How would we add the Tree… -
EPM Integration Agent Query data from JDEThe EPM Integration Agent was built and the data was queried from JDE. Our requirement is to TRIM and concatenate the data using a CASE expression. Are there any suggest…Dharanidharan M 71 views 13 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
How do I get rid of scientific notation in data integration exportsWe are running a data integrations export and found that some of the data is coming out in scientific notation. How do we set it so that all numbers are coming out in re…
-
DM: Data load is taking over 1h to load data when it used to take 30 secondsSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where data load from EPM Data Management is taking over 2 hour to load wh…NKW 91 views 32 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
Error log Limit 1000 linesSummary: EPM has a limit of error lines for importing data into data management which is 1000 lines. We suggest this limit be parameterizable since in many cases informa…David Mata 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Integration execution failed, Outline load finished with errors.Hi, I am trying to import data using data integration. Once I have run the integration. I am getting this error in log "Outline load finished with errors" Here is the lo…Noah01010101 182 views 10 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Is there a capability in Oracle EPBCS to integration actuals data from Fusion Assets module?Summary: My client wants to integrate actuals data from Fusion Assets Module into Oracle EPBCS. As far as I'm aware this is not an out of the box connector yet available…
-
Not able to Submit or Approve the taskSummary: Task: Update task progress in the "Close Schedule" - Task Manager - End User Approve task progress in the "Close Schedule" - Task Manager – Approver Result: not…
-
Logic account functionality from Data Management in Data IntegrationSummary: How is the logic group account / logic item functionality from Data Management implemented in Data Integration? We make extensive use of this and haven't seen a…Ben Walwyn 21 views 3 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform -
Request for list of ERP service user 'roles / Privileges' for Direct integrations to FCCSSummary: Hi, Can anyone suggest what the Oracle suggested roles to be assign while creating a Service user in ERP, which we use for ERP to FCCS direct integrations. I ca…Anand Rasa 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS integration with Microsoft dynamicsSummary: Customer is looking for an option to do direct integration with MSD ( Microsoft dynamics ) - can we utilise integration agent? Content (please ensure you mask a…Alok P DAMAC 71 views 5 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Connection between BI tool- and Data Lake platform with Oracle EPM podsHi All, Is there any way we can connect Oracle EPM cloud based applications to Power BI? Also, can they provide different ways to load data from Oracle EPM apps to Data … -
Data export of same combination to two different targets drops export for second targetWe are trying to export data for a combination to two different target members. It exports data for the first Target member but does not export for seconds Target member.
-
REST API Issues - Batch, Open Batch - SR Support ScopeSummary: There are issues in REST API executions for Batch and Open Batch and SR says out of support scope. Please clarify Content (please ensure you mask any confidenti…
-
Enable Default Movement Setup FCCSummary: Enable Default Movement in FCC. Currently we manually set up our movements in FCC when new accounts are created. To avoid manual process, we would like FCC to p…Sanjana Soni 413 views 38 comments 0 points Most recent by Sanjana Soni Financial Consolidation and Close -
@ILvl0Descendants() function extracting Dynamic calc memberWe have DLR to extract numbers from FCC. We have defined @ILvl0Descendants("[Custom1].[Total Custom1]") for Custom1 dimension in source filter and expecting level 0 memb…
-
EPM Agent Seeded QuerySummary: From Planning I set up a app with the "EBS GL Balance" app and can execute the Preseeded Query against the agent, I see the query string it in the log. How do I…
-
FX rates pull from ERP to FCCS - Dimensions mapping questionSummary: I have this request from my client to Pull FX rates from ERP to FCCS application. and am following this document: https://docs.oracle.com/en/cloud/saas/enterpri…Kemp2-Oracle 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Correct amount is not being retrieved in Data IntegrationHello, In Financial Consolidation and Close, when I ran Data Exchange>Data Integration. The correct amount is not being retrieved. I have attached my mapping and the scr…Noah01010101 71 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error connecting to FCCS from Data Management of on-prem HFMI am getting below error when connecting to our Cloud POD and I am pretty sure, all the details I entered are accurate. Both the source and target are in same domain.SR912 91 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Migrate Batches to Pipeline-Is there a roadmap to discontinue to Batch feature (Batch & Open Batch)?Summary: Batch, Open Batch will be removed from Data Management? Content (please ensure you mask any confidential information): Batch, Open Batch will be removed from Da…NarayananS 61 views 3 comments 1 point Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
How can Data Integration Pipeline or Integration be copied?Hi! I need to copy couple of Data Integration Integrations and Pipelines from Test environment to Production. Is there a way to do that without copying anything else (so…