My Oracle Support Banner

Error Merging Change Order to PO : ORA-00001 Unique constraint (SYNERGEN.PK_SA_WORK_ORDER_MATERIAL) violated. (Doc ID 1109386.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version: 1.8.1.1 and later   [Release: 1.8 and later ]
Information in this document applies to any platform.

Symptoms

We are getting Oracle error ORA-00001 when trying to merge a Change Order with a PO. Here is the complete error message :

Inserting into Work Order Material FOR po_item 004 ORA-00001. Unique constraint (SYNERGEN.PK_SA_WORK_ORDER_MATERIAL) violated.

The steps to Recreate this issue are :

Find a W type ISSUED Purchase Order
Create a Change Order
F6/F4 to copy the line item
Save
Approve the CO
Cancel the CO
Create another Change Order for the same PO
F6/F4 the line item again
Save
Approve the CO
Merge to PO and get this error

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