My Oracle Support Banner

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

Last updated on MARCH 08, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.15.1 and later
Information in this document applies to any platform.
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"

Changes

 

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
Changes
Cause
Solution
References


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