1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Registering Applications
  3. Registering Data Source Based Applications
  4. Registering Oracle ERP Cloud Custom Applications

Registering Oracle ERP Cloud Custom Applications

You can import data from the Oracle ERP Cloud using a custom query and load it into the Oracle Enterprise Performance Management Cloud. The custom query is run against any report from Oracle Business Intelligence Publisher that creates a CSV formatted data file. The system then loads the data to the EPM Cloud. In this case, Data Integration executes the report to extract the data and loads it to EPM Cloud. You use an Oracle ERP Cloud (Custom) data source adapter in Data Integration to import the source CSV file from Oracle Business Intelligence Publisher, and then set the report parameters to use.

Note:

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

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

For detailed information on integrating Oracle ERP Cloud data using a custom query, see Process Description for Integrating Oracle ERP Cloud Data Using a Custom Query.

To register a custom Oracle ERP Cloud application:

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

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

  3. From Category, select Data Source.

  4. From Type, select Oracle ERP Cloud (Custom).

    Image shows the Create Applications page.

  5. In File, specify the name of the CSV file associated with the Oracle Business Intelligence Publisher report from which to load data.

    Click Image shows the Search icon. to search for a file from the File Browser page.

  6. 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.

  7. Click OK.