"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 FEBRUARY 27, 2019
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