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 1.8.1.1 and laterInformation 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 |
References |