Unable to Aquire Lock on AsEntityLock Table (Doc ID 2294182.1)

Last updated on AUGUST 04, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.1.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 10.1.2.11 version, Activity

Actual Behavior
Users have a case where there is a pending "Termination" activity on a policy and another pending "MoneyIn" activity on a Group Customer.
When processing the MoneyIn activity on the GroupCustomer, another activity is spawned using activity sequencing with processImmediate = "Yes" (ApplyEmployerBilledplanPremium)
However, since there is already a pending Termination activity on the policy, it tries to process the pending Termination activity first which is correct.

The issue occurs when it finishes processing the Termination and doesn't attempt to process the ApplyEmployerBilledPlanPremium.
Users looked through the AsActivitySequenceTask table and found the ErrorXML that tells us that both sequences have trouble acquiring the lock.

The assumption is that they are competing somehow and not letting the other one go through.
Finally, the processing finishes but The MoneyIn on the Account is in ActivitySequenceError status (72),
so is the Termination on the Policy but the ApplyEmployerBilledPlanPremium is still in status code 02 (AsActivity table).

 


Expected Behavior
Activities using activity sequence should completely process regardless of competing pending activities

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