Registering Oracle Cloud ERP Applications

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

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

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

In addition, you can create and run a custom query against a BI Publisher data extract. In this case, use an Oracle Cloud ERP (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 Oracle Cloud ERP integration requires that you have the privileges or user role and data access to all ERP ledgers.

You must register source system for the Oracle Cloud ERP data sources using the system type Oracle Cloud ERP 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.

Note:

When configuring connections for Oracle Fusion Cloud EPM and Oracle Cloud ERP, the URLs specified for connections must use the secure HTTP protocol, for example, "https://server".

To register an Oracle Cloud ERP application:

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

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

  3. From Category, select Data Source.

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

    Available Oracle Cloud ERP types:

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

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

    Image shows Create Application page.

  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.