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:

Symptoms

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


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

Changes

Cause

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