My Oracle Support Banner

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

Last updated on DECEMBER 07, 2018

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:
References

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