1. Administering Pricing
  2. Guidelines for Importing Cost Lists

Guidelines for Importing Cost Lists

Use file-based data import to import a large number of cost lists.

  • Create headers for your cost lists, access sets, items on cost lists, and charges.
  • Use a cost list to set up cost plus pricing, or to calculate part of the profit margin for a charge.
  • Add access sets, items, and charges to a cost list that already exists.

You might find this feature useful when you maintain the costs that you use to determine price or margin outside of Oracle Pricing. You can import costs into a cost list, then use them to determine cost plus pricing or to calculate margin in the price breakdown on the order line in Oracle Order Management.

  • Efficiently create a large number of cost lists.
  • Process all your import data quickly with a single import.
  • You can create new cost lists, cost list items, and cost list charges.
  • You can't use this feature with configured items, coverages, or subscriptions.

The concepts, guidelines, and procedures that you use to import costs list are similar to the concepts, guidelines, and procedures that you use to import batches of price lists and discount lists. Here are some important differences:

  • Make sure you have these privileges:
    • Import Cost Lists (QP_COST_LIST_IMPORT_PRIV). Import cost lists that are in progress.
    • Import Approved Cost Lists (QP_COST_LIST_APPROVED_IMPORT_PRIV). Import cost lists that are approved.
  • Download the CostListsImportTemplate.xls file. Go to File-Based Data Import (FBDI) for Oracle SCM, Order Management > Cost List.
  • Add your cost lists, items, and charges to the template.

For more, see Import Batches of Discount Lists.

Click here to view a demonstration that illustrates how to use the cost list template. The demonstration starts at 01:52.

Update a Large Number of Cost Lists

You can also use file-based data import to update a large number of cost lists.

  • Update headers for your cost lists, access sets, items on cost lists, and charges.
  • Use a single action to end date charges on cost list items, and then create new charges.
  • View and fix validation errors that happen during import.
  • Delete cost list headers, access sets, items, and charges from interface tables after the scheduled process is done running.

Note

  • Download and use the Cost Lists Import template.
  • The Maximum Number of Child Processes parameter comes with a default value of 20. You can update it, as necessary. For details, see Manage Pricing Parameters.
  • You can't use this feature with configured items, coverages, or subscriptions.