Integrating with Oracle Fusion Cloud Enterprise Performance Management

Use Oracle Enterprise Performance Management data integration as the mechanism through which integration processes are performed in Oracle Enterprise Performance Management.

You can define file-based and direct integration sources, create mapping rules to translate source data into the required target format, and execute and manage the periodic data loading process.

Note: If using ERP Integration Service to upload data to Oracle Fusion Cloud Supply Chain Planning, use importBulkData instead of loadAndImportData. The importBulkData operation uploads a file to the Oracle Universal Content Management (UCM) server based on the document details specified and submits a scheduled process to load and import the uploaded files to application tables.

Description	Integration Type	Integration Options	Notes
Load data from Oracle Enterprise Performance Management (EPM) to Oracle Supply Chain Planning using file-based data import (FBDI). Import Oracle EPM financial data, such as Budget Value and Financial Forecast Value, to Oracle Supply Chain Planning measures. Configuration of these measures is limited. Therefore, you might need to create more measures if you need to configure disaggregation parameters. You can also create unit-based measures. Use Oracle EPM data integration to run an integration process that generates a comma-separated values data file in Supply Chain Planning Measures (FBDI import process) format. Use ERP Integration Service to load and import the measures file. You can also use Oracle EPM data integration to automate this process. Run your Oracle Supply Chain Planning plan with the Refresh with current data option, or refresh measures incrementally without running the plan by using the Orchestrate Refresh Measures Processes scheduled process.	Inbound	Oracle EPM data integration FBDI ERP Integration Service	FBDI uses stored measures that can't be edited. Loaded measure data is available for all Oracle Supply Chain Planning plans using those financial measures.
Load data from Oracle EPM to Oracle Supply Chain Planning using REST APIs. Import Oracle EPM financial data, such as Budget Value and Financial Forecast Value, to Oracle Supply Chain Planning measures. Configuration of these measures is limited. Therefore, you might need to create more measures if you need to configure disaggregation parameters. You can also create unit-based measures. Use Oracle EPM data integration to run an integration process that generates a REST API payload for the inbound Oracle Supply Chain Planning measures table. Use the Planning Tables REST resource to create planning table data with the REST API payload in batch mode. This loads and disaggregates measure data while planners can continue to work in a plan. You can also use Oracle EPM data integration to automate this process.	Inbound	Oracle EPM data integration REST APIs	REST uses editable measures. More measures are required to reference and secure editable measures. Direct integration that's plan-specific with no plan run required. More flexibility with telescoped Oracle EPM data. For example, years 1 and 2 are modeled at a monthly level and years through 5 at quarterly level can be loaded into separate Oracle Supply Chain Planning tables with different time levels.
Publish data from Supply Chain Planning to Oracle EPM. Export Oracle Supply Chain Planning forecast measures, such as Consensus Forecast and Consensus Forecast Value, to Oracle EPM. Use the Publish Data plan action to export measure data from an Oracle Supply Chain Planning plans table to a compressed, comma-separated values (CSV) file on the Oracle Universal Content Management (UCM) server. Use Oracle EPM data integration to retrieve the comma-separated values file and run an integration process to transform and load the data file.	Outbound	Publish Plan Data Oracle EPM data integration	–

Description

Integration Type

Integration Options

Notes

Load data from Oracle Enterprise Performance Management (EPM) to Oracle Supply Chain Planning using file-based data import (FBDI).

Import Oracle EPM financial data, such as Budget Value and Financial Forecast Value, to Oracle Supply Chain Planning measures. Configuration of these measures is limited. Therefore, you might need to create more measures if you need to configure disaggregation parameters. You can also create unit-based measures.

Use Oracle EPM data integration to run an integration process that generates a comma-separated values data file in Supply Chain Planning Measures (FBDI import process) format.
Use ERP Integration Service to load and import the measures file. You can also use Oracle EPM data integration to automate this process.
Run your Oracle Supply Chain Planning plan with the Refresh with current data option, or refresh measures incrementally without running the plan by using the Orchestrate Refresh Measures Processes scheduled process.

Inbound

Oracle EPM data integration

FBDI

ERP Integration Service

FBDI uses stored measures that can't be edited.
Loaded measure data is available for all Oracle Supply Chain Planning plans using those financial measures.

Load data from Oracle EPM to Oracle Supply Chain Planning using REST APIs.

Use Oracle EPM data integration to run an integration process that generates a REST API payload for the inbound Oracle Supply Chain Planning measures table.
Use the Planning Tables REST resource to create planning table data with the REST API payload in batch mode. This loads and disaggregates measure data while planners can continue to work in a plan. You can also use Oracle EPM data integration to automate this process.

Inbound

Oracle EPM data integration

REST APIs

REST uses editable measures.
More measures are required to reference and secure editable measures.
Direct integration that's plan-specific with no plan run required.
More flexibility with telescoped Oracle EPM data.
For example, years 1 and 2 are modeled at a monthly level and years through 5 at quarterly level can be loaded into separate Oracle Supply Chain Planning tables with different time levels.

Publish data from Supply Chain Planning to Oracle EPM.

Export Oracle Supply Chain Planning forecast measures, such as Consensus Forecast and Consensus Forecast Value, to Oracle EPM.

Use the Publish Data plan action to export measure data from an Oracle Supply Chain Planning plans table to a compressed, comma-separated values (CSV) file on the Oracle Universal Content Management (UCM) server.
Use Oracle EPM data integration to retrieve the comma-separated values file and run an integration process to transform and load the data file.

Outbound

Publish Plan Data

Oracle EPM data integration

–