"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 20, 2024

Applies to:

Symptoms

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:

Changes

Cause

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