1. File-Based Data Import (FBDI) for Procurement
  2. Load Data into Tables

Load 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 Fusion Cloud Procurement. For example, you can create new purchase requisitions or import purchase requisitions from external applications into Oracle Procurement using the RequisitionImportTemplate.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 blanket purchase agreement line attributes in Oracle Procurement using the BlanketPurchaseAgreementTemplate.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 Fusion Cloud Applications.
  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. See Load Interface File for Import Process.

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

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. For additional details see, Using External Data Integration Services for Oracle ERP Cloud (Document ID 2102800.1) on My Oracle Support at https://support.oracle.com.