Error in Pricing Correction SQL Causes Some Policies Not To Be Picked Up (Doc ID 2073079.1)

Last updated on JULY 19, 2017

Applies to:

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

Symptoms

On : 9.6.1.22 version, Activity

Actual Behavior
Pricing correction is running the SQL for PIT and Deposit level tracking rather than the SQL just for PIT so it is not picking up any policies.

Expected Behavior
Expect the query to run for PIT without Deposit level tracking and pick up applicable policies

Steps To Reproduce
The issue can be reproduced at will in a Test environment with the following steps:
1. Company level Activity - search by Company -> Price Correction -> System Plan
2. Run Price Correction transaction.
This should create a spawn of TestTransaction on 1 policy - without the patch it does not spawn anything

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