My Oracle Support Banner

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

Last updated on SEPTEMBER 22, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.