Data Integration
Discussion List
-
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… -
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…TC.Brov 33 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
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 Extract job failing due to unmapped period after DSO MigrationHello, After migrating our FCCS App to DSO, we are having errors whenever me run our scenario-based data extract integration. It says that the Period dimension is unmapp…
-
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 12 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 419 views 12 comments 0 points Most recent by User_H0ZX3 Profitability and Cost Management
-
How to export just one Data Load rule and mapping associated with it in FCCS?Summary: We just want to export one single data load rule and mappings associated with it and how it can be done in Oracle FCCS? Content (please ensure you mask any conf…
-
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 67 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 22 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 21 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 22 views 4 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
FX Rate Integration Issue in FCC with Period 13 Enabled (December Mapping Conflict)Summary: During FX rate integration, the system is unable to pull exchange rates for Period 12 (December) because the mapped date (30-Dec) does not match the rate date a…Navneet Sharma 3 views 0 comments 0 points Started by Navneet Sharma Financial Consolidation and Close
-
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 3 views 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…
-
Copy / Recompute Ownership via REST-APISummary Is it possible to do a copy of ownership data and/or a recompute of the ownership data via REST-API?Content Hi all, I'm just trying to automate some things to ge…User_2025-02-03-23-55-06-250 246 views 9 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 42 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 52 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…