My Oracle Support Banner

ORA-01427: Single-row Subquery Returns More than One Row Shows When Searching for Orders (Doc ID 834547.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Transportation Management - Version: 5.5 to 5.5
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.05.02, When attempting to search for an Order, the following error occurs:

ERROR
java.sql.SQLException: ORA-01427: single-row sub-query returns more than one row

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log on to OTM and go to the Order Finder screen
2. search for an order and see that the error single-row sub-query returns more than one row appears

Cause

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
  Symptoms
  Cause
  Solution

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.