Data Integration
Discussion List
-
Facing issue having error message starting with "You are trying to change the data" after patchSummary: While deploying rules or try opening forms, we are facing below issue in the EPM application after the patch has been updated on Friday. Appreciate your help an…Subramanian Karunamoorthi 82 views 11 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
Load Data in YTD_InputHello, The cumulative data upload (YTD_Input) forces you to define a single "Default Movement" per accounting account ("Calculate Movement rule"). If so, how could I loa…CarolinaRodriguez 11 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close -
Use substitution variable in data integration pipeline jobSummary: We would like to use substitution variables for the start/endperiod of a data integration as part of a pipeline job (with a few integrations and a consolidation…Tjeerd Huisman 43 views 2 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close -
Showing Balance Sheet Accounts with natural signage from TB and P&L Accounts with sign flip in FCCSummary: Hi All Client requires us to show Balance Sheet Accounts with natural signage from ERP and P&L Accounts with sign flip. This requirement is from reporting stand…Parmit Choudhury-Deloitte 491 views 6 comments 0 points Most recent by BrettMac24 Financial Consolidation and Close
-
Clear Region feature to clear ERP Cloud scenario runs in errorDear community, Oracle Development, We would like to use the Clear Region feature in Data Exchange to clear a specific Accounting Scenario (LE9+3) in ERP Cloud, before w… -
How to connect Oracle DB from EPM?Hi Team, As part of integration project, we would like to connect Oracle DB from EPM; which could help us to create a view and get the desired data from Oracle DB to EPM…Sukanya 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to pull FCCS data with fully qualified name.Summary: I'm working on integration to PBCS. I need map Entity Dimension shared member to different entity Target in PBCS with its base member to separate consol elimina…Rosida Majid 71 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not existLoads are failing in Prod and we think the error is shown in the following lines of log: 2024-11-08 13:59:06,840 INFO [AIF]: Fetching dim col mapping for Application:Fin… -
How to customize the email subject or body in Pipeline notifications?Summary: In EPBCS Data Exchange, when triggering a data integration pipeline, the email notification defaults to the following format: Subject: "TestWorkforceMetadata : …
-
Can I get an artifact snapshot from an earlier date?Summary: I need an artifact snapshot from an earlier date as the on automatically created. Is it possible to get it from Oracle, since it is overwritten every night? Con…JSchil 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Controlling Standard Movement Calculations based on ClosingBalance_InputHello, In our FCCS system, some entities in the group load both the Closing Balance and Movement Balance, while others provide only the Closing Balance. For entities tha…Bjoern Schumacher 31 views 5 comments 0 points Most recent by Vani-Oracle Financial Consolidation and Close
-
Bank File format load to Predictive Cash ForecastDoes Predictive Cash Forecast Plan type allow to load Bank (BAI2) file format files( for Balances and Transactions) using Data exchange with Category : Data Source ,Type…satishpatakota 61 views 3 comments 0 points Most recent by Chris P-Support-Oracle EPM Platform and Freeform
-
Editing Existing Pipeline Details & Save Remains Greyed Out?Summary: We have created a couple Data Integration Pipelines in FCCS that move data from our FCCS application to our EPBCS application & they work fine. When we needed t… -
Clarification on New System Maintenance Process for Consistent Data Load Performance in 24.11Summary: Hi Oracle, Can you please provide update on disabling the below feature provided in the 24.11 release notes: To address inconsistent data load times, Data Integ…Ramsha Ansari 41 views 2 comments 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close
-
Pull Dynamic Calc Member Values using Data Load RuleHi all, We are trying to pull values from members in which are dynamic calc for the consolidation dimension using a data load rule, has anyone been able to accomplish th…Sarah Paroya 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management AuditSummary: We are looking to find a way to audit/see a record of changes in DM. For example, we had a change made to the Execution Mode of one of our Batch Definitions. We…Alyssa Longo 11 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Oracle FCCSUnable to copy Lvl0 data from P01-FY25 to P04-FY24 from one period to another, in FCCS. What are the ways to copy all Lvl0 data from the period P01-FY25 to P04-FY24? We …Global Support Desk 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Using OIC with Oracle PBCS - Where to find certificate?Hello, We are experimenting Oracle Integration Cloud and thinking of using PBCS with it to see if there are any processes that could be improved. I am looking at the Ora… -
Data Exchange menu unavailable under Application in FCCSHi All, I don't see 'Data Exchange' sub-menu under Application menu in FCCS. Although I see this in a test environment, the same is unavailable in Production environment…Thiru Vedantham 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Issue with Loading Data into "Budget Adjustment" in EPBCS to Fusion Budgetary Control CubeHello All, We were able to successfully push data into the initial budget in the Fusion Budgetary Control cube. Now, we are trying to push budget transfers into the "Bud…DarshanJ 91 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Drill through from FCCS to PowerBIHello, Is it possible to setup drill through URL from FCCS to PowerBI report and - most importantly - pass members from application dimensions as values for report's URL…
-
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 …
-
Users Unable to see the existing file and folders (flat file) in Data exchangeSummary: Hi , Power users having access all the entity, he trying to upload the file in Data Exchange card. but he can upload the file but file is not visible and he can…Nagarajan Mouttouvelou 311 views 10 comments 0 points Most recent by Sandeep Hardikar N S Financial Consolidation and Close
-
Is there any Security feasibility available on using Import and Export mode optionsIs there any option to hide this import /export feature.Eshant Gupta 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close