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 laterInformation in this document applies to any platform.
Executable:QPXVBLK - Pricelist Bulk Loader
Purpose
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.
Scope
Users of Oracle Pricing applications.
Details
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
| Purpose |
| Scope |
| Details |
| 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 |
| References |