Work Order Search By Asset Number Gives Error (Doc ID 2083490.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3.2 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Work Execution

Symptoms

When attempting to search by Asset number in Work order simple and advanced search page, the following error occurs.

ERROR
You have encountered an unexpected error. Please contact the System Administrator for assistance.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(SELECT wdj.WIP_ENTITY_ID,
wdj.DESCRIPTION,
wdj.STATUS_TYPE,
decode(wdj.FIRM_PLANNED_FLAG,1,'Y','N') as firm_planned_flag,
wdj.SCHEDULED_START_DATE,
wdj.SCHEDULED_COMPLETION_DATE,
wdj.PROJECT_ID,
wdj.TASK_ID,
wdj.PRIORITY,
m18.meaning as SHUTDOWN_TYPE,
wdj.TAGOUT_REQUIRED,
wdj.PLAN_MAINTENANCE,
msi.concatenated_segments,
msi.inventory_item_id,
cii.serial_number as asset_serial_number,
msi.eam_item_type ,
round((wdj.SCHEDULED_COMPLETION_DATE - wdj.SCHEDULED_START_DATE) * 24,
3) AS duration,
bd1.department_code as wo_owning_department,
DECODE(ewod.pending_flag, 'Y', ewsv.work_order_status || ' - ' ||
fnd_message.get_string('EAM','EAM_PENDING_TEXT'),
ewsv.work_order_status) AS status_type_disp,
ml2.meaning as priorityval,
we.wip_entity_name,
ml3.meaning as eam_item_type_disp,
to_char('N') as select_flag,
DECODE(ewod.pending_flag,'Y','Disabled',decode(wdj.status_type, 3,
'Complete', 4,'Uncomplete', 'Disabled')) as action_code,
'UpdateEnabled' as update_switcher,
loc.location_codes,
to_char('WorkOrder') as sub_tab,


STEPS:
1. Go to Maintenance Super User Responsibility
2. Navigate to Work order search page
3. Search by Asset number and include asset children using simple and advanced search and get 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