My Oracle Support Banner

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.

Symptoms

On EAM - Oracle Enterprise Asset Management, 12.1.3 version, Work Execution

When attempting to release a particular WO, the following error occurs:

ERROR
-----------------------
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 ))) ) '.


STEPS
-----------------------
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.

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.