ORA-01422 Exact Fetch Returns More Than Request Number Of Rows In Package QP_LIST_HEADERS_PVT

(Doc ID 2300090.1)

Last updated on AUGUST 23, 2017

Applies to:

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


Opening price list form, receive error:


ORA-01422 exact fetch returns more than request number of rows in package QP_LIST_HEADERS_PVT

The issue can be reproduced at will with the following steps:
OM Super User
Pricing > Pricing List Setup

Receive error:
ORA-01422: exact fetch returns more than requested number of rows
in Package QP_LIST_HEADERS_PVT Procedure Price_List


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms