1. Integration Playbooks for SCM
  2. File-Based Data Import (FBDI)

File-Based Data Import (FBDI)

Use the FBDI option to import sales orders from multiple source systems.

The input item data file is a comma-separated values (CSV) file that's uploaded to Oracle Universal Content Management (UCM) using either an Oracle Fusion Cloud Enterprise Resource Planning (ERP) integration service or a SOAP or REST API to stage the data in interface tables.

Note: This integration option is recommended for customers who can batch orders and import them at predetermined intervals.

Key Features

  • Enables the import of a large volume of orders that are priced in the channel or priced using Oracle Fusion Cloud Order Management.
  • Enables asynchronous automated integration between systems.

Best Practices

  • Recommended for large volumes of orders. For example, anything more than 1,000 order lines per hour.
  • Also recommended if an order contains large number of lines. Typically, this is more than 50 lines in an order.
  • Increase number of child jobs to improve throughput.

Constraints

None.

Related Topics