Data Integration
Discussion List
-
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 12 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 12 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 32 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 42 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 654 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 62 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() …
-
How to populate agentContext["INTEGRATION"] for File based source systemSummary: We've a required to pickup the file from agentinbox folder into Data Integration. We're using EPM agent event script (BefExtract.py) Jython scripting to copy th…Kishan Kesanakurthy 16 views 2 comments 0 points Most recent by Ganesh Karri EPM Platform and Freeform
-
Capture error/.out file from Data management processWe are encountering an issue in the Oracle EPM Data Management process while executing a data load rule. The process fails, and the detailed error is logged in the .out …Poorna durga 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
audit EPM planning query changesSummary: Is there an audit of the changes to the Data Exchange queries in EPM? We need to be able to review these changes on a weekly basis. Content (please ensure you m…Steven Taylor 23 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGESummary: ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGE Content (please ensure you mask any confidential information): Hi Team, We are trying to load data…
-
How to migrate FDMEE reportSummary: We built FDMEE in a Dev environment and want to move to QA. We copied over the FDMEE application folder and I used LCM to import. I don't see the reports under …
-
EPM Integration Agent - Cloud Credentials Vs FileSummary: Have used EPM Integration Agent in past with Cloud as credentials in DM filters but it does not work anymore and only File works. What am I missing here? Conten…
-
Data Exchange: How to Change Encoding?I have a data source setup as a "File" type. Sometimes UTF-8 makes sense to use on an integration uploading data via a file and other times I need to use UTF-16LE using …