"ORA-01427: single-row subquery returns more than one row" Exception Including Status Type on Custom Screen Set
(Doc ID 1569645.1)
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!