Import Price Lists Batch
Use the Import Price Lists Batch scheduled process when you need to import price list data from interface tables into Oracle Pricing, including headers, items, charges, tiers, and attribute adjustments.
When to Use
Use this scheduled process when you need to migrate, convert, and maintain data for your price lists. Its particularly useful when you need to manage large volumes of data. For details, see Import Batches of Price Lists.
Privileges Required
- Import Price Lists (QP_PRICE_LIST_IMPORT_PRIV)
- Import Approved Price Lists (QP_PRICE_LIST_APPROVED_IMPORT_PRIV)
Specifications
Use these specifications when you run the scheduled process.
| Specification | Description |
|---|---|
| Job Type | We recommend that you use Scheduled, but you can also run it on demand, when needed. |
| Frequency | There are no no constraints. |
| Time of Day | Run it when your system isn't processing a lot of transactions. |
| Duration | Depends on the volume of data. Typically about one hour to process one million records. It will take longer if it encounters errors. |
| Compatibility | This is a built in feature. |
Parameters
The Import Price Lists Batch scheduled process uses the same parameters that you use when you import a price list. For details, see the Import Your Price List section in Import Price Lists.
Troubleshooting Information
If you import a batch of price lists, then make sure you set the Import Process parameter to Import Price Lists Batch when you run the Load Interface File for Import scheduled process.
Some of the guidelines and troubleshooting that you use to import a batch of price lists are similar to the ones that you use when you import a batch of discount lists. For details, see: