My Oracle Support Banner

QP: Bulk Import of Price List - Current Issues For Oracle Applications R12.1 (Doc ID 1182973.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Oracle Advanced Pricing - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
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.1.x, it is suggested to address each fix listed below before setting up and testing Bulk Loader.

Minimum R12.1.x Patch(s) To Address All Issues
 1. Upon warning message, bulk load deletes pricing attribute
 2. UNEXCPECTED ERROR In Procedure ENTITY_LINE: ORA-01403: no data found, while running in UPDATE mode.
 3. Bulk Loader Ends In Error ORA-01427 Copy Price List Results in Duplicate orig_system_header_ref
 4. Bulk Load Poor Performance
 5.  Add Items to the Price List Results in Same ORIG_SYS_HEADER_REF For New and Source Price Lists
 6. Copy Price List Results in the Same ORIG_SYS_HEADER_REF for New and Source Price Lists
 7. QP Bulk Loader is Not Inserting Qualifiers
 8.  QP: Bulk Import Of Price List Completes In Error When Submitted With Japanese Language
 9. Poor Performance for Bulk Import Of Price List
 10. Performance Issue Using QP: Bulk Import of Price List
 11. Pricing Bulk Load Program Error: Not a valid ID. CURRENCY HEADER
 12. Importing Large Number of Price Lists Headers With Price Break Lines Results in Errors
 13. Poor Performance QP: Bulk Import Of Price List
 14. Submissions Fail with Error QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #200 Unexpected exception ORA-01422: exact fetch returns more than requested number of rows
 15. Run QP: Bulk Import of Price List with 31-DEC-9999 as End Date Results in Error "Start Date must start before End Date"
 16. Poor Performance For QP: Bulk Import Of Price List
 17. Performance Issue With QP: Bulk Import Of Price List Program
 18. Bulk Loader Not Loading PRIMARY_UOM_FLAG for Shared Pricing Installation
 19. Bulk Load Poor Performance When Updating Price List
 How to Extract Trace, tkprof and log file needed for Performance Evaluation on Oracle Applications Release 12.x using RDBMS 11g. 
 Tips for Using Non-Continuous Price Breaks
 Tips if One Exceeds Maximum Open Cursors

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