Process Description for Integrating Oracle ERP Cloud Data Using Prepackaged Queries

Data Integration ships with prepackaged queries that leverage seeded data extracts provided by Oracle ERP Cloud 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 Oracle ERP Cloud using the prepackaged queries shipped with Data Integration.

1. An Oracle ERP Cloud integration requires that you have the privileges or user role and data access to the Oracle ERP Cloud. For more information, see Security Role Requirements for Oracle ERP Cloud 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 Oracle ERP Cloud Connection.

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

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

   See Registering Oracle ERP Cloud 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.

5. Set up the integration mapping between the Oracle ERP Cloud 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.