1. File-Based Data Import for Oracle Public Sector Compliance and Regulation
  2. Overview

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 loading data from external sources.

This graphic shows the steps of the process, including downloading and preparing the data file template, loading data to interface and application tables, and correcting errors. The result being data is successfully uploaded to the product tables.

    Related Topics

    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 Public Sector Compliance and Regulation. For example, you can import address, parcel, and owner (APO) data into the PSC_COM_PARCEL_B, PSC_COM_PARCEL_ADDRESS, PSC_COM_PARCEL_OWNER, and PSC_COM_PARCEL_VALUE_F tables using the AddressParcelOwnerImportTemplate.xlsm template.

    You can also use certain file-based data import features to update large volumes of existing data in the application.

    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 as a user with the ORA_PSC_SYSTEM_ADMINISTRATOR_JOB role.

    6. From the Navigator menu, click File Import and Export in the Tools section.

    7. Click the Upload icon. Click Browse to search for and select the zipped data file you saved.

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

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

    10. Navigate to the Scheduled Processes page, and click the Schedule New Process button.

    11. Select Job in the Type field, and Load Interface File for Import in the Name field. Click OK to upload your data from the CSV files to the interface tables.

      Note: Some data import processes will prompt you to select additional parameters before submitting the process. In this case, the process also loads data from the interface tables to the product 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.

    Note: Not all Public Sector Compliance and Regulation file-based data imports require you to perform these steps.

    Manage Data in Interface Tables

    To manage the growth of product interface tables, there is an automatic purge interface table process 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 tables.

    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 (https://support.oracle.com).