My Oracle Support Banner

How (with Example Scripts) to Efficiently Load or Update Hundreds of Price Lists (Doc ID 395262.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Oracle Advanced Pricing - Version 11.5.9 and later
Information 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.