Registering Oracle ERP Cloud Applications

You can extract non-General ledger data from Oracle ERP Cloud data sources and load it to the Oracle Enterprise Performance Management Cloud. These types of data sources let you define an Oracle Business Intelligence Publisher report extract that is referenced by Data Integration to pull data directly from Oracle ERP Cloud sources like payables, receivables, fixed assets, and supply chain.

Data Integration provides prepackaged queries to the Oracle ERP Cloud sources including:

• Oracle ERP Cloud (Payable Transactions)
• Oracle ERP Cloud (Receivable Transactions)
• Oracle ERP Cloud (Trial Balance - Average)
• Oracle ERP Cloud (Trial Balance)

In addition, you can create and run a custom query against a BI Publisher data extract. In this case, use an Oracle ERP Cloud (Custom) data source adapter in Data Integration to import the source CSV file from BI Publisher, and then set the report parameters to use.

Note:

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

You must register source system for the Data Integration data sources using the 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.

To register an Oracle ERP Cloud application:

1. From the Data Integration home page, and then Actions, select Applications.

2. On the Applications page, click (Add icon).

3. From Category, select Data Source.

4. From Type, select the type of prepackaged Oracle ERP Cloud query.

   Available Oracle ERP Cloud types:

   • Oracle ERP Cloud (Payable Transactions)
   • Oracle ERP Cloud (Receivable Transactions)
   • Oracle ERP Cloud (Trial Balance - Average)
   • Oracle ERP Cloud (Trial Balance)

   The name of the prepackaged application that displays in the Application depends on the type of prepackaged Oracle ERP Cloud query selected in this field.

   

5. Optional: In Prefix, specify a prefix to make the application name unique.

   The prefix is concatenated with the application name to form a unique application name. For example, if you want to name an application with the same name as an existing one, you can assign your initials as the prefix.

6. Click OK.