Hiding Work Clearance Area By Personalization, Provide Error JBO-27122 When Work Order Is Created From Work Request (Doc ID 1934849.1)

Last updated on FEBRUARY 23, 2016

Applies to:

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

Symptoms

On : 12.2.3 version, Work Execution

When attempting to hide Work Clearance from the Create Work Order page, and then create a work order from the Create Work Order button on the result table in Request tab, after searching advanced search, the following error occurs.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (Select ewc.WORK_CLEARANCE_ID,
ewc.WORK_CLEARANCE_NAME,
ewc.PENDING_FLAG,
ewc.DESCRIPTION,
ewc.SCHEDULED_ESTAB_START_DATE,
ewc.SCHEDULED_ESTAB_END_DATE,
ewc.SCHEDULED_REESTAB_START_DATE,
ewc.SCHEDULED_REESTAB_END_DATE,
ewc.USER_DEFINED_STATUS_ID as user_status_id,
decode(ewc.pending_flag,'Y',ewsv.work_clearance_status||'-'||fnd_message.get_string('EAM','EAM_PENDING_TEXT'), ewsv.work_clearance_status) as User_Status,
ewc.STATUS_TYPE,
ewc.APPROVED_BY,
wdj.wip_entity_id,

 

The issue can be reproduced at will with the following steps:
1. search for WR
2. create WO and Save
3. observe error


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