"single-row subquery returns more than one row" Exception When Using SSHIP_UNIT_LINE Screenset that Includes a RefNum(P) Column

(Doc ID 1067901.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.0.3
Information in this document applies to any platform.


A custom Screen Set is created based on the S_SHIP_UNIT_LINE screen. It is modified to include an S_Ship_Unit_Line RefNum (i.e. RefNum(P) ). RefNums are assigned to the S_SHIP_UNIT_LINE in the following scenarios:

Scenario 1: Single Ship Unit with Multiple Lines where only ONE Line has the assigned RefNum
Observation: When using the above screenset, the results display the RefNum of the one Line as the value for ALL Lines (i.e. the line that does not include the RefNum displays the value of the other Line's RefNum)

Scenario 2: Single Ship Unit with Multiple Lines where each Line has an assigned RefNum
Observation: The search results fail with the following exception:

java.sql.SQLException: ORA-01427: single-row subquery returns more than one row


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