ORA-00001: unique constraint (SYNERGEN.PK_SA_ASSET_WORK_HISTORY) violated (Doc ID 833894.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version: 1.7.15.1
This problem can occur on any platform.

Symptoms

When the Work Order Task Asset List View reference the same Asset that is on the Work Order Task, the following error is displayed in the Purge Work Order Batch job when attempting to move the Work Order to History:

FULL HISTORY *** INSERT SA_ASSET_WORK_HISTORY ORA-00001: unique constraint (SYNERGEN.PK_SA_ASSET_WORK_HISTORY) violated

Since we allow you to reference the same Asset that is on the Work Order Task on the Asset List, the application should not prevent the work order from moving to history when this situation arises.

STEPS TO REPRODUCE:

Pull up an Active Work Order
Access the Work Order Task Asset List
Add a few Asset ids to this View - make sure one of the Asset id's matches the Asset Id on the Work Order Task
Incur charges against the work order-for example create a timesheet. Run Batch to post the charges to the Work Order.
Finish the Work Order Task
Run Batch to set the WO Header to Finished.
Set the WO Aging Business Rule RETAIN_DAYS option to 0
Close the Work Order
Run Batch
Check the Job Manager Log for the SDBP_PURGE_WORK_ORDER job
Error displayed is : FULL HISTORY *** INSERT SA_ASSET_WORK_HISTORY ORA-00001: unique constraint (SYNERGEN.PK_SA_ASSET_WORK_HISTORY) violated"

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