After Upgrade When Navigating to the Work Order Field on EAM Self Service Timecard, Getting JSP error: JBO-27122 (Doc ID 1504493.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

After upgrade to 12.1.3, when trying to populate Work Order field of EAM Timecard, recieved the following error:

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

Statement:

SELECT * FROM (SELECT DISTINCT
   we.wip_entity_name AS WipEntityName,
   msik.concatenated_segments AS AssetGroup,
   to_char(wdj.wip_entity_id) AS WipEntityId,
   to_char(wdj.organization_id) AS OrganizationId,
   wdj.scheduled_start_date,
   wdj.scheduled_completion_date,
   cii.serial_number AS SerialNumber,
   DECODE(ewod.pending_flag, 'Y', ewsv.work_order_status || ' - ' || fnd_message.get_string('EAM','EAM_PENDING_TEXT'),ewsv.work_order_status) AS status,
   msik.inventory_item_id AS InventoryItemId,
   bd.department_code AS DepartmentCode,
   cii.serial_number AS SerialNumberDisp
FROM wip_discrete_jobs wdj,
   eam_work_order_details ewod,
   eam_wo_statuses_v ewsv,
   wip_entities we,
   bom_departments bd,
   wip_operations wo,
   csi_item_instances cii,
   mtl_system_items_b_kfv msik,
   mtl_Parameters mp
WHERE we.wip_entity_id = wdj.wip_entity_id
   AND we.organization_id = wdj.organization_id
   AND we.entity_type = 6
   AND ewod.wip_entity_id = wdj.wip_entity_id
   AND ewod.organization_id = wdj.organization_id
   AND ewsv.status_id = ewod.user_defined_status_id
   AND wdj.status_type in (3,4,6)
   AND wdj.organization_id = mp.maint_organization_id
   AND msik.inventory_item_id = nvl(wdj.asset_group_id, wdj.rebuild_item_id)
   AND msik.organization_id = mp.organization_id
   AND bd.department_id(+) = wdj.owning_department
   AND DECODE(wdj.maintenance_object_type,3,wdj.maintenance_object_id,-999) = cii.instance_id (+)
   AND wo.wip_entity_id = wdj.wip_entity_id
   AND wo.organization_id = wdj.organization_id
   AND wo.repetitive_schedule_id is null
   AND exists
   (
       SELECT 1
       FROM bom_dept_res_instances bdri,
           bom_resource_employees bre,
   bom_department_resources bdr
       WHERE  
   bre.person_id = :1
   AND bre.organization_id = wo.organization_id
   AND bre.effective_start_date <= sysdate
   AND bre.effective_end_date >= sysdate
   AND bdri.instance_id = bre.instance_id
   AND bdri.resource_id = bre.resource_id
   AND bdri.serial_number is null
   AND bdr.resource_id = bdri.resource_id
   AND wo.department_id = bdr.department_id
   AND (    ( bdri.department_id = wo.department_id )
 OR ( bdri.department_id = bdr.SHARE_FROM_DEPT_ID )
)
   )) QRSLT  WHERE (( UPPER(WipEntityName)  like UPPER(:1) AND (WipEntityName  like  :2 OR WipEntityName  like  :3 OR WipEntityName  like  :4 OR WipEntityName  like  :5)))

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.