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 JANUARY 13, 2023

Applies to:

Oracle Advanced Pricing - Version 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

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