QP: Bulk Import of Price List - Current Issues For Oracle Applications R12.1
(Doc ID 1182973.1)
Last updated on JULY 15, 2021
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|