My Oracle Support Banner

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 JUNE 15, 2021

Applies to:

Oracle Advanced Pricing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Pricing Engine

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:


ERROR
-----------------------
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


STEPS
-----------------------
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
and populate parameters; be sure to set "Enable Duplicate Line Check" = Yes
3. Submit request with debug enabled.
4. Review Log file

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


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