Process Description for Integrating Oracle ERP Cloud Using Prepackaged Queries

Data Management 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 Management:

1. An Oracle ERP Cloud integration requires that you have the privileges or user role and data access to all ERP. 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 a Source Connection for an Oracle ERP Cloud Source System

3. Register a target 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 Creating an Oracle ERP Cloud Data Source.

4. Provide any input values in the rule or 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 Working with Import Formats.

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

   See Defining Locations.

7. Define data mapping to map the members from the source to target.

   See Creating Member Mappings.

8. Define the data load rule and specify and source and target options.

   See Defining Data Load Rule Details.

9. Execute the integration.

   See Running Data Load Rules.