"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


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms