Data Integration
Discussion List
-
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 11 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. 41 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 63 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… -
Issue with Loading Data into "Budget Adjustment" in EPBCS to Fusion Budgetary Control CubeHello All, We were able to successfully push data into the initial budget in the Fusion Budgetary Control cube. Now, we are trying to push budget transfers into the "Bud…DarshanJ 91 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
EPM Integration Agent- Writeback timeoutHi, I have an integration where I'm extracting to a target RDBMS (Snowflake). The essbase extract is successful. It is timing out. See log. I am using the same agent to …
-
How to load Begbalance data using epmautomate runIntegration?Summary: We need to load data at BegBalance and at No year. We need to load it using epmautomate runIntegration command. What is the correct way to use this command for …
-
CopytoObjectStore feature in pipeline doesnot copy file from Data Management specific locationSummary: I am using CopytoObjectStore feature in pipeline to copy file from Data Management specific location to Object Storage. In source path, I have selected Inbox an…Priyesh P. Rane 11 views 3 comments 0 points Most recent by Priyesh P. Rane EPM Platform and Freeform
-
How do you "review the newly created schedules"?Summary:Looking for clarification on how to complete step 4 in this guide. This is related to the functionality being sunset in Data Management and being moved to EPM Pl…
-
Export business rules and pipeline using EPM AutomateSummary: Hi Oracle, We want to export business rules and pipelines using EPM Automation command or any other automation so we can automate the process Version (include t…
-
data management epm cloudSummary: FCCS data management section expiring date Content (please ensure you mask any confidential information): does anyone know the official date of when data manage…samuel valecchi 11 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Sending Budget Data to Fusion Cloud in 'Add_Data' Mode via EPM Integration AgentHello everyone, We are working on transferring budget data from an Oracle database to the Budget Control module in Fusion Cloud using the EPM Integration Agent. Here's a…
-
Pull Dynamic Calc Member with DLRBackground: In FCCS, we currently have a level-0 member of the Account dimension (let's call it Account XYZ), which has a data storage type of "Dynamic Calc and Store". …
-
Exporting attribute values while exporting data into a file using DMSummary: While exporting data into a file from EPM application using data Integration, is it possible to export attribute values as well. For example, If we have Project…
-
Filter out amount less than 0.0001 in Data extract in FCCSWe need to filter out records that are between 0.0001 and -0.0001 while extracting data from FCCS application. We explored Skip row , however it is available in Data Int…