"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 MAY 21, 2017

Applies to:

Oracle Transportation Management - Version 6.3.4 to 6.4.1 [Release 6.3 to 6.4]
Information in this document applies to any platform.


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.

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

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"


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