Error in Pricing Correction SQL Causes Some Policies Not To Be Picked Up
Last updated on JULY 19, 2017
Applies to:Oracle Insurance Policy Administration J2EE - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version, Activity
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.
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
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