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

File-Based Data Import (FBDI)

Use the FBDI integration option to import price list, discount list, and cost list data from other source systems into Oracle Pricing.

The input data file is a comma-separated values (CSV) file that's uploaded to Oracle WebCenter Content with either Oracle ERP Integration Web Services or data staged into the interface tables.

Import Price Lists and Price List Batches

Key Features

Import a large volumes of price list data from secure content-management servers (for example, Oracle WebCenter Content) that provide controlled access to external systems.

Best Practices

  • Recommended for large-volume price lists with more than 5,000 lines.
  • Review the Commit Point parameter in the Import Your Price List table.
  • Increase the number of child jobs to improve throughput.
  • Delete the interface data periodically for better performance.
  • You can use the Update operation with PriceListsImportBatchTemplate.xlsm but not with PriceListImportTemplate.xlsm.
  • PriceListsImportBatchTemplate.xlsm is faster, even if you're importing a single price list.

See Troubleshoot Importing Price Lists for more information.

Constraints

None.

Import Discount Lists

Key Features

Import a large volumes of discount list data from secure content-management servers (for example, Oracle WebCenter Content) that provide controlled access to external systems.

Best Practices

  • Recommended for large-volume discount lists with more than 5,000 lines.
  • Increase the number of child jobs to improve throughput.
  • Delete the interface data periodically for better performance.

See Troubleshoot Importing Batches of Discount Lists for more information.

Constraints

Discount List Tiers aren't available through Import Discount Lists.

Import Cost Lists

Key Features

Import large volumes of cost list data from secure content management servers (for example, Oracle WebCenter Content) that provide controlled access to external systems.

Best Practices

  • Recommended for large-volume cost lists with more than 5,000 lines.
  • Increase the number of child jobs to improve throughput.
  • Delete the interface data periodically for better performance.

See Guidelines for Importing Cost Lists for more information.

Constraints

You can't use this feature with configured items, coverages, or subscriptions.

Related Topics