Clicking On Return Link in Work Order Page throws JBO-27122: SQL Error Message

(Doc ID 1989572.1)

Last updated on OCTOBER 24, 2016

Applies to:

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


When attempting to click on Return link in Work Order Page, the following error occurs.


oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
  WHEN (length(wewr.description ) > 30)
  THEN concat(substr(wewr.description, 1, 30),'...')
  ELSE wewr.description
  END AS workdesc,
  wewr.description As expworkdesc,
  cii.serial_number asset_number,
  cii.inventory_item _id,
  mck.concatenated_segments AS category_name,
  el.location_codes AS eam_location,
  ml1.meaning AS statusvalue,
  ml2.meaning AS priorityvalue,
  ml3.meaning AS requesttypevalue,
  fu2.user_name AS created_for_name,
  fnd_profile.value('EAM_WR_OPTIONS') AS Profile,
  fnd_global.user_id AS user_id,
  ml4.meaning AS Asset _Type,
  WHEN (length(cii.instance_description ) > 30)
  THEN concat(substr(cii.instance_description , 1, 30),'...')
  ELSE cii.instance_description
  END AS assetdesc,


The issue can be reproduced at will with the following steps:
1. Responsibility: Maintenance Super User
2. Click on Work Requests
3. Click on Return to Work Requests: ALL


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