Data Integration
Discussion List
-
Creating an outbound integration from FCCS to Third Party SystemSummary: We have a requirement where in we need to run a Report in FCCS and push the output to a third party SFTP. What are the ways to achieve this? Content (please ens…Mandeep Mittal 1 view 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
Error while running BR with IntegrationWe have added consolidation and transaltion rule with data load rule to consolidation numbers after data load but getting below error for a rule which we have not added … -
Data exchange export not working from Workbench ActionsSummary: Has anyone else experienced that you cannot export the view data data listing from the Workbench in data exchange/integration? It works if you use Data Manageme…
-
Inter EPM FX rate integration erroring outHi, We have built an interEPM FXRATE integration from FCCS(rates cube) to EPBCS. It is throwing the below error : Unexpected error: java.lang.RuntimeException: /u03/inb…MB001 31 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
EPCM Outbound Extract CLC or RPT cube??Summary: For outbound integrations should the extract be run from the reporting cube or the calculation cube? Is there a performance benefit to running the outbound inte…Cloud.EPM.TMH 21 views 3 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
Load ytd values with data managementSummary: Hello everyone, Can we load ytd Data using data management on fccs? Also, if we approve the status of an entity, the loaded will be rejected or not? Many thanks…User_6M4GS 22 views 2 comments 0 points Most recent by LucianoStasi Financial Consolidation and Close
-
Is there any way to restrict load data to FCC for closed monthsI know we have "manage period" page to close month in FCC, This restricts from posting any Journal entries in FCC. But we have a data load process, its file based and we…HarryEPMUser 53 views 5 comments 0 points Most recent by LucianoStasi Financial Consolidation and Close
-
Delete file from inboxSummary: Hi all, i'm facing the following issue while deleting file from inbox/outbox explorer through using REST api from groovy script. "A method called by the script …SRAD 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to add interdependencies of jobs within stages in pipelineSummary: Hi Oracle, Can you please let us know how we can add interdependencies of jobs within stages in pipeline? Code Snippet (add any code snippets that support your …
-
How to rename files with date & time stamp on Target side in pipelineSummary: Hi Oracle, How to rename files with date & time stamp on Target side in pipeline? Code Snippet (add any code snippets that support your topic, if applicable):
-
Data Load File for PipelineSummary: Currently data load files are being manually imported into Data Exchange and then from there we created a Pipeline and called the Data Exchange job. Is there a …
-
EPM Agent receives job but does not attempt extractSummary: EPM Agent receives job but does not attempt to connect to on premises DB to perform data extract query. We have a single production database on premises that pr…
-
Data Integration with no corresponding source dimensionI am using data integration to move data from Planning to EPCM, can someone please tell me how to set up mapping to a member of a target dimension when there is no corre…
-
Bulk delete folders in data exchange file browser or Data ManagementSummary: How to delete multiple empty folders at once in the file browser in Data Exchange? Content We have setup an openbatch pipeline which processes all files placed …Jeroen Goudvis 52 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
API Key Authentication for EPMSummary: We are establishing connection between Oracle Integration Cloud (OIC) & EPM FCCS, and we are using EPM Service Admin ID for this connection. This connection is …Dharanidharan M 43 views 2 comments 0 points Most recent by Dharanidharan M Financial Consolidation and Close
-
Mapping of Dimension based on different data Intersections directly in EPCM ApplicationSummary: Dear Experts, Our Source data is of "No Entity" and we want to map it to proper Entities based on different dimension member combinations (Account → Revenue/ Ex…Sivavignesh V 11 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Data Management Export Mode Replace doesn't workSummary: Data Management Export Mode Replace doesn't work. When we choose Replace Mode, Scenario/Year/Period/Entity/Mapped Data Source is encountered, the entire combina…J Mahero L 144 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange Pipeline burst NR report across enviornmentsHello Anyone tried executing a Dataexchange pipeline ExecuteBurstdefenition successfully based on below scenario? Pipeline (e.g. Pipe1) is created in POD1 with a connect…
-
EPM Pipeline SubVar to Send Data to ERPSummary: We are trying to use SubVars to manage the Period we are sending data back to ERP from EPM, but we are getting Invalid Start Period error when executing the pro…
-
Data Management - Error when no records presentSummary: Hi Everyone In our implementation when FCCS pulls data from Oracle Fusion, we might have a possibility it returns 0 records or just the header, which is ignored…Mary John-Oracle 92 views 4 comments 0 points Most recent by 1Karen Financial Consolidation and Close