1. Implementing Applications
  2. Import Data into Application Tables

Import Data into Application Tables

The final destination for your external data is the application data tables of your Oracle Fusion application.

Importing data into application tables involves the following:

  • Loading data into interface tables

  • Finding and submitting the import process

Loading Data into Interface Tables

Interface tables are intermediary tables that store your data temporarily while the application validates format and structure. Run the Load Interface File for Import scheduled process to load data from the data file into the interface table that corresponds to the template that you use to prepare the data.

To load your data into interface tables, submit the Load Interface File for Import scheduled process using the following steps:

  1. From the Navigator, click Tools.

  2. Click Scheduled Processes.

  3. Click the Schedule New Process button.

  4. Search and select the Load Interface File for Import job.

  5. On the Process Details page:

    1. Select the target import process.

    2. Enter the data file name.

  6. Submit the process.

If the process is successful, the status is SUCCEEDED and the process populates the interface tables. If the process isn't successful, the status is ERROR.

Note: The data file remains in the content repository after the process ends.

Finding and Submitting the Import Process

Run the appropriate import process to import the data into the interface tables of your Oracle Fusion application.

To import your data into the application tables:

  1. From the Navigator, click Tools.

  2. Click Scheduled Processes.

  3. Click the Schedule New Process button.

  4. Search and select the import process for the target application tables.

  5. On the Process Details page, select the process that corresponds to the data that you're importing. For example, Journal Import.

    If you prepared your data using the spreadsheet template, select the process shown in the Overview section of the spreadsheet.

  6. Submit the process.

If the process is successful, the status is SUCCEEDED. The data in the interface tables is validated and the successful records are imported into the Oracle Fusion application tables. If the process isn't successful, the status is ERROR.

Note: For more information on the process used for data prepared using the spreadsheet template, see the Instructions and CSV Generation tab of the spreadsheet template.

Related Topics