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

Last updated on JULY 14, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

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