Exception Error When Entering Department In Work Orders Page (Doc ID 1572470.1)

Last updated on NOVEMBER 09, 2015

Applies to:

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

Symptoms

On : 11.5.10.2 version, WR

When attempting to search by Department using Work Order Simple Search, the following error occurs.

ERROR
-----------------------
Exception Details.
 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT wr.request_number as RequestNumber,
  ( select decode( wr.request_type_code ,
  1, decode(wr.wip_entity_id , null, 'N' , 'Y') ,
  2, decode(count(ewos.wip_entity_id) , 0 , 'N' , 'Y' )

etc.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Maintenance User
2. Click on Work Orders Tab > Requests
3. Using Work Order Simple Search
4. Search using an field, such as Department
5. Click Go and error occurs

Cause

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