My Oracle Support Banner

Error In QP Bulk Import "QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #100 Unexpected exception ORA-01422: exact fetch returns more than requested number of rows" (Doc ID 2741043.1)

Last updated on JANUARY 14, 2022

Applies to:

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

Symptoms

Running Bulk Import of Price List results in error.

ERROR
--------
Log shows:

In DUP_LINE_CHECK 
i_mode = 1
count = 134
QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #100 Unexpected exception ORA-01422: exact fetch returns more than requested number of rows
QP_BULK_VALIDATE.CHECK_DATES_OVERLAP #200 Unexpected exception User-Defined Exception
DUP_LINE_CHECK Unexpected Exception User-Defined Exception
Unexpected error


How to Replicate
-------------------

  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
  4. Submit request with debug enabled.
  5. 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.