Data Integration
Discussion List
-
Change data load from periodic data to balancesSummary: Our application is setup with data loads for Periodic data to be loaded into FCCS application. We are implementing cashflows now and would like to change from l…Divya_Masoodi 92 views 16 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close -
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…
-
Consolidation Journal Report - API - FCCSSummary: 'Consolidation Journal' Report does not appear to be included in the reporting API Content (please ensure you mask any confidential information): Hi we are curr…CADDavid 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…
-
Using TRCS data management or data exchange to load no data or #missing instead of zeroSummary: Colleagues need to use data management to clear previously entered data in Tax Reporting Cloud Sevrice (TRCS). Currently they are using a zero which takes up da…
-
ARCS job schedulingHi, I would like to seek clarification regarding the use of pipelines in ARCS for automating data loads. 1. Direct Integrations (ERP → ARCS) Currently, the following are…Srilakshmi Thellapragada 31 views 4 comments 0 points Most recent by Tim Gaumont-Oracle EPM Platform and Freeform
-
FCCS_ClosingBalance_Input – Performance Impact When Loading Zero YTD BalancesHi Everyone, We load YTD Ending Balances using FCCS_ClosingBalance_Input. In certain subsequent periods, balances drop to zero and we end up loading a large volume of ze…Bhavishya Edula 34 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
data load and Consolidation/Translation every hourHi All, In our Oracle FCCS application, we have an automated process that loads data and runs consolidation and translation every hour. If these processes are running on…sahuvipul 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 71 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 23 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 21 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 72 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 23 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 63 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