Data Integration
Discussion List
-
Restrict access to Pipeline in data exchangeI have a location tagged to a pipeline in FCCS data exchange and wanted to limit access only to the pipeline for the end users and restrict displaying corresponding DLR.…Vanathi K-Oracle 69 views 9 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
Drill Through custom URL issueSummary: Hi! I have an integration in my planning app that pulls GL actuals from FCC (which is pulling data from Fusion). I need to implement a drill-through that allows…Joao Carlos Monteiro 14 views 0 comments 0 points Started by Joao Carlos Monteiro Financial Consolidation and Close -
How to Integrate FCC Supplemental Data to an Inbox Received FileHello, we are trying to design an integration to populate lines of a Supplemental Data Form using an Inbox folder file. This file is designed by a third party and put in… -
FCCS Migration Snapshot Fails with EPMLCM-14000 for Data Integration Artifact Due to TimeoutHello Experts, We are experiencing failures when importing snapshots containing the Data Integration Artifact. The migration process fails with the following error: Few …MKhade 85 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Is there a way to hide or encrypt the password while writing Groovy code in "FCCS" ?We have created a Groovy script to validate metadata in "Financial Consolidation and Close". During the EDMCS-to-FCCS metadata import process, if any validation errors a…Shubham Katheria 38 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 58 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… -
My client wants to export reports from Oracle FCCS to server in Control M. Possible using Pipeline?Summary: My client wants to export reports from Oracle FCCS to server in Control M. Is this possible using Pipeline? I am thinking of using bursting definition to first …Md_Ashif 47 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 85 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 23 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 40 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 52 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 83 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 39 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 37 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 34 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 482 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 56 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…