Data Integration
Discussion List
-
Is there a way to transfer parent level data (Dync calc) to other cube?Summary: We have the requirement to send aggergated data from our source cube to a new cube to work on a higher level. Is there a proper way to do this? The dimensionali…Pieter-Jan Vandendriessche 64 views 7 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform -
File based data integration Smartlist & Date.Hey everyone, We are facing two problems when trying to run a file-based data integration that includes Hiring date & smart list. The hiring-date is written as dd/mm/yyy… -
Simple Tutorial: Import Text based Consolidation Journals via Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based Consolidation Journals using Data Integration and Data Management. Tutorial is used to …Ashutosh Bhatikar-Oracle 81 views 5 comments 3 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
oracle data exchange error ,001 ERROR [AIF]:Summary: Oracle data exchange error: Unable to download the file: {"details":"Invalid file : ALLOC-PCM_CLC_153.log.","status":1,"links": What could be the reason for thi… -
EPM Integration Agent- Writeback timeoutHi, I have an integration where I'm extracting to a target RDBMS (Snowflake). The essbase extract is successful. It is timing out. See log. I am using the same agent to … -
How to convert Password into Base64-Encoded Passwords for EPM REST APIsSummary: Hi Experts, Could you please how to convert password into base64 encoded password? We need this for moving fiules from one instance to other using REST APIs and…Kunal Baikar 46 views 5 comments 0 points Most recent by Vinay Gupta-Oracle EPM Platform and Freeform -
How to troubleshoot data load rule execution getting stuck at extract stage?I am loading data from ERP GL to FCCS. I am able to load other periods except for December 2025 (P12). The data load rule is getting hung up at the extract stage . Curre…Parijat 62 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Guidance Required for Setting Up OAuth2.0 Connection Between FCC and OIC with Different IDCS DomainsHello Oracle Community, As part of our current project, we are working on establishing an OAuth 2.0 connection between Oracle Integration Cloud (OIC) and Oracle Financia…Vijay_Babu 62 views 3 comments 0 points Most recent by Converse_with_OraEnthu Financial Consolidation and Close -
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 104 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill Region Error in Data LoadsSummary: We're encountering a "Create Drill Region" error following the recent update to the entity hierarchy, which now includes shared members. I've attached a screens…Saraiya Daisy Dhanesh 49 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Pipeline Error/Warning Message IssueSummary: I am trying to build a pipeline to import Metadata file from EDM to planning Application, I observed that during the configuration, I keep getting this error or…Harish Kumar C 55 views 4 comments 1 point Most recent by NarayananS Profitability and Cost Management -
How can I send COPY_TEAM_MEMBERS_FLAG to PPM from Oracle PlanningSummary: Export Project data load, in data exchange, is currently adding a project and sending flags COPY_DFF_FLAG, COPY_TASK_FLAG, COPY_TASK_DFF_FLAG, and COPY_TASK_ASS…Jose Ruiz-267547 31 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
How to lock/unlock periods in Data ExchangeSummary: Looking for the functionality in Data Exchange that exists in Data Management to Lock/Unlock locations by Period. Content (please ensure you mask any confidenti…Stephanie Philopoulos 509 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Loading USD-Based TB for 100+ Outstations/Entities with Different Functional CurrenciesSummary: FCCS Challenge: Loading USD-Based TB for 100+ Outstations with Different Functional Currencies Content (please ensure you mask any confidential information): On…Venkatraj Bhat 63 views 4 comments 0 points Most recent by Venkatraj Bhat Financial Consolidation and Close -
Netsuite integration to FCCS issues with token expiring after 60 daysSummary: My client has an integration with Netsuite to FCCS which runs fine for about 2 months, then the token appears to be become invalid. Content (please ensure you m… -
secondary audience for the EPM Cloud ServiceSummary: Getting 401 Unauthorized error when starting the Integration Agent after updating to 26.07 Content (please ensure you mask any confidential information): I foll… -
Oracle EPM OAuth 2.0 Working Mechanism of Refresh Token Grant typeSummary: Currently Refresh token grant type allows multiple refresh tokens+ access token to coexist simultaneously. Though I understand this is the design will this chan… -
Refresh Token using EPM Automate with MFAWe are trying to use EPM Automate with MFA by following the steps outlined below. We were able to successfully log in using the same refresh token for approximately two …adityasingh 37 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
NetSuite Saved Search as data source for FCCSSummary: NetSuite Saved Search as data source for FCCS, but unable to pull Ending Balance for a posting period Content (please ensure you mask any confidential informati… -
Load Oracle Fusion GL to FCCS - P13 DataSummary: Content (please ensure you mask any confidential information): I'm trying to load P13 Trial balance data from Fusion GL to FCCS as normal using data integration… -
Migration blocked due to "Application is in maintenance mode" and pending migration setSummary: Hi Community, I'm facing an issue with the HCM Experience Design Studio Migration tool. Source Environment: TEST Target Environment: DEV2 I created a migration … -
Guidance on Fusion to FCCS integration - Same tenancy vs different tenancy for FCCSSummary: Requesting guidance on tenancy strategy for an ERP migration from EBS to Fusion while keeping FCCS as the consolidation target. Content (please ensure you mask … -
Dynamic timestamp in filename for EPM Pipeline Copy to SFTPHi, We are replacing an existing server-based file transfer process with an EPM Pipeline in EPCM application. Currently, the EPCM Pipeline exports a .DAT file with a fix… -
java.lang.RuntimeException: The CSV output file was not found on UCM.Hi All, We are trying to load metadata using BIP report from Fusion to FCCS. The BIP Report default output is set to .csv and has only one parameter "Period Name". When …Twink-Oracle 56 views 1 comment 0 points Most recent by Yash_Thakur Financial Consolidation and Close -
Guidance on Fusion to FCCS integration - Same tenancy vs different tenancy for FCCSSummary: Requesting guidance on tenancy strategy for an ERP migration from EBS to Fusion while keeping FCCS as the consolidation target. Content (please ensure you mask …