My Oracle Support Banner

"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!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.