ORA-00001: unique constraint (WIP.WIP_REQUIREMENT_OPERATIONS_U1) violated in Package EAM_WO_CHANGE_STATUS_PVT Procedure change_status (Doc ID 1386842.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Nov-2013***

Goal

While releasing the hold for a particular work order number, system returns the following error:

Cannot update work order.
1. The entity with header id (<wip_entity_id>) generated the following error(s):
2. ORA-00001: unique constraint (WIP.WIP_REQUIREMENT_OPERATIONS_U1) violated in Package EAM_WO_CHANGE_STATUS_PVT Procedure change_status.
3. The status change for the work order with WIP entity id (<wip_entity_id>) has failed.


Solution

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