Data Integration
Discussion List
-
DLR failed to import from backupWe had to restore from a backup. Everything went smoothly except a single data load rule. We got the below error: "EPMFDM-140073: Failed to import datarule [DLR Name] 14… -
Along with consolidation journal data, can we extract information like status, created, name of CJSummary: We have requirement where consolidation journal data needs to be pushed to another application (ADLE), but along with the data of consolidation journal the clie…AditiKavdia 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Issue with Importing ERP Cloud Data to EPM Planning: WAIT ERRORSummary: My client is running into an issue where there integration to ERP is unexpectedly failing after a year plus of successful runs. The process log stalls for about… -
FX rates extracted from ERP is not loading to FCCS rates cubeSummary: Hi all, I am facing two issues when using the standard ERP to EPM adapter - Oracle ERP(Exchange Rates), to bring FX Rates directly from ERP to FCCS, and wonderi…Sarita Menon 451 views 20 comments 0 points Most recent by User_QX4K6 Financial Consolidation and Close -
Has Oracle received any reports of end‑user issues related to the April 2026 patch releaseSummary: Hello, Following the April 2026 Oracle EPM Production update, has Oracle identified any known issues, customer‑reported incidents, affecting end users? Applicat… -
Drill through from FCCS to Oracle Fusion GL not workingContent We opened SR SR 3-25410502941 21 days ago with errors using the drill through from FCCS to Oracle Fusion GL. After loading the GL data into FCCS via DM, I click … -
Clear Exchange rate using Pipeline is not workingSummary: We have created a clear job for Rates and triggering it via pipeline. The pipeline failed after half an hour with timeout error. Content (please ensure you mask…Kirti 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
fccs clear data based on the entities in the load file in data managementHi, We are looking for a way to clear the data in the consol cube for the entities coming in the load file during data load process in data management. List of entities …Satish9090 41 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Performance Degradation Post EPCM Allocation – Massive Data Volume IncreaseSummary: Hi Experts, We are currently facing a significant performance challenge in our FCCS application after integrating with EPCM for allocation processing, and I’m l…Gaurav Kabra 11 views 1 comment 0 points Most recent by Raama Rao-Oracle Financial Consolidation and Close -
FCCS - Pipeline - Is it possible to use variables in a 'Business Rule' type jobSummary: I'd like to use variables for the parameters of my business rules. Content (required): I created a pipeline containing one job: 'Translate'. This is a 'business…Julie Belurier 281 views 6 comments 1 point Most recent by adarshad Financial Consolidation and Close -
Data Extract job failing due to unmapped period after DSO MigrationHello, After migrating our FCCS App to DSO, we are having errors whenever we run our scenario-based data extract integration. It says that the Period dimension is unmapp…User_YDH16 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EXPORT MODE as "REPLACE" when sending data from EPCM to Oracle GLHello everyone! We built a data load rule to send the EPCM allocated data to Oracle GL. We normally use "Merge" in the EXPORT MODE. What is the use case for using "Repla… -
Data load Rule Error Cannot perform cube view operation. Essbase Error 1030742 Invalid cell offsetHello All, While Executing Data load rule it is giving an error Cannot perform cube view operation. Essbase Error(1030742): Invalid cell offset [0]. Before Apr-26 patch …Mohit Pahuja 68 views 2 comments 0 points Most recent by Mohit Pahuja Profitability and Cost Management -
EPBCS – Clarification on “Validate Metadata” Job Behavior and Data ImpactWe are evaluating scheduling the Validate Metadata job on a recurring basis in EPBCS. Please confirm: Whether running Validate Metadata can delete, modify, or remove met… -
In EPCMCS, data is not getting pushed to REP cube using Data ManagementI'm pushing data from the Oracle Planning Cloud to the EPCMCS Reporting cube using "Data Management", I'm getting the below error, my metadata is Refreshed, and there is…Kumari Soni Umesh 422 views 12 comments 0 points Most recent by User_H0ZX3 Profitability and Cost Management -
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 71 views 17 comments 0 points Most recent by NarayananS 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… -
Integration [ERROR_INVALID_PERIOD] when using Data Source typeSummary: We are attempting an integration between SAP BW4 HANA Calc View and a FreeForm EPM app. We have carefully followed integration steps, but in initial testing kee…John Dalby 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
drill through to source from FCCS to Planning is generating an errorSummary: Content (please ensure you mask any confidential information): HI all While trying to drill through from FCCS to Planning we are getting this error: Error: ====… -
Export Form data in csv ( Data Status form)Summary: Looking for a way to export approval status information in a csv file for other automations. I feel i have scanned through all the articles / Question and I thi…HarryEPMUser 23 views 6 comments 0 points Most recent by HarryEPMUser Financial Consolidation and Close -
Usage of AIF_TARGET_APPL_MEMBERS in FCC CloudHello, We have a requirement to get member alias in data exports & currently we have used AIF_TARGET_APPL_MEMBERS to solve this problem in Non-Consolidated report. We ha… -
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…Jacob Gomes 25 views 4 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
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…Scorpio_31 1 view 1 comment 0 points Most recent by Vijay Mahantesh-Oracle Profitability and Cost Management -
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…