"ORA-01427: single-row subquery returns more than one row" Exception Including Status Type on Custom Screen Set
Last updated on MARCH 08, 2017
Applies to:Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.
Two custom Status Types are created. Each of these Status Types share the same Status Value. For example:
STATUS_TYPE_A has a value of VALUE1
STATUS_TYPE_B has a value of VALUE1
On object is created that has both of these Status Types included and both set to the same Status Value (e.g. VALUE1).
A Screen Set is then created where in includes one of the above Status Types in the Results of the Screen Set. When this Screen Set is accessed for this object, the following error is encountered:
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
Million Knowledge Articles and hundreds of Community platforms