Data Integration ships with prepackaged queries that leverage seeded data extracts provided by Oracle Cloud ERP as data sources.

For more information about Oracle Business Intelligence Publisher, see Oracle Business Intelligence Publisher 12.2.1.3.0.

These are the steps for loading data from the ERP using the prepackaged queries shipped with Data Integration.

1. An ERP integration requires that you have the privileges or user role and data access to the ERP. For more information, see Security Role Requirements for ERP Integrations.

2. Register the source system for the source system type Oracle ERP Cloud and specify your user credentials.

   This step includes specifying the connection details and testing the connection.

   For more information, see Configuring an ERP Connection.

3. Register the application as an ERP data source application type and save it.

   The source columns are populated automatically from the uploaded file extract.

   See Registering ERP Applications.

4. Provide any input values in integration options in Application Filters.

   Note:

   Define any necessary filters to limit the amount of data returned by the BI Publisher extract. Filters ensure the best load performance. Oracle recommends you use the fully Qualified name for a Ledger in the Source Filter.

5. Set up the integration mapping between the ERP data source and the target application by building an import format.

   See Mapping Dimensions.

6. Define the location used to associate the import format.

7. Map dimensions between the source and target.

   See Mapping Dimensions.

8. Map members from the source to target.

   See Mapping Members.

9. Select any source and target options.

   See Setting Data Integration Options.

10. Run the integration.

    See Running an Integration.