Data Integration
Discussion List
-
Building Reports Against the Data Integration SchemaThe Administering Data Integration documentation has a section that provides details of the data integration tables to help build reports. Here is the link to the sectio…ppant ppant 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
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…Debbie Schwind 2 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
What hampers performance of DLR (data load rule in data exchange)Summary: What hampers performance of DLR (data load rule in data exchange), there are only 6 rows of data.. but it takes 30 mins to push the data Content (please ensure …Subhojyoti Chakraborty 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data Integration can only select first 6 target Plan typesSummary: We have a Freeform application with 8 Plan Types. When creating a new data integration to load from a file we can only see the first 6 of them in the target Cub… -
EPM Agent SQL parametersWe have this source query which is working well (see below), but we need to add a bit to update the period value. For example, if the EPM period (~Period~) is 02 then @P…
-
Data Management Mapping question - when two different categories of mapping for the same dimensionI need to set up a Data Management Load rule to transfer data from CPX to FIN cube in a custom Planning application. The source of the mapping must vary based on whether…Partha Sikdar 11 views 3 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
1remove restricted characters within data integration for attributesSummary: Current data integration Edit Source Expression functionality is limited with regards to Restricted Character handling Content (please ensure you mask any confi…
-
Using encrypted key pair authentication to connect to Snowflake through integration agentSummary: We are trying to connect to Snowflake using a JDBC driver through integration agent. I've added the following to my .ini file: [AGENT_JDBC_CONNECTIONS] snowflak…bpepper 88 views 1 comment 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
groovy rule to track changed data to get entities loaded via data management in FCCSSummary: Requirement: We are currently looking to optimize our data load process and are looking for a way to track which entities have actually loaded to the applicatio…Amarnath_Kothapalli 21 views 3 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Looking for a way to use Azure service principal for connecting to EPMSummary: Hi, Looking for a way to use the Oracle EPM API through azure service principal instead of service account for authentication purpose? Found the below blog but …Tushant Pandey 1 view 1 comment 0 points Most recent by Abhinav Jain-Oracle EPM Platform and Freeform
-
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…
-
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 11 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 63 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 62 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 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…