Data Integration
Discussion List
-
How to lock/unlock periods in Data ExchangeSummary: Looking for the functionality in Data Exchange that exists in Data Management to Lock/Unlock locations by Period. Content (please ensure you mask any confidenti…Stephanie Philopoulos 311 views 7 comments 0 points Most recent by Trey Daniel EPM Platform and Freeform -
Inclusion of rule description in output file generated in case of EPCM to GL direct integrationSummary: How to add journal description in data extract file automatically created in FBDI format in case to EPCM to GL direct integration Content (please ensure you mas…Deeksha Gupta EPM 31 views 4 comments 0 points Most recent by Deeksha Gupta EPM EPM Platform and Freeform
-
Is it possible to reference attributes in member mapping?Summary: I would like to reference values in an attribute dimension in a member mapping Content (please ensure you mask any confidential information): In my Product dime…
-
Drill through from EPM to Agent to Source (ERP Sub GL)Summary: Data is loaded to EPM from ADW which is in turn sourced from Oracle Sub Ledgers. Is it possible through drill through to this Sub GL directly instead of Agent d…
-
How I can send information from EPM Planning to a budgeting module in Oracle ERP CloudHello!! I need to create an integration to send information from EPM Planning to a budgeting module in Oracle ERP Cloud through Data Exchange using native integrations. …
-
EPM Integration Agent - "EPM_AGENT_INBOX" Parameter error when starting as a serviceContent Hi -- We just downloaded the latest agent as of 5/27 from Data Exchange. We first tested the agent connectivity using the non-service method and everything worke…
-
Exporting EPM Planning Data from EPM Cloud to Azure DatabricksWe are exploring the possibility of exporting planning data from EPM Cloud Planning to Azure Databricks. Is it feasible to establish a direct connection to Azure Databri… -
Loading zero values without NZPSummary: We are loading GL data from Fusion to EPM (ARCS). We did not use NZP on amount in the dimension mapping of the data load rules before. Despite that, zero values…Pieter-Jan Vandendriessche 41 views 7 comments 0 points Most recent by EPMTech_Wub EPM Platform and Freeform
-
Fusion GL Integration issue Parameter List - Period KeySummary: We are using the Fusion GL Integration to source Fixed Asset data to FCCS. This integration works fine except for december. There it takes the data from novembe…Pieter-Jan Vandendriessche 11 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform
-
Restricting zero Balance records at source while extracting data from ERP to EPMSummary: Hi, While loading data into EPM applications from ERP, is there a way to not extract the records where Period Activity is 0. For the code combination where ther…
-
Data Load failing in EPM Test but loading in EPM ProdSummary: We were able to load the same exact Integration in Prod but it is failing in test. Below is the error log from EPM Test: 2024-08-13 13:37:55,273 INFO [AIF]: FDM… -
Not able to extract unmapped Accounts list of all locations in one-goSummary:In ARCS Data Management, we have multiple locations and we have to extract report of Ignored Data from Data Load Workbench from each and every location which bec…Mohammed Shariff 11 views 2 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform -
Column limitation for Writing Back data to table using EPM Integration AgentSummary: What is the column limitation for Writing Back data from EPM cloud to DB Table using EPM Integration Agent? Here the question is: Does EPM cloud have column lim…
-
epm integration agent fail to execute nullI have a new instance in OCI with windows 2022, where I installed Java 21, Python 2.7.3, and EPM integration agent, but when initializing the agent, I get the following …SantiagoC. 21 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
How to call an OIC Integration from a from PBCS/Data Management Cloud?Hello Everyone, I am currently working on integrating Oracle Integration Cloud (OIC) with PBCS Data Management. Is it possible to trigger an OIC job from PBCS Data Manag…DarshanJ 31 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Pre-Validation Error report to check for the error of Data Management before execution of DLRsSummary: If there's any way to get the Pre-validation error report before the DLR execution for loading the data: To know if any member is missing (not in the system but…
-
Custom Attribute unique value can be added automatically in the LOV?Summary: Hi, I wanted to know if within the EPM scope we can add the new values automatically via integration (or any other way) into the Custom Attributes existing valu…
-
Unable to delete a file in the file browserSummary: Some files are not deleteable in the file browser. Content (please ensure you mask any confidential information): When users upload files in the file browser to…Pieter-Jan Vandendriessche 21 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform
-
Is it possible to backup an EPM environment to OCI buckets without EPM Automate?Summary: Currently we are using AWS Workspace to store our daily backups of all our 7 EPM environments via EPM Automate. I saw that you could also use OCI Buckets from O…Pieter-Jan Vandendriessche 21 views 4 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
You need a higher level of the 'Lists -> Documents and Files' permission to access this page.EPM Planning 25.01.31 Receiving the below error when running new Data Integration after setting up Netsuite Connection for the first time: RuntimeException: java.lang.Ru…
-
Can SSH keys be used for authentication in "copy from SFTP' rest api rather than username password?Summary: Content (please ensure you mask any confidential information): Link for REST API: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common…P2 Admin 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Enable drill-down to transactional data uploaded into the EPM Planning application via a flat file.Summary: Hello Experts, We are working on an integration where a flat file is used as the source to upload GL balances into the EPM Cloud Planning application. One of th…
-
GROOVY SCRIPT FOR ASO data exportSummary: Hi All, I have writeen a Groovy script to export the level0 data from the ASO cube to a csv file based on few conditions. Account dimension is not a compression…Sreekumar Hariharan 651 views 17 comments 0 points Most recent by SuneelKanthala EPM Platform and Freeform
-
Using Encrypted File as a Source for Uploading Data into EPM Cloud ApplicationHello Experts, I’m working with the Oracle EPM Cloud application and I would like to upload data from an encrypted file. Could anyone provide guidance or best practices …Ganipisetty N 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to pull data from sparse dynamic calc member in Data management PBCSHello Oracle Community, I’m working with Oracle PBCS and am trying to pull the parent values of sparse dynamic members using Data Management (DM). However, I’m encounter…
-
Is it possible to add a Data Map in the Action Menus so I can add it to a Form?I am trying to add a Data Map into the Form so when Users do a right-click on the form, they can do it themselves. I am wondering if this is possible. Smart Push in the …
-
Changing Default Time Zone and Restricting User Preferences in Oracle EPMSummary: Is it possible to change the default time zone of Oracle EPM pods to specific region time zone, as all our users are located in this region? Additionally, we wo…DarshanJ 73 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Write back from EPM to Oracle ERPHi! I couldn't find any documentation regarding how to write back data from EPM to ERP. Would it be possible to create an integration where EPM serves as the source and … -
How can I load rates through Data Exchange using the EPM Agent?Summary: Error in loading average rate and ending rate in Financial Consolidation and Close through Data Exchange using the EPM Agent. Content (please ensure you mask an…
-
Data Exchange Data Mapping Target Expression SQL Case statementSummary: In an EPM Planning Data Exchange integration, I need to replace a parent value and member value of “T” with another value like “T_Fund”. I cannot use Replace() …