My Oracle Support Banner

QP: Bulk Import of Price List - Current Issues For Oracle Applications R12.2.X (Doc ID 2088913.1)

Last updated on JULY 14, 2021

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.
Executable:QPXVBLK - Pricelist Bulk Loader


To aid in problem resolution

Still Have Questions?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Advanced Pricing Community.


Users of Oracle Pricing applications.


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
 For Oracle Applications Release 12.2.x, it is suggested to address each fix listed below before setting up and testing Bulk Loader.

Minimum R12.2.x Patch(s) To Address All Issues
 1. Unable To Import Product Attribute Values Greater Than 30 Characters For Pricing Attributes/ORA-06502: PL/SQL: numeric or value error: character string buffer too small
 2. Run QP: Bulk Import of Price List with 31-DEC-9999 as End Date Results in Error "Start Date must start before End Date"
 3. Poor Performance For QP: Bulk Import Of Price List
 4. 'QP: Bulk Import Of Price List' Not Populating Orig_sys_qualifier_ref In Errors Table
 5. Performance issues encountered when using Update functionality in Bulk Import for Price List
 6. Updates the Last_Update_Date Columns of All Price List Lines When Pattern Search is Switched
 7. Price List Bulk Import Program (QP: Bulk Import Of Price List) Unexpected Error In QP_BULK_UTIL.UPDATE_LINE:ORA-00001: unique constraint (QP.QP_LIST_LINES_U1) violated

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