Data Integration
Discussion List
-
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 85 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 75 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…
-
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 55 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…ShifaSheikhS 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 24 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 56 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 23 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 102 views 3 comments 0 points Most recent by SaifUrRehman Financial Consolidation and Close
-
ATTR and UD in EPM data exchangeHello We are using more than 20 columns in EPM data exchange integration which we need to export to target using writeback to Oracle. As i consumed all the UDs, I tried …
-
ATTR and UD in DM/DESummary: Does ATTR and UD work in same way when assigning target dimension classes? If all UDs are assigned for desired dimensions and if we are left with no more UDs th… -
Removed Support for Proxy User Entry Breaks Non-Admin Pipeline Execution – What is the Alternative?Hello, With the 26.05 update, Oracle has removed the ability to specify a different username in the Proxy User field on the Data Integration Pipeline Details page. The s…