Data Integration
Discussion List
-
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 … -
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 …
-
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 48 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…
-
Unlock by Location does not work in CLOUDSummary: I'm unable to unlock a single location once a period is locked. Steps are as follows: 1) In DM, under Application Settings, choose Target Application and then L…
-
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 54 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data Management - Passing Start Period and End Period to Business RulesContent In Data Integration I have a business rule that performs calculations post load for the period range loaded i.e. DM POV Start and End Period range. In DM Cloud, …Dinesh Chand 226 views 6 comments 2 points Most recent by Anandita Biswas-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 55 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
-
2Pipeline Parent and Child Jobs MonitoringSummary: We want to monitor all the Parent/Child pipelines jobs for the status as part of automation, The REST response provides the GET of the pipeline but not all the …
-
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… -
Set Administration Mode in PipelineSummary: Set Administration Mode in a Pipeline fails Content (please ensure you mask any confidential information): Has anyone been able to set up an Administration Mode… -
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 12 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…
-
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…
-
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…
-
Please advise on how to extract Data Management Workbench data before Logic Group logics are appliedSummary: We have a process to extract Data Management workbench data (using SQL query) for all the locations for any specific period. Our process is working fine. Genera…