My Oracle Support Banner

Self Service Maintenance - Querying For Work Request By Type Errors With JBO-27122 (Doc ID 287009.1)

Last updated on AUGUST 19, 2019

Applies to:

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

Symptoms

Using Maintenance Self Service Maintenance responsibility and querying Work Requests by Type errors with the following:
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT wewr.WORK_REQUEST_NUMBER, meanav.serial_number as asset_number, wewr.WORK_REQUEST_PRIORITY_ID, wewr.WORK_REQUEST_STATUS_ID, wewr.WIP_ENTITY_ID, wewr.WORK_REQUEST_OWNING_DEPT, wewr.EXPECTED_RESOLUTION_DATE, ml1.Meaning As StatusValue, meanav.Concatenated_Segments, meanav.category_name, meanav.Owning_Department, meanav.EAM_LOCATION, meanav.Current_organization_Id, meanav.inventory_item_id, wewr.work_request_id, fu.user_name, bd.department_code, wewr.description as workdesc, wewr.created_by, fnd_profile.value('EAM_WR_OPTIONS') as Profile, fnd_global.user_id as user_id FROM WIP_EAM_WORK_REQUESTS wewr, mfg_lookups ml1, mtl_eam_asset_numbers_v meanav, bom_departments bd, fnd_user fu WHERE (ml1.lookup_type = 'WIP_EAM_WORK_REQ_STATUS' And wewr.work_request_status_id = ml1.lookup_code) And wewr.maintenance_object_type = 1 and wewr.maintenance_object_id = meanav.gen_object_id And meanav.current_organization_id = wewr.organization_id and fu.user_id = wewr.created_by and bd.department_id = wewr.work_request_owning_dept) QRSLT WHERE (current_organization_id = :1 AND ASSET_NUMBER like :2 And Inventory_Item_Id like :3 AND work_request_type_id =:4)
Navigation: Self Service Maintenance User > Work Requests > Advanced Search > Enter any Work Request Type > GO > Error is generated.
System is generating the error for seeded Lookup codes for Type as well user defined.

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!


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