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.

Symptoms


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

ERROR


oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
  wewr.work_request_number,
  wewr.organization_id,
  wewr.work_request_id,
  CASE
  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,
  msi.concatenated_segments,
  wewr.work_request_owning_dept,
  bd.department_code,
  mck.concatenated_segments AS category_name,
  el.location_codes AS eam_location,
  wewr.work_request_status_id,
  ml1.meaning AS statusvalue,
  wewr.work_request_priority_id,
  ml2.meaning AS priorityvalue,
  wewr.work_request_type_id,
  ml3.meaning AS requesttypevalue,
  wewr.expected_resolution_date,
  wewr.created_by,
  fu1.user_name,
  wewr.created_for,
  fu2.user_name AS created_for_name,
  wewr.wip_entity_id,
  msi.eam_item_type,
  fnd_profile.value('EAM_WR_OPTIONS') AS Profile,
  fnd_global.user_id AS user_id,
  wewr.creation_date,
  ml4.meaning AS Asset _Type,
  we.wip_entity_name,
  wewr.maintenance_object_id,
  cii.instance_number,
  CASE
  WHEN (length(cii.instance_description ) > 30)
  THEN concat(substr(cii.instance_description , 1, 30),'...')
  ELSE cii.instance_description
  END AS assetdesc,
  mp.maint_organization_id


STEPS

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

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