Scheduled Valuation Is Not Completing Randomly - No Deadlocks (Doc ID 2039265.1)

Last updated on AUGUST 12, 2015

Applies to:

Oracle Insurance Policy Administration J2EE - Version to [Release 9.6]
Information in this document applies to any platform.


On : version, Cycle Issues

When running Scheduled Valuation the job randomly fails. This has only been reported in one, non-production environment.

  java.lang.IllegalStateException: Identifier:Identifier{GUID} already exists.

Violation of PRIMARY KEY constraint 'PK_ASCYCLEDETAIL'. Cannot insert duplicate key in object 'dbo.ASCYCLEDETAIL'. The duplicate key value is ([CycleGUID], [CycleDetailGUID], )

The issue has the following business impact:
Due to this issue, users must monitor cycle to ensure it completes successfully.


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