Error When Trying to Release eAM Work Order: APP-FND-01048: Use Of This Combination Restricted By WHERE Clause
(Doc ID 2729756.1)
Last updated on NOVEMBER 24, 2020
Applies to:Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
On EAM - Oracle Enterprise Asset Management, 12.1.3 version, Work Execution
When attempting to release a particular WO, the following error occurs:
APP-FND-01048: Use of this combination restricted by WHERE clause ' ( EAM_ITEM_TYPE = 2 AND ('<ASSET_ACTIVITY_inventory_item_id>' IS NULL OR (INVENTORY_ITEM_ID IN(SELECT MEAA.ASSET_ACTIVITY_ID FROM MTL_EAM_ASSET_ACTIVITIES MEAA, CSI_ITEM_INSTANCES CII WHERE CII.INSTANCE_ID = '<asset_number_id>' AND MEAA.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID AND MEAA.MAINTENANCE_OBJECT_TYPE = 3 AND UPPER(nvl(MEAA.tmpl_flag, 'N') ) <> 'Y' AND NVL(MEAA.START_DATE_ACTIVE, SYSDATE-2) < SYSDATE AND NVL(MEAA.END_DATE_ACTIVE, SYSDATE+2) > SYSDATE ))) ) '.
The issue can be reproduced at will with the following steps:
1. (R) Enterprise Asset Management
2. (N) Work Orders > Work Orders (form)
3. Query WO#
4. Release. >> Error occurs.
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