Advanced Pricing(QP): Bulk Import Of Price List Is Erroring Out With Error: QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #200 Unexpected Exception User-Defined Exception
(Doc ID 2769639.1)
Last updated on JANUARY 13, 2023
Applies to:Oracle Advanced Pricing - Version 184.108.40.206 and later
Information in this document applies to any platform.
One has inserted data in Pricing interface tables and ran the program QP: Bulk Import of Price List
but it is not inserting data into price list rather it is erroring out without any errors in Error Tables.
One can see the following errors in debug file:
QP: Bulk Import of Price List Log file shows error(s):
QP_BULK_VALIDATE.CHECK_DATES_OVERLAP date not found in qp_list_lines and qp_interface_list_lines
QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #200 Unexpected exception User-Defined Exception
DUP_LINE_CHECK Unexpected Exception User-Defined Exception
The issue can be reproduced at will with the following steps:
1. Populate the QP Interface tables.
2. Select Oracle Pricing Manager Responsibility
3. Navigate To: Reports
Select single request
Name = QP: Bulk Import of Price Lists
Populate parameters; be sure to set "Enable Duplicate Line Check" = Yes
3. Submit request with debug enabled.
4. Review Log file
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