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 MARCH 14, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version and later
Information in this document applies to any platform.


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
Approve the CO
Cancel the CO
Create another Change Order for the same PO
F6/F4 the line item again
Approve the CO
Merge to PO and get this error


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.