Data Integration
Discussion List
-
Data DuplicationSummary: In Oracle FCCS, stat accounts are being loaded to the No Movement member, which is currently positioned as a child of Mvmts_Subtotal. This configuration is caus…Saraiya Daisy Dhanesh 69 views 20 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Do we have an official documentation on Snowflake integration with EPM CloudSummary: Content (please ensure you mask any confidential information): Hi all Could someone please could me to an official documentation on EPM cloud integration with S… -
How To: Export Data for Non-Inactive Entities Using Data IntegrationSummary: This article stems from Customer Connect Thread - How can we remove shared entities from a Data Management extract? — Cloud Customer Connect Where-in it was req…Ashutosh Bhatikar-Oracle 9 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Why does the data push split the value in one GL into two different GL's in the new cube?Summary: In EPBCS we have a data map to push data in FINREV cube to FS cube. When we run this data map it splits the value in one account in FINREV cube into two account… -
Data Integration fails due to AutonomousConsolidation ruleWe have an integration used to load data and part of the process is we have embedded the "Consolidate" rule under the Business Rule section. This is set to run post the …Kenneth John Asper-Oracle 59 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
File Upload Without Data ExchangeSummary: Is it possible to provide only the file upload capability to users, without giving users access to Data Exchange itself? Content (please ensure you mask any con…Aroush 61 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Need period column in data extract file in the format Dec-24Summary: Need period column in data extract file in the format Dec-24. How to achieve this? Content (please ensure you mask any confidential information): Version (inclu…
-
How to integrate topside JEs from FCCSSummary: Hi all, We have an FCCS application where topside journal entries are being posted at parent entity level. We want to integrate data from FCCS to TRCS, so we wa…
-
DATAEXPORTCOLHEADER Please provide a valid dense dimension name to be used as the column headerFor the Version 26.06.73 (June 2026 EPM Monthly updates)that was released on Friday 06/05 - we are now getting error on FCCS to Planning data integration (integration is…Anne-Marie M 210 views 16 comments 0 points Most recent by Anne-Marie M Financial Consolidation and Close
-
Workbench Data Retention PolicyWe have a business requirement to retain Workbench data (job history, logs, and related artifacts) in EPCM for a minimum of 12 months. We have found no clear Oracle docu…
-
Load Oracle Fusion GL to FCCS - P13 DataSummary: Content (please ensure you mask any confidential information): I'm trying to load P13 Trial balance data from Fusion GL to FCCS as normal using data integration…
-
Error while running BR with IntegrationWe have added consolidation and transaltion rule with data load rule to consolidation numbers after data load but getting below error for a rule which we have not added …MKhade 50 views 2 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close
-
EPM Data Exchange – Dynamic File Naming in File Operations (MMM_YYYY) LimitationSummary: I am working with EPM Data Exchange pipelines using File Operations (copy) and observed a limitation around dynamic file name generation. Content (please ensure…
-
that data is not visible in workbench but loaded successfullySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Bulk Move/Zip Multiple Files in EPM Inbox/Outbox ExplorerHi Team, I am looking for a way to move or zip multiple output (.csv) files from the EPM Inbox/Outbox Explorer in a single operation. Currently, I am aware of the Copy/M…Jeelan P Banglewale 23 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
unable to find data in workbenchSummary: Even when integration is successful and data gets loaded, workbench does not show any data Content (please ensure you mask any confidential information): Versio…User_ODCHJ 2 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
how could we add the Conversion Rate Type to the GL Journal generated in an EPM integration?We have an integration in EPM where the source is an EPM application and the target is Oracle Cloud ERP (GL Balances). The journals is not created in ERP because the are…Oscar Martinez Olivan 12 views 2 comments 0 points Most recent by Oscar Martinez Olivan EPM Platform and Freeform
-
How have you Archived data out of FCCSSummary: Strategy to archive data out of FCCS so that we keep a rolling current 5 years. Content (required): We are looking for a strategy to archive and keep historic d…
-
Non-Admin File Upload for Data IntegrationSummary: Hi All, We have a requirement to allow business users (non-Service Administrators) to upload source files through the EPM Cloud UI so that they can be used by D…
-
Scheduling job for cross application data mapsHi, With the recent support for cross data maps push to remote application, I am not able to see such data pushes under Data Maps in Jobs scheduler. Is there any securit…Loganathan Nachimuthu 57 views 5 comments 0 points Most recent by Loganathan Nachimuthu EPM Platform and Freeform
-
Export attribute values while exporting data into a fileSummary: Hi Team, I exporting data to a file using Data Exchange and want to know if it is possible to export attribute values. Example: We have Account as dimension an …
-
Data Exchange Workbench Source Period Dimension pull AmountSummary: Hi all, I'm encountering an issue in Workbench: the "Source Period" column is showing amounts instead of the period dimension. I've already mapped the "Dimensio…
-
EPBCS - Primavera integrationHi everyone, I want to ask if in our community has someone to push or get data from EPBCS to Primavera and vice versa? Can you share your expenrience ? Can we use REST A… -
How can we access Data Management API tables for ARCSHi Team, Could you please help us understand how we can get access to the API tables in Data Exchange to extract key integration details? Specifically, we are looking to…
-
Issue with File name Suffix Type for Dec periodWe are deriving the period from the “Period Name” (YYYYMM) in the File Name Suffix Type. However, when loading the file through the pipeline and DLR, Dec'24 (202412) dat…Shubham Katheria 22 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform