My Oracle Support Banner

"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 MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.0.3 and later
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:




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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