Data Integration
Discussion List
-
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 64 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 72 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 52 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 21 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 11 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 51 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… -
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
-
FCCS to TRCS IntegrationWe are currently trying to map the FCCS trial balance to TRCS but keep getting the error ' No periods could be identified in TDATASEG'. The data exchange seems to be pic…
-
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…
-
Source Period mapping for flat fileSummary: We are exporting data to a CSV file using Groovy, which works correctly. We then created a file-based Data Exchange integration to load the data into Planning, …
-
Intercompany Elimination Did Not Work With our Flat Structure ConfigurationHello, We have a flat structure where one parent has 3 entities as immediate children. GOVSUB 1.623 X.623 Z.623 I know that eliminations do not occur upon loading data; …GeraldineB 101 views 3 comments 0 points Most recent by SaifUrRehman Financial Consolidation and Close