Data Integration
Discussion List
-
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…Aroush 72 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Copy Application Backup Snapshot to SFTPCopy Application Backup Snapshot to EPM Inbox/Data Exchange Inbox-Outbox I'm trying to find a native Oracle EPM Cloud approach to copy an Application Backup Snapshot fro…Vignesh T 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Command to download staging tables TDATASEG tableSummary: We are encountering an issue where our load job fails during the export stage due to missing metadata members. As a result, we must correct all missing metadata…Zenithz 22 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
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… -
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… -
FCCS data managment extract data using metadata propertySummary: FCCS data management extract data using metadata property Content (please ensure you mask any confidential information): We have a requirement to extract data u…Vijayverma 22 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 71 views 20 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 61 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 71 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…
-
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 51 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 22 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 1 view 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 15 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…
-
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 52 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…