Data Integration
Discussion List
-
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… -
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…
-
ERP to EPM Adjustment period loads fail INFO [AIF]: Current polled request status is: WAITSummary: Hi, I am trying to integrate the Adjustment Period(13th and 14th period ) data from ERP to EPBCS. My DLRs with Adjustment period mapping runs for 30 mins and it…
-
Issue while Importing ERP Cloud data into EPM applicationsSummary: Data is not getting imported into EPM application from Cloud ERP. Error at Import step. The request tries to Import data for 30 mins and eventually errors out C…
-
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. 43 views 6 comments 0 points Most recent by Claudio Caceres M. EPM Platform and Freeform -
Loading Dates to ASO Cube Through Data ExchangeSummary: We are trying to load dates directly to an ASO cube through Data Management and they do not seem to be getting loaded. Content (please ensure you mask any confi…
-
Restricting End-User Access to Specific Data Integrations and PipelinesSummary: Hi There, We would like to know if there’s a way to grant end users access to specific data integrations or a particular pipeline. Content (please ensure you ma…Sashidhar Reddy 22 views 4 comments 0 points Most recent by Sashidhar Reddy 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…
-
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 350 views 16 comments 0 points Most recent by Sreenivasula Reddy EPM Platform and Freeform
-
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
-
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 …mikebf53 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 11 views 1 comment 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 64 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 95 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 …
-
2Pipeline Parent and Child Jobs MonitoringSummary: We want to monitor all the Parent/Child pipelines jobs for the status as part of automation, The REST response provides the GET of the pipeline but not all the …NarayananS 361 views 36 comments 2 points Most recent by Sreekumar Hariharan EPM Platform and Freeform
-
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 12 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform