Data Integration
Discussion List
-
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 693 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 29 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 89 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 12 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 23 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… -
Data Exchange ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not existLoads are failing in Prod and we think the error is shown in the following lines of log: 2024-11-08 13:59:06,840 INFO [AIF]: Fetching dim col mapping for Application:Fin… -
How to customize the email subject or body in Pipeline notifications?Summary: In EPBCS Data Exchange, when triggering a data integration pipeline, the email notification defaults to the following format: Subject: "TestWorkforceMetadata : …
-
Can I get an artifact snapshot from an earlier date?Summary: I need an artifact snapshot from an earlier date as the on automatically created. Is it possible to get it from Oracle, since it is overwritten every night? Con…JSchil 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Bank File format load to Predictive Cash ForecastDoes Predictive Cash Forecast Plan type allow to load Bank (BAI2) file format files( for Balances and Transactions) using Data exchange with Category : Data Source ,Type…satishpatakota 62 views 3 comments 0 points Most recent by Chris P-Support-Oracle EPM Platform and Freeform
-
Editing Existing Pipeline Details & Save Remains Greyed Out?Summary: We have created a couple Data Integration Pipelines in FCCS that move data from our FCCS application to our EPBCS application & they work fine. When we needed t… -
Using OIC with Oracle PBCS - Where to find certificate?Hello, We are experimenting Oracle Integration Cloud and thinking of using PBCS with it to see if there are any processes that could be improved. I am looking at the Ora…