Data Integration
Discussion List
-
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 17 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 143 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 59 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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…
-
EPBCS - what are the reasons for 200MB limitation for export file in EPBCS?Hi, Currently there is a limitation of 200 MB on the size of the export file when executing a Datamap in EPBCS via a Groovy Rule which is causing us a bit of a headache …AyandaKrumalo12 97 views 2 comments 0 points Most recent by AyandaKrumalo12 EPM Platform and Freeform -
EPM REST Download ZIP file not as a content but the actual file - Metadata ExportSummary: EPM REST allows to download ZIP as a content but wanted to know if it can be downloaded as a file itself same as EPM Automate? The concern is as is it zip it do…NarayananS 41 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Pipeline Integration for Non-admin UsersSummary: Hi , Can Pipeline Integration jobs be executed by Non-admin Users? Any thoughts on this Content (required): Version (include the version you are using, if appli…
-
Groovy Pipeline execution - Variables are mandatory?Summary: Using a Groovy BR to trigger a pipeline (export mapping job) and it was working fine with no variables defined. When the rule was triggered today interestingly …NarayananS 11 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
How to Pass System date and (System date-1) value for BIP report integration parameter valueHi Everyone, We've a requirement where i need to use From Date and To Date as parameters for BIP report integration in Data Management. I know we can use $SYSTEM_DATE[yy…Kishan Kesanakurthy 143 views 2 comments 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
How to export the DM of all process details logs into an excel format with status for month in EPBCSSummary: We need to export EPBCS Data Management process details logs with status into an excel/report. This report is for auditing purpose on monthly basis. Is there a …Neelima Dasari-78355 41 views 2 comments 0 points Most recent by Krishna_0601 EPM Platform and Freeform -
Error when trying ERP FX Rates Integration to EPM CloudHi, As per the latest EPM patch, we can now have direct integration of ERP FX Rates Integration to EPM Cloud. But when we tried running the process, we received the foll…Guntuka VenkataKrishna 154 views 2 comments 1 point Most recent by Randa-Support-Oracle Enterprise Data Management
-
Pipeline execution stop/resetSummary: When executing/invoking a pipeline (REST) from Groovy if in case the pipeline name is incorrect or if a param or comma is missed the pipeline keeps polling and …NarayananS 21 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform