Last updated on AUGUST 26, 2017
Applies to:Oracle Enterprise Asset Management - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, ACTIVITY
When attempting to create a WorkOrder from the Asset Route Details page,
the following error occurs.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select
cii.instance_number as lam_asset_number,
cii.instance_id as lam_asset_instance_id,
CreateUpdateWOLamEntitiesEO.entity_id as le_entity_id,
CreateUpdateWOLamEntitiesEO.wip_entity_id as le_wip_entity_id,
--todo to_char('WORKORDER') AS le_entity_type,
CreateUpdateWOLamEntitiesEO.type as le_entity_type,
--CreateUpdateWOLamEntitiesEO.INSTANCE_ID as le_instance_id,
CreateUpdateWOLamEntitiesEO.reference_method_id as le_ref_method_id,
cii.instance_description as lam_asset_description,
CreateUpdateWOLRDEO.LR_DETAILS_ID as lr_details_id,
CreateUpdateWOLRDEO.assoc_entity_id as assoc_entity_id,
(select instance_number from csi_item_instances where instance_id = CreateUpdateWOLRDEO.ASSOC_ASSET_ID) as member_asset_num,
(select instance_description from csi_item_instances where instance_id = CreateUpdateWOLRDEO.ASSOC_ASSET_ID) as member_asset_desc,
(select nvl(segmented, 'N') from csi_item_instances where instance_id = CreateUpdateWOLRDEO.ASSOC_ASSET_ID) as mem_asset_seg_flag,
(select nvl(NO_MEASURES_LA, 'Y') from csi_item_instances where instance_id = CreateUpdateWOLRDEO.ASSOC_ASSET_ID) as mem_asset_non_mand_measures,
The issue can be reproduced at will with the following steps:
1)Create an asset route :12345 Asset Route
2)Work order is created for asset route when it is created through Work Order page
3)Now moving to asset route details page
Select the asset route and option to create work order.
4)Received below error page on saving the work order. Error log file is attached.
You have encountered an unexpected error. Please contact your System Administrator for assistance
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms