Registering Oracle Cloud ERP Custom Applications

You can import data from the Oracle Cloud ERP using a custom query and load it into the Oracle Fusion Cloud Enterprise Performance Management. 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 Cloud EPM. In this case, Data Integration executes the report to extract the data and loads it to Cloud EPM. You use an Oracle Cloud ERP (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 Cloud ERP integration requires that you have the privileges or user role and data access to all ERP ledgers to integrate data from the Oracle Cloud ERP. For more information, see Security Role Requirements for Oracle ERP Cloud Integrations.

You must register source system for the Oracle Cloud ERP 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 Cloud ERP data using a custom query, see Process Description for Integrating Oracle Cloud ERP Data Using a Custom Query.

To register a custom 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 Oracle Cloud ERP (Custom).

    Image shows the Create Application 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.