All Submissions Of The QP: Bulk Import Of Price List Are Failing With The Same Error QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #200 Unexpected exception ORA-01422: exact fetch returns more than requested number of rows
(Doc ID 1585452.1)
Last updated on JULY 19, 2021
Applies to:
Oracle Advanced Pricing - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Price List
QPXVBLK module:
When attempting to run QP: Bulk Import of Price List
the following error occurs.
ERROR
-----------------------
QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #200 Unexpected exception ORA-01422: exact fetch returns more than requested number of rows
ORA-01403: no data found
DUP_LINE_CHECK Unexpected Exception User-Defined Exception
Unexpected error
User-Defined Exception
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the QP interface tables
2. Gather statistics on the interface tables.
*Optional step, yet important to ensure good performance.
3. Responsibility: Oracle Pricing Manager
Navigate to: Reports
Run QP: Bulk Import of Price Lists
NOTES
-----------
Applied patches per Note 1182973.1 for Minimum R12.1.x Patches To Address All Issues.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |