Data Integration
Discussion List
-
GroovySummary: Hi we have a requirement to create a control .csv file which will consist of number of record of a exported file and also the summation of the amount column. Fo… -
Is there any way to extract the DLR list from FCCS?How can I extract the DLR list / Data Integration Names from FCCS?B.Bhandari 10 views 1 comment 0 points Most recent by Girish Joshi Financial Consolidation and Close -
Oracle JDK 17 compatibility with EPM Agent and Microsoft SQL ServerSummary: Our integration from Microsoft SQL server 12 to EPM Planning is failing after we upgraded to jdk-17.0.18. We were originally on jre1.8.0_471. Content (please en… -
Time out setting in Data ExchangeHi team! We have a situation that it was timed-out in Data Exchange but the report job is still running in Oracle GL. The data load rule runs a out-of-box report in Orac…GaryYip-Asc 14 views 2 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management -
Unable to consume ICP data from ARCs into the FCCS applicationSummary: Unable to consume ICP data from ARCs into the FCCS application. Content (please ensure you mask any confidential information): Hi Team, We are unable to consume…User_IB683 10 views 2 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close -
intercompany matching with transaction currencySummary: We have a requirement to implement IC matching with transaction currency. How can this be facilitated in FCC? Content (please ensure you mask any confidential i…Joost Mellegers 75 views 18 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close -
Can we load delta data from Cloud GL ERP to FCCS using OOB integration and groovy scriptingCan the incremental data from ERP be extracted and loaded to FCCS using out of the box integration and groovy scripting. Could you please share any link or steps detaili…Batul Rangwala 14 views 3 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close -
How to map JGZZ_RECON_REF in ARCS to Fusion GL journal export?Summary: Mapping of Reconciliation Reference (JGZZ_RECON_REF) in ARCS to Fusion GL Journal Export via Data Integration Content (please ensure you mask any confidential i… -
After converting FCC into DSO, Data Export into file with Data Exchange is taking 3hrs+ timeSummary: After converting FCCS app into DSO, Data Export into File in Data Management is taking more than 3hrs time Content (please ensure you mask any confidential info…Kavikumar Chikati 1 view 0 comments 0 points Started by Kavikumar Chikati Financial Consolidation and Close -
Can you Easily Migrate Prod down to lower Environments without a ton of DM manual intervention?Hi Gurus, We have a client who has a lot of cloud EPM environment. In prod alone there are 9 separate instances (EPCM, EPBCS, FCCS etc). Internal controls has them refre… -
Java error when creating Authentication Token for EPMAgentSummary: Content (please ensure you mask any confidential information): Hi all We have an integration error with EPMAgent 24.12.05 and FCCS. The error is: when we execut… -
Filter not available on options tab in Data exchange integrationSummary: I have a situation where an integration in data exchange has a greyed out filter option so I cannot set a defined list of data I wish to export. When viewed in … -
How to back up files in data management in batchSummary: How to back up files in data management in batch Content (please ensure you mask any confidential information): How to back up the file in the workbench in batc… -
Calling Data Management REST API through scheduling PBC Groovy RuleSummary: We've built an Integration between ERP and PBC. We want to execute this integration every two hours for only a few days during a month. We want to automate this…Jeroen Goudvis 171 views 15 comments 0 points Most recent by Chiranjeevi Naragani EPM Platform and Freeform -
Can we load journal lines from Cloud GL ERP into FCCS using direct integrationIs there a possible way to load journal transactions (as journals or data lines) from ERP GL to FCCS using direct integration?Batul Rangwala 21 views 3 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
How to use attribute dimensions in data integrationsSummary: Hi All, My source cube is aso, and I am looking to use attribute dimension to filter on data. I tried adding a new dimension in the application but that dint se… -
Trigger pipeline via REST APISummary: How to obtain the outbound file name from the log file after the pipeline has executed successfully? Is it possible to retrieve the outbound file name, and if s…DebajyotiRay 24 views 6 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
Source Period mapping for flat fileSummary: We are exporting data to a CSV file using Groovy, which works correctly. We then created a file-based Data Exchange integration to load the data into Planning, … -
Prevent Data Exchange from exporting an unbalanced TB to FCCSSummary: Is there any way to prevent data exchange from running the export step and loading data into FCCS if the source trial balance data is unbalanced? Content (pleas…Nancy Ackerman 35 views 4 comments 0 points Most recent by Nancy Ackerman Financial Consolidation and Close -
Data ExchangeSummary: Extracting data from Fusion ERP in Functional Currency Content (please ensure you mask any confidential information): Dear All, The fusion ERP from where we are…Sarbajith Bhattacharya 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Instructions on how to load Journals through Data Integration (not Data Management)?Summary: Hi, We would like to import Consolidation Journals through Data Integration. I can find instructions about how to use Journal template in Data Management but ca…soile.alm 41 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close