Import or Update a Large Number of Components for Price Lists

Use file-based data import (FBDI) to import or update a large number of items that are components of a configuration model. Import them for your price lists.

You can:

  • Import components that part of a configuration model.
  • Create charges for component items as part of the import process.
  • Do create and update operations.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Use the QP_PL_COMP_ITEMS_INT worksheet in the PriceListsImportBatchTemplate.xlsm file to import your components. You must include values in these attributes:

  • Component Item Number
  • Component Path
  • UOM Code
  • UOM Name
  • Source Price List Item ID
  • Source Price List Component Item ID

The worksheet has example values that you might find useful.

Oracle Pricing uses the Price Lists Batch scheduled process to manage a large volume of data on your price lists.

Key Resources

Access Requirements

No new privileges were introduced with this feature.