Data Integration
Discussion List
-
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… -
EPM Data File does not show Import Format/Map and how to export this?Summary: When creating the data export to EPM Data File there is no option to upload Dim names as a CSV. Once a target app is created as EPM data file it does not allow …NarayananS 12 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Connecting EPM Integration Agent to Snowflake using OAuth2 login possible?Summary: We currently have EPM Integration Agent setup connecting to Snowflake with ARCS using a static user/password and Credential Store of Cloud. Our Tech department …
-
Upload file REST .out file - POSTMAN Vs Manual uploadSummary: Upload file REST .Out file - POSTMAN Vs Manual upload behaves different. POSTMAN upload of .out file is successful but when same .out file tried for manual uplo…
-
Exporting data such as smart list, date, text using data Data IntegrationSummary: Hello Team, I am trying to export data set with different types such as numeric, smartlist, and date in file using Data Export to File in Data Integration. Howe… -
When loading 0 rows, the system indicates its an errorSummary: We have recently created a pipline for data to flow between applications. But sometimes a data load rule inside of the pipeline does not contain any data. The s…Pieter-Jan Vandendriessche 51 views 4 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Custom Scripts UDA is not working in DM - #Custom{UDA([Account], "RLev0")} -Summary: #Custom{UDA([Account], "RPLev0")} - is not working in Dm data load other generic functions are working fine. getting this error a- 2025-03-17 23:37:02,698 ERROR…
-
How to update consolidation operator for "Not used for Cube"Summary: We need some help to pass the correct value in the integration to update the consolidation operator as Not used for Cube. Content (please ensure you mask any co…Tabish Neyaz 61 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Restricting End-User Access to Specific Data Integrations and PipelinesSummary: Hi There, We would like to know if there’s a way to grant end users access to specific data integrations or a particular pipeline. Content (please ensure you ma…Sashidhar Reddy 61 views 15 comments 0 points Most recent by Sashidhar Reddy EPM Platform and Freeform -
Clarification on EPM Agent Deployment in KubernetesSummary: We are exploring the possibility of configuring the EPM Integration Agent to work within a Kubernetes container. However, we could not find any official Oracle …Narayana N 21 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Data load from Autonomous DB to EPM fails through AgentSummary: When loading data from ADW to EPM the extraction step fails for the input at service name. 'unable to resolve' Content (please ensure you mask any confidential …
-
How to load multiple journal entries by using Journal Template (Downloaded from Workbench)Summary: In FCCS Instance, I am trying to load Journal Data through Data Management by using Standard Template which is downloaded from Data Load Workbench, but I'm unab…
-
Oracle EPM as Data Source for APEXHas anyone successfully configured an Oracle EPM application as a REST Data Source for APEX? Any tips or advice would be much appreciated… I see SaaS as a data source ty… -
Error validating mapping in data managementSummary: When creating/adjusting some mappings, I am suddenly unable to validate the mappings in data management. I get this error: "Unable to retrieve members. Either t…Pieter-Jan Vandendriessche 21 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform
-
MapsSummary: When I run and Integration like this, Import Mode - Replace Export Mode - Replace ...The maps for the Accounts dim do not get applied correctly and I get fallou…
-
Error in data load after changing a dimension nameHi all, I recently changed the dimension name of "Year" into "Years" because it clashed with Dynamic Time Series. Now I get following error when running the data load ru…
-
EPM Agent Automatic Vs Manual - Neither works when run as ServiceSummary: EPM Agent automatic does not work for scheduled jobs but whereas when set as Manual it works. Is there any issue with Agent running as a service when set to Aut…
-
Client Request for Automating Transaction Deletion via EPM Automate or agent (ARCS)Summary: The client wants to automate the deletion of transactions (transaction matching) using EPM Automate or an agent, and we have already informed them that it's not…Silvia Arraiol 11 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Simultaneous run of 2 data load rules and the 'concerning' error messageSummary: Simultaneous run of 2 data load rules and the 'concerning' error message Content (please ensure you mask any confidential information): We do have data load rul…
-
Data Exchange Integration Connection in EPM Cloud PlanningOracle EPM Cloud Planning allows integrated to Oracle ERP Cloud based on ESS Job or BIP reports. This functionality can be achieved by creating an application in EPM wit…
-
Invalid Mapping on the Account ID after successful dataloadSummary: Invalid mapping which shows the Profile as - (dash) after a successful dataload and despite data in the DLWB. Content (please ensure you mask any confidential i… -
Reconciliation Balances in Entered and Functional CurrencySummary: Reconciliation Balances in Entered and Functional Currency Content (please ensure you mask any confidential information): Our functional currency for the French…
-
Open Batch behaves differently for PCM and EPCM, but both are under common DM and follows same URLSummary: Open Batch behaves differently for PCM and EPCM, but both are under common DM REST and follows same URL then why is this inconsistent? Content (please ensure yo…
-
Pipeline not passing Source Filters to DLR after update 25.02.83Summary: Pipeline not passing Source Filters to DLR after update 25.02.83, this works in 25.01.31. Content (please ensure you mask any confidential information): Source …
-
https://localhost:9000/aif/rest/V1/jobsHello, I am using this connection for one of my pipeline and rule but since the 25.02 update, it is not working anymore. Can someone help me with a workaround? I tried u…
-
Has anyone had issues with Data Integration Mappings disappearing overnight?Summary: Mappings disappearing from Data Integrations overnight, across multiple Locations Content (please ensure you mask any confidential information): We've had a few… -
While building import format, new dimension is not visible in Data Management EPBCSWe created a new dimension named 'category'. While building import format, this dimension is not visible in the dropdown to map columns in EPBCS. We are using file based…
-
Issue while Importing ERP Cloud data into EPM applicationsSummary: Data is not getting imported into EPM application from Cloud ERP. Error at Import step. The request tries to Import data for 30 mins and eventually errors out C…
-
DataMap error-The dimension 50962 is invalid.In EPM cloud Planning data maps I am trying to save one of the DataMap (which is cross pod) and I got the error called "The dimension 50962 is invalid". Any suggestions/…
-
Mapping is not triggered/not visible in the workbenchSummary: When loading data into ARCS in this case, we do not see the triggered mapping when we click "view mapping" in the workbench. We have a mapping issue on that dim…Pieter-Jan Vandendriessche 11 views 1 comment 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform