EAMWOMDF: Work Orders: Error Message Received When Updating A Cancelled Work Order To A Released Status: 'Error: The Asset has been deactivated...' Or 'APP-FND-01048: Use of this combination restricted by WHERE clause ' (EAM_ITEM_TYPE = 2 AND ...' (Doc ID 1546183.1)

Last updated on APRIL 23, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to change the status of a Work Order from cancelled to released,
the following error occurs.


Error: The Asset has been deactivated. Hence cannot change the status of the workorder NNNNNN,

or in another case, different work order....

Receive Message:   APP-FND-01048: Use of this combination restricted by WHERE clause ' (EAM_ITEM_TYPE = 2 AND (EAM_WORKORDERS......) 

Followed by Error: Error: The Asset has been deactivated.  Hence cannot change the status of the workorder NNNNN.

The issue can be reproduced at will with the following steps:
1.  EAM: Work Orders: Work Orders
2.  Query the cancelled Work Order
3. Change Work Order Status to Released. Error message which turns out to be invalid

Cause

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