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
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.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 |
| References |