My Oracle Support Banner

Random Policies Using Incorrect RateGroupGUID For Rate Lookup Using RATEARRAY (Doc ID 2779976.1)

Last updated on JUNE 08, 2021

Applies to:

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

Symptoms

On : 11.0.2.20 version, General

ACTUAL BEHAVIOR
---------------
Random policies using incorrect RateGroupGUID for rate lookup using RATEARRAY. During a POLICY cycle run of 2500 policies, random policies are getting incorrect values because the RATEARRAY lookup is not returning the correct rate. The run was done with the showSQL parameter set to true and we are unable to see the SQL that pulls the rateGroupGUID. We think it's being taken from cache.

EXPECTED BEHAVIOR
-----------------------
The system should get the correct rate all the time.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. The environment is populated with the policies via a SQL load process.
2. Policy Cycle is run.
3. The values of the policies are checked based on a client audit process.
4. Policies that mismatch are identified.

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
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.