Loading Data from the Oracle ERP Cloud

You can pull a subset of data from the Oracle ERP cloud using Data Management as the integration mechanism without connecting directly to Fusion sources. Using this feature, you can import from data sources such as Oracle Financials or Supply Chain.

To do this, you use an data source adapter-based framework that queries data from BI report as a data source. BI Reports extracts EPR Cloud data directly from the Fusion database tables.. Any kind of record of record in the Oracle ERP cloud can be included in or considered as the basis of the query. When the system brings over the downloaded file into Data Integration, the data and metadata can be subsequently mapped and loaded to the Oracle Enterprise Performance Management Cloud.

You can use either be pre-packaged queries or customize BI reports to define your own report parameters for extracting the data from the Oracle ERP Cloud.