Data Integration
Discussion List
-
GroovySummary: Hi We have a requirement of reading a control file which will contain No of records Summation of Amount Unique Account count Unique Entity count Is it possible … -
Change Export File Location from Inbox/Outbox Exp to Data Management Outbox for Pipeline ExecutionSummary: Is there any supported way to move or copy an export output file from the Application Inbox/Outbox Explorer to the Data Management Outbox folder in Oracle Cloud…
-
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 40 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Run Data Exchange (Pipeline) ConcurrentlyWe built some data management rules and pipeline to enable multiple users to run the pipeline (or data exchange) to load different ledgers' TB from Fusion to FCCS. Howev…
-
Create a validation in Data ExchangeWe have a requirement to create validations on source files in Data Exchange. FCCS will receive two files in Data Exchange from each country unit (one individual locatio…Ryan DeFilippi 37 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Integration Issue – Data Overwrite When Loading IS and BS Accounts (Hybrid Planning Cube)Hello, I am working on an Oracle EPM Planning application (Hybrid Financial cube) and encountering a challenge with Data Integration while loading Trial Balance data. Sc…
-
Viewing Historical Process IDs in Oracle Data ManagementSummary: Hello, We are currently experiencing an issue with one of the Oracle Data Integration process IDs. Example: Process ID 1627 was used during yesterday's integrat…VikramMed 12 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Load Error in Data Exchange : File/Directory not foundSummary: Hello, I am trying to run a pipe which is calling an integration to load data from a flat file (.txt) residing in File Browser. When I run the integration it ru…
-
data exchange applicationSummary: We are unable to open the Application from Data Exchange in the test environment. The page does not load as expected. This issue is not observed in the producti…
-
Pipeline Scheduled Job Not Sending Email Notifications in PCMCSSummary: Hi Team, We are facing an issue in Oracle Profitability and Cost Management Cloud Service (PCMCS) where scheduled Pipeline jobs are not sending email notificati…
-
Export data file from FCCS how to get child entity onlySummary:Export data file to .txt from FCCS, how to get child entity only Target : data file .txt Datasource : FCCS Expect result : entity column show child only not incl…Kaesorn Apirak 23 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange new dimension metadata refresh errorSummary: Content (please ensure you mask any confidential information): Hi All Under Data Exchange under the application section, there is an option to create additional…NKW 61 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Customized Pipeline Email NotificationHi Team, We are implemented complex data pipelines in our FCCS (Financial Consolidation and Close) and PBCS (Planning and Budgeting Cloud Service) applications to automa…
-
calculate amount column in data load mappingSummary: Requirement is to calculate the amount dimension as * to 1/Amount in FCCS data load integration. Kindly help me in sharing knowledge on the efficient way to han…
-
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 4 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…DebajyotiRay 77 views 15 comments 0 points Most recent by DebajyotiRay Financial Consolidation and Close
-
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 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Attributes)Summary: Hi All, We are trying to integrate metadata from Oracle ERP to FCCS. How do we set up the attributes, especially for the entity, to set it to ICP_Entity_Yes, an…
-
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 11 views 2 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
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 72 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 13 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…
-
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…