Data Integration
Discussion List
-
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. 23 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 35 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 35 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 23 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 700 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 23 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 103 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 14 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 21 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 21 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 …
-
EPM Integration Agent connection with JDE on IBM DB2Summary: I'm trying to configure the Integration Agent to pull data from an IBM DB2 Table on-premises into FCC (Data Exchange). I couldn't find any relevant documentatio…Claudio Caceres M. 42 views 6 comments 0 points Most recent by Claudio Caceres M. EPM Platform and Freeform -
Pipeline moved on before job finshed and sets pipeline to failed (even though no error)Summary: Our pipeline emails are showing as failed if a job is still running when it ends. It is also moving onto the next job rather than waiting for the job to finish.… -
How to Pull Incremental Metadata from Fusion to PBCS via Data ManagementHello Team, We are working on integrating metadata (Account, Entity, Custom) from Oracle Fusion to a PBCS application using Data Management in Oracle Cloud. Our goal is …
-
Data Integration with conditional factoring of the data/amount columnContent: We load multiple accounts worth of data, value-based and score-based. Both accounts come from the same csv-file and have the same formatted amounts, however sco…
-
How to integrate oData with EPM Integration Agent using REST call.Issue SAP REST API response will be in JSON format. Data Management can only import delimited files and not JSON files. Requirement Load JSON file to Data Management usi…
-
Clear Region feature to clear ERP Cloud scenario runs in errorDear community, Oracle Development, We would like to use the Clear Region feature in Data Exchange to clear a specific Accounting Scenario (LE9+3) in ERP Cloud, before w…