Qp_list_lines_v Gives Error ORA-01427: Single-row Subquery Return More Than One Row (Doc ID 1500738.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Symptoms

When selecting records from view qp_list_lines_v the following error is shown for one particular condition:

ERROR
ORA-01427: single-row subquery return more than one row

QUERY BEING RUN
SELECT * -- NVL(ROUND(OPERAND,10),0) US_LIST_PRICE
FROM qp_list_lines_v
WHERE LIST_HEADER_ID ='9142' -- p_us_price_list
AND NVL(END_DATE_ACTIVE,SYSDATE+1) > SYSDATE
AND product_attribute_context='ITEM'
AND list_line_type_code='PLL'
AND PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'
AND PRODUCT_ATTR_VALUE='113154'

Cause

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