When Attempting To Simple Search For A Work Order From Maintenance Super User Pages , Error Occurs as Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.. (Doc ID 2991975.1)

Last updated on JANUARY 29, 2024

Applies to:

Symptoms

When I do a simple query for a specific work order, the system displays the following:
Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance.
When reviewing the detail, it is detected that the message "ORA-01427: single-row subquery returns more than one row" exists.
Reviewing the query for the object "oracle.apps.eam.workorder.server.WorkOrderDetailsVO" we detect that the error is due to the subquery:
(
SELECT
START_DATE
DESDE
EAM_ASSET_STATUS_HISTORY eash
WHERE eash.wip_entity_id = vo.wip_entity_id
AND eash.OPERATION_SEQ_NUM IS NULL
and nvl(eash.enable_flag,'N') = 'Y'
) AS shutdown_start_date,

STEPS
-----------------------
1. Login into Maintenance super user responsibility
2. Navigation: Home > Work Orders > All > Work Orders > Simple Search > Go
3. View above error message

Cause

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