Data Integration
Discussion List
-
Any performance tuning service provided by Oracle Support?My client possesses a vast amount of retail data combined with a highly complex data model, resulting in numerous intricate data intersections. The whole process of load…Supanut Sinphatsirikul 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Pipeline moved on before job finshed and sets pipeline to failed (even though no error)Summary: Our pipeline emails are showing as failed if a job is still running when it ends. It is also moving onto the next job rather than waiting for the job to finish.… -
TRCS Entity to Reporting Currency Translation Methodology best PracticeSummary: Looking for input on suggested best practice for frequency and methodology of Entity Currency to Reporting Currency translation Content (please ensure you mask …Brian Robinson 91 views 3 comments 0 points Most recent by Brian Robinson Tax Reporting (Direct Tax)
-
How to Pull Incremental Metadata from Fusion to PBCS via Data ManagementHello Team, We are working on integrating metadata (Account, Entity, Custom) from Oracle Fusion to a PBCS application using Data Management in Oracle Cloud. Our goal is …
-
Data Integration with conditional factoring of the data/amount columnContent: We load multiple accounts worth of data, value-based and score-based. Both accounts come from the same csv-file and have the same formatted amounts, however sco…
-
How to integrate oData with EPM Integration Agent using REST call.Issue SAP REST API response will be in JSON format. Data Management can only import delimited files and not JSON files. Requirement Load JSON file to Data Management usi…
-
NetSuite Integration with FCCS1.Our goal is to load trial balance data directly from NetSuite ERP into FCCS. 2.We understand that there is no specific documentation available for integrating NetSuite…K Maheswara Reddy 215 views 1 comment 0 points Most recent by Sunil Gavvala-Oracle Financial Consolidation and Close
-
Substitution Variable - Not Working in Custom Application FDMEESummary: Issue with using Substitution Variable in FDMEE Content (please ensure you mask any confidential information): Hi All, we noticed an issue with a Custom Applica…Antonio Barbaro 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 81 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 41 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 492 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 94 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 …