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|