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 AUGUST 07, 2020

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information 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. * NEW * Updates the Last_Update_Date Columns of All Price List Lines When Pattern Search is Switched
References

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