Data Integration
Discussion List
-
Drill Through to on prem oracle database from EPM Planning using EPM Agent without landing pageSummary: Hi All, Data is loaded from on prem oracle table to EPM Planning application using Asynchronous EPM Agent. I am trying to configure Drill through without landin…RakeshRanjan 21 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform -
Load Data to a cube from a fileI have a csv file placed in a server. I need to create a integration to load data into cube and I need to pick the source file from the ftp server. Can you please sugges…Sri1309 51 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Can we use EPM agent for transferring Data from one table to another table in Peopesoft DB?Can we use EPM integration agent for transferring Data from one table to another table in same Peopesoft DB or other PSFT DB? Can we really replace ODI with epm agent fo…G,Sohini 11 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Attributes)Summary: Hi All, We are trying to integrate metadata from Oracle ERP to FCCS. How do we set up the attributes, especially for the entity, to set it to ICP_Entity_Yes, an…
-
Pipelines Connections strings appears only for File OperationsSummary: Pipelines Connections strings appears only for File Operations and not for other jobs (Example: Metadata exports of remote PODs) Content (please ensure you mask…
-
Metadata Integration from Oracle ERP to EPM export is not working in Data ExchangeSummary: Metadata Integration from Oracle ERP to EPM export is not working in Data Exchange but working in Data Management Hi All, I've noticed that whenever I run and e…
-
DM snapshot in the maintenance snapshotSummary: Hello Experts, I heard that by enabling LCM mode to Single Snapshot – Setup and Data, the maintenance snapshot includes a DM snapshot and when the maintenance s…
-
Change the time zone inside Pipeline or Data Integration log filesSummary: How can we change the time zone inside log files created under Process Details when a Pipeline or Data Integration job is executed. Content (please ensure you m…
-
Data Management Vs Data Exchange - Category Mapping works different?Summary: Data Management Vs Data Exchange - Category Mapping and filters for Scenarios are working differently Content (please ensure you mask any confidential informati…NarayananS 162 views 19 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Pipeline does not pickup default value unless passed in REST Execution. Expected behavior?Summary: Pipeline does not pickup default value unless passed in REST Execution. Expected behavior? Content (please ensure you mask any confidential information): Using …
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Consol Op)Summary: Hi All, we are trying to integrate metadata from Oracle ERP to FCCS Cloud using out of the box integration. We noticed that the Consol Operator were ignored. Wh…
-
Drilling down to BIP report up to Journal EntrySummary: We were able to load Accounts Payable subledger ending balances from ERP to ARCS thru BIP report. We were also successful in loading GL balances. We tried to us…
-
Difference between Upload and Move File Operations in PipelineSummary: Difference between Upload and Move File Operations Content (please ensure you mask any confidential information): What is the Difference between Upload and Move…
-
Data Comparison Report - data warehouse/ Fusion / EPMSummary: We are manually reconciling the data using data exports from Data warehouse/ Fusion / EPM and trying to match the if the data is up to date. We are trying to fi…
-
fdmee journals issueSummary: FDMEE multi-entities journals export double data Content (please ensure you mask any confidential information): I created an FDMEE load rule to export Currency …Pietro Paolo Pieroni 31 views 4 comments 0 points Most recent by Pietro Paolo Pieroni EPM Platform and Freeform
-
NetSuite and OICSummary: Can OIC help integrating NSPB (NetSuite Planning and Budgeting) with source systems? Is there in limitation in terms of type of connection or file type/ volumes…Ankita Roy-Oracle 12 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Data Integration Pipeline: How to run a pipeline for an integration which uses quick mode?Summary: You can't run an integration as part of a pipeline if the integration uses Quick Mode because the pipeline expects a start/end period and this concept doesn't e…
-
Is there any limitation of years in workbench for showing data by years?Summary: We have loaded 50 years of data(from flat file) into planning application from data managment. Workbench shows only first 20 years of data in DM but we can see …Aishwarya Waghmale-Oracle 31 views 6 comments 0 points Most recent by Aishwarya Waghmale-Oracle EPM Platform and Freeform
-
Authentication with OAuth 2.0 - Generate Refresh token from Access tokenSummary: We are trying to implement OAuth2.0 authentication in EPMAutomate utility for Automations of data loads and other application tasks. Content (please ensure you …
-
EPM to Object Store bucket in Private OCI tenancySummary: I can connect from EPM (Planning) to an object store bucket in the same tenancy as EPM, and I can Copy to/from that bucket. However, when I have a bucket in our… -
Business Rule behavior in PipelineSummary: Business Rule behavior in Pipeline Content (please ensure you mask any confidential information): Data Exchange Quick Mode Rule (EPM Automate Server-Side script…
-
956 ERROR [AIF]: Unable to download the fileHi Experts … I am running into this error when using Data Exchange to pull data from another instance of EPM. I have tried the following DataExchange options: a: Export …
-
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…
-
Metadata from ERP Cloud to EPM Cloud (Description Field)Summary: Metadata from ERP Cloud to EPM Cloud (Description Field) Content (please ensure you mask any confidential information): Hi All, I am trying to upload metadata f…
-
Data Exchange Quick Mode Import FailingNew setup of a Quick Mode Import integration into EPBCS is failing with the following. 2024-07-08 13:40:14,356 ERROR [QMP]: Error in executing quick mode processor:null …Dave Klover 141 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Inter EPM FX rate integration erroring outHi, We have built an interEPM FXRATE integration from FCCS(rates cube) to EPBCS. It is throwing the below error : Unexpected error: java.lang.RuntimeException: /u03/inb…MB001 31 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
How to add interdependencies of jobs within stages in pipelineSummary: Hi Oracle, Can you please let us know how we can add interdependencies of jobs within stages in pipeline? Code Snippet (add any code snippets that support your …
-
How to rename files with date & time stamp on Target side in pipelineSummary: Hi Oracle, How to rename files with date & time stamp on Target side in pipeline? Code Snippet (add any code snippets that support your topic, if applicable):
-
Pipeline with Conditional LogicSummary: Wondering if anyone has been able to achieve conditional logic inside of a Pipeline? Our goal is to create an ad-hoc execution of various different data loads t…
-
Bulk delete folders in data exchange file browser or Data ManagementSummary: How to delete multiple empty folders at once in the file browser in Data Exchange? Content We have setup an openbatch pipeline which processes all files placed …Jeroen Goudvis 51 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform