Java Exception Error When Performing Service Request Advanced Search

(Doc ID 2138761.1)

Last updated on MAY 17, 2016

Applies to:

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


When attempting to perform Work Request Advanced Search, the following error occurs.


Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
  wewr.description AS workdesc,
  wewr.description As expworkdesc,
  cii.serial_number asset_number,
  ... etc.


The issue can be reproduced at will with the following steps:
1.  Responsibility: Maintenance Super User.
2.  Click on Work Requests tab.
3.  Go to Advanced Search and perform search.


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