Data Integration
Discussion List
-
File based to Freeform application which has no period dimensionHello, We have a freeform application which has no period dimension but year dimension exists. Year members are like Y01. We have a source file which contains data for m… -
EPCM with Approval Flow and Task ManagerSummary: How to set up EPCM with Approval Flow and Task Manager? Content (required): I try to set up an EPCM process with a guided process like in task manager and to sa…Mueller 141 views 4 comments 0 points Most recent by Tom LeFebvre-Oracle Profitability and Cost Management
-
Inconsistent behavior of data load in FCCHello, We came across strange issue as mentioned below: Using Data Exchange, file based load was done for one of the entity and it is visible in Workbench. But same is n…
-
Is there a way to add muliple GL balances cubes with same name in data integrationWe have two different ERP prod instances for different business verticals. Both use the same CoA and have the same essbase name. Is there a way to integrate to both Essb…Srikanth_Grandhe 41 views 10 comments 0 points Most recent by Srikanth_Grandhe EPM Platform and Freeform
-
Load data from FCCS to FCCS - service administrator credentialsSummary: We are investigating the possibility to connect 2 FCCS with the aim to load data through task manager integration Content (please ensure you mask any confidenti…
-
Assist us in increasing the time limit in DM to ensure the integration runs successfullySummary: We are experiencing an issue with integration where we have seamless integration with Fusion where it is frequently timing out. The Integration rule it getting …
-
Issues in Drill thru in Forex and ERP cloudSummary: I am experiencing problems with drilling through forex data. I am utilizing an ERP adapter to extract forex data from the ERP cloud. We have deployed the BI rep…
-
Regional Current Provision not calculatingSummary: My National Current Provision appears to be configured correctly with data coming through automated column, etc. When I flip to the Regional Provision, nothing …
-
Current Provision not pulling YTD amountHi, Currently we are loading the book data from PBCS periodic to TRCS periodic, and YTD supposedly is automatically calculated. In the Income Statement view we are able …
-
All Data Extract from FCCSSummary: We want to extract all the data from FCCS to a csv file and are facing challenges. Content (please ensure you mask any confidential information): Hi Experts, Ou…Aditya Mehta 209 views 13 comments 0 points Most recent by Eddie F Financial Consolidation and Close
-
Is there any way to get behind the system user "frs_epm_prod" to see the actual userSummary: We use a number of data load rules (DLRs) that combine several steps to make the data load process as easy as possible for the users. When these rules are run w…Erringc 21 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill through from EPM Agent to relational tablesSummary: Drill through from EPM Agent to relational tables with Text and other fields Content (please ensure you mask any confidential information): Assuming the EPM Int…
-
Different job types in Pipeline - how to set variables?I have created a Pipeline with different job types. I have Integration job types on first stage card and Business Rules on second one. On runtime variable I have start p…soile.alm 61 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Seeking REST API Endpoint for detailed Failure Information on FCCS Data Load Rule ExecutionSummary: When executing the FCCS Data Load Rule via REST API, we are unable to retrieve the exact failure message from the Error Log file. The response JSON from the DLR…dkr_epm1 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Change Consol Operator for FCCS_Total Liabilities/Equity and ExpenseSummary Change Consol Operator for FCCS_Total Liabilities/Equity and ExpenseContent Have anyone have tried to change the Consol opeartor for FCCS_Total Liabilities, FCCS…
-
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 181 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