My Oracle Support Banner

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 JUNE 03, 2021

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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