Not Able To Create Work Order For Asset Route From Asset Route Detail Page (Doc ID 2290919.1)

Last updated on JULY 27, 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.

Exception Details.
 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

The issue has the following business impact:
Due to this issue, users cannot create a work order from Asset route page.


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