"java.sql.SQLException: ORA-01427: single-row subquery returns more than one row" Error When Using Ship Unit Line Screenset With Added Refnum Column (Doc ID 1986826.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When adding pseudo refnums in Ship Unit Line screenset result page, while adding the refnums, OTM shows correct Ship Unit Line Refnum Qualifiers.
While searching the OTM query of screenset matches it to Ship Unit Refnums, instead of Ship Unit Line Refnums with an OR condition of refnum qual is NULL, the following error occurs.

ERROR
-----------------------
"Single row sub-query returns more than one rows"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a ship unit line screenset
2. Add 5 pseudo refnum
3. Create an order with one ship unit and four ship unit lines using Ship Unit Lines order configuration and add all the above 5 refnums to each ship unit lines.
4. Attach this screenset in menu
5. Search by Ship Unit ID and you will get below error:

"Single row sub-query returns more than one rows"

Cause

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