How (with Example Scripts) to Efficiently Load or Update Hundreds of Price Lists
(Doc ID 395262.1)
Last updated on JANUARY 06, 2025
Applies to:
Oracle Advanced Pricing - Version 11.5.9 and laterInformation in this document applies to any platform.
EXECUTABLE:QPXVBLK - Pricelist Bulk Loader
Goal
How does one load over 200 customer price lists?
Is there any customer sales price list API which we can use?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| A. QP: Bulk Import of Price List |
| Script to populate interface tables to insert price list header and price list line. |
| Script to populate interface tables to insert price list header and price list line and pricing attributes. |
| Script to populate interface tables to insert price list header and price break line. |
| Script to populate interface tables to update price list header with qualifiers. |
| Script to populate interface tables to attach secondary price lists to the primary price list |
| Additional Pricing Data Bulk Loader Resources: |
| B. Price List Setup API. (QP_PRICE_LIST_PUB.Process_Price_List) |
| Example Scripts For the Price List Setup API |
| Additional Process Price List Resources: |
| C. Create Price Lists Using Web ADI- New in Oracle Applications Version 12.2.9 |
| D. Tips for Processing Price List Lines |
| References |