Last updated on OCTOBER 16, 2016
Applies to:Oracle Utilities Work and Asset Management - Version: 22.214.171.124
This problem can occur on any platform.
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
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms