1Overview

External Data Integration Services for Oracle Cloud

Use External Data Integration Services for Oracle Cloud to load data into Oracle Fusion Applications from external sources, such as legacy systems and third-party applications.

External Data Integration Services for Oracle Cloud include the following components:

  • Templates to structure, format, and generate the data file according to the requirements of the target application tables.

  • File-based load process to load the data files into the interface tables.

  • Application-specific data import processes to transfer data from interface tables to the application tables in your Oracle Fusion Applications.

The following flow diagram outlines the steps involved in the process.

This graphic shows the steps of the process, including downloading and preparing the data file template, correcting errors, and uploading the file successfully.

Viewing Details About Predefined Scheduled Processes

Use the Setup and Maintenance work area to view details about the job definitions that scheduled processes are based on. For example, you can find information about parameters, and other technical details. You might also need to find security requirements for running the scheduled process.

Job Definitions

A job definition contains the metadata that determines how a scheduled process works and what options are available during submission.

To view job definitions:

  1. Go to the Setup and Maintenance work area.

  2. Run a search with Manage Custom Enterprise Scheduler Jobs as the search term.

  3. In the search results, open the Manage Custom Enterprise Scheduler Jobs task for the application that contains the job definition. Tasks with names that end in and Related Applications include multiple applications.

  4. In the Manage Job Definitions tab, select your job definition and click Edit.

    Note: Predefined job definitions are marked with an asterisk.
  5. Cancel after you get the information you need.

Security

Privileges provide the access needed to run specific scheduled processes. Privileges are granted to duty roles, which are granted to job roles. To see which job roles inherit the needed privileges, use the Security Console or the security reference manuals for the appropriate product family.

Loading Data into Tables

Use the file-based data import feature to import large volumes of data from third-party or other Oracle applications, or create new data in Oracle Supply Chain Management Cloud. For example, product data stewards can import new items into Oracle Fusion Product Hub using the ItemImportTemplate.xlsm template.

You can also use some file-based data import features to update large volumes of existing data in the application. For example, you can update item relationships in Oracle Fusion Product Hub using the ItemImportTemplate.xlsm template.

Load Data into Interface Tables

Perform the following steps to load data to the interface tables:
  1. Download the relevant file-based data import template.

  2. Enter data in the template.

  3. Click the Generate CSV File button on the Instructions and CSV Generation worksheet in the template to create the CSV files in a zip file format.

  4. Save the zip file locally.

  5. Sign in to Oracle Applications Cloud.

  6. From the Navigator, click File Import and Export under Tools.

  7. From the Search Results area, click Actions > Upload.

  8. Click Browse to search for and select the zipped data file you saved.

  9. Select the account for the applicable file-based import process.

  10. Click Save and Close to transfer the zipped data file to the Oracle Universal Content Management Cloud server.

  11. From the Navigator, click Scheduled Processes under Tools.

  12. Select the import process and the locally saved data file.

  13. Submit the Load Interface File for Import process to upload the data from the CSV files to the interface tables.

Load Data into Product Tables

Perform the following steps to load data from the interface tables to the product tables:
  1. Navigate to the Scheduled Processes page.
  2. Verify that the Load Interface File for Import process completed successfully.
  3. Submit the product-specific import process.
  4. Verify that the import process completed successfully.

Manage Data in Interface Tables

To manage the growth of product interface tables, there is an automatic process to purge the interface tables that is initiated for each file-based data import process for data records older than 30 days. You can also use the Purge Interface Tables process to manually delete data from the interface tables of a specific import process.

Use Web Services

You can automate the entire inbound data flow using web services as an alternative to the manual approach outlined above. In addition, you can manage data from product interface and error tables with streamlined purge capabilities. For additional details see, Using External Data Integration Services for Oracle ERP Cloud (2102800.1) on My Oracle Support.