Data Integration
Discussion List
-
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…Narayan 164 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 36 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 148 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 42 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
data exchange Import issue Applying Amount MappingSummary: I am facing issue during Import step of Data Exchange. Below error: It is allocation data writeback from EPCM to ERP. Integration is able to extract data out of…Ravinder Singh-63390 23 views 10 comments 0 points Most recent by Ravinder Singh-63390 EPM Platform and Freeform
-
Data Exchange Pipeline burst NR report across enviornmentsHello Anyone tried executing a Dataexchange pipeline ExecuteBurstdefenition successfully based on below scenario? Pipeline (e.g. Pipe1) is created in POD1 with a connect…
-
EPM Pipeline SubVar to Send Data to ERPSummary: We are trying to use SubVars to manage the Period we are sending data back to ERP from EPM, but we are getting Invalid Start Period error when executing the pro…
-
EPM Agent ExceptionSummary: EPM Agent has stopped working with the below error: Exception: java.lang.RuntimeException: Error occurred while calling EPMI agent: javax.net.ssl.SSLHandshakeEx…
-
Oracle EPM cloud to AWS Latency issue.We are using EPM integration agent to do writeback from EPM cloud to a data warehouse in AWS. We are seeing significant latency while doing this writeback. The ping test…
-
401 error when running data integration in data exchangeSummary: When running a data integration I am receiving a 401 error for the target application. I am using a service account. I verified the service account can log into…