My Oracle Support Banner

QUERYING WORK ORDER RAISING JAVA.SQL.SQLEXCEPTION:ORA-01427: SINGLE-ROW SUBQUERY (Doc ID 3050462.1)

Last updated on OCTOBER 03, 2024

Applies to:

Oracle Enterprise Asset Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Steps to reproduce the issue:

Go to Enterprise Asset management home page form--> Click on Work Order form-->Query work order.

Below error occurs while searching work order.

java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

Changes

Error came from query in java/toolbelt/server/WoOperationsVO.xml.
The cause of multiple enabled EAM_ASSET_STATUS_HISTORY record exist for a WO-OP may be a bug in EAMVOCUB.pls fixed in bug 33627505.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.