My Oracle Support Banner

Group Account Product's Object Version Number Changes with Every Submission of a Policy (Doc ID 2566353.1)

Last updated on JULY 22, 2019

Applies to:

Oracle Health Insurance Enterprise Policy Administration - Version 3.18.3.0.0 and later
Information in this document applies to any platform.

Symptoms

The OBJECT_VERSION_NUMBER of table POL_GROUP_ACCOUNT_PRODUCTS_B gets updated with every PUT and SUBMIT of a policy. This is preventis, at point of migration, to split a very large group of policies (10700) into smaller files in order for them to be submitted concurrently.
The error received is:
"GEN-RULE-020" title="GEN-RULE-020: The entity "GroupAccountProductDomain Primary Key> 160,773" cannot be updated because it has changed or been deleted since it was last read"

The alternative is to allow each policy in that group to run 1 by 1. This has a significant impact on the time frame to complete - 15.5 hours.

The issue can be reproduced at will with the following steps:
1. Create 2 files with policies belonging to the same group account and same enrollment product.
2. Push them through the API /api/policies/submit or /api/policies at the same time
3. The policy will fail with the below error.
"GEN-RULE-020" title="GEN-RULE-020: The entity "GroupAccountProductDomain Primary Key> 160,773" cannot be updated because it has changed or been deleted since it was last read"

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.