Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 3.21.3.0.9

This document contains the release notes for Oracle Health Insurance Enterprise Policy Administration Patch 3.21.3.0.9.

Enhancements

ID	Summary	Description
POL-10220	Create policy page improvements	On the create policy page the following features are added to improve operational agility. Auto-populate start dates hide new rows for policyholder, group account, contract, and insurable classes copy products
POL-10333	Ability to acces current CalculationResult object within the Adjustment function dynamic logic	Sometimes it is desired to apply adjustment based on base premium or previously calculated result lines. This requires access to the lines already calculated for the calculation period. This enhancement makes it possible to access the current (in memory) calculation result in the adjustment function dynamic logic.
POL-9711	Policies in Bulk Update Activity no longer submitted directly from the bulk update activity at policy level	Policies are no longer submitted directly from the bulk update activity at policy level: this will decrease the pressure in the Coherence grid and will improve performance. If a submit is required, the policy is flagged by the bulk update activity at policy level (technical table). After the global bulk update has completed, the activity Submit policies is started. Bulk update activity at Global level picks up this list of flagged policies and spawns policy level Submit activities for each flagged policy.

Summary

Description

Included in Patch

POL-10220

Create policy page improvements

On the create policy page the following features are added to improve operational agility.

Auto-populate start dates hide new rows for policyholder, group account, contract, and insurable classes copy products

POL-10333

Ability to acces current CalculationResult object within the Adjustment function dynamic logic

Sometimes it is desired to apply adjustment based on base premium or previously calculated result lines. This requires access to the lines already calculated for the calculation period. This enhancement makes it possible to access the current (in memory) calculation result in the adjustment function dynamic logic.

POL-9711

Policies in Bulk Update Activity no longer submitted directly from the bulk update activity at policy level

Policies are no longer submitted directly from the bulk update activity at policy level: this will decrease the pressure in the Coherence grid and will improve performance.

If a submit is required, the policy is flagged by the bulk update activity at policy level (technical table).
After the global bulk update has completed, the activity Submit policies is started. Bulk update activity at Global level picks up this list of flagged policies and spawns policy level Submit activities for each flagged policy.

Upgrade Steps for Installation

To perform the upgrade, perform the following steps:

Perform any pre-upgrade steps.
Stop all the managed nodes running the .existing version of the application.
Perform any pre-undeploy steps.
Undeploy the existing version of the application.
Back up the database.
Perform any post-undeploy steps.
Unpack the release bundle into a directory that we refer to as OHI_ROOT from now on.
Change Installation Configuration: In <OHI_ROOT>/util/install, make a copy of ohi_install.cfg.template and name it ohi_install.cfg.
Edit ohi_install.cfg to contain your specific database connection data and other configuration settings. The settings are explained in the file itself.
Make sure NO connections are present to the database using the OHI_xxx_USER account (where xxx is the abbreviation of the application)
Run the Upgrade script:
1. Open a command window and browse to <OHI_ROOT>/util/install.
2. Run the upgrade by executing ./ohi-update.sh .
Make the required changes to the ohi properties file
Perform any post-upgrade steps
Start WebLogic application server
Deploy the Application
Perform any post-deploy steps

Additional Upgrade Steps for Installation

The following phases are defined:

pre-upgrade: Application is still running
pre-undeploy: Application is stopped, but not undeployed.
post-undeploy: Application is undeployed. Database is backed up
post-upgrade: Released upgrade script has run.
post-deploy: New application is deployed and is up and running.

a) Stage: post-undeploy

Action: Apply mandatory WebLogic patches

The following are the mandatory (minimal required) patches. Please apply them in the order listed below:

33416868: WLS PATCH SET UPDATE 12.2.1.4.210930 (OCT 2021 PSU)
32211968: ECLIPSELINK - ALL VERSIONS - GOES INTO DEAD LOCK DOING OBJECT BUILDING

After applying the above patch(es), if the managed server fails to start due to coherence errors, please follow the solution described in Doc ID 2634266.1

b) Stage: post-undeploy
Action: Check if ohi_reference_sheet_lines table is empty

Run the following SQL as application owner:

select count(*)
from   ohi_reference_sheet_lines;

If the result is 0, then perform the following:
- Rename the index OHI_REF_SHEET_LINE_UK1:

       alter index OHI_REF_SHEET_LINE_UK1 rename to OHI_REF_SHEET_LINE_UK1_NEW;

After the upgrade script (ohi-update.sh) completes successfully, then rename the index back:

       alter index OHI_REF_SHEET_LINE_UK1_NEW rename to OHI_REF_SHEET_LINE_UK1;

If the result is > 0, no action is required.

Configuration Properties

This section intentionally left blank.

Web Services

This section intentionally left blank.

Data Conversion

This section intentionally left blank.

Dynamic Logic

This section intentionally left blank.

UI Changes

Ref	Action	Subject	Description
POL-10220	Modified	JET policies page	Create policy page improvements
POL-10309	Modified	Schedule lines pages	Descriptor is also added in the search and the title properties for sched. lines
POL-10343	Modified	Group Account Product Page	Insurable class fields are getting displayed in view mode after saving the product details.

Ref

Action

Subject

Description

POL-10220

Modified

JET policies page

Create policy page improvements

POL-10309

Modified

Schedule lines pages

Descriptor is also added in the search and the title properties for sched. lines

POL-10343

Modified

Group Account Product Page

Insurable class fields are getting displayed in view mode after saving the product details.

Deprecated items (to be removed in future release)

This section intentionally left blank.

Breaking Changes

This section intentionally left blank.

Bug Fixes

BugDB	SR	Internal	BP	Summary
33904891	3-28538236711	POL-10114	BP	Value is not visible for a flexcode configured under tab-table component
Description:	When a flex code is configured for a tab-table component. It doesn’t show the selected value even when it’s saved.
Resolution:	Flex code values are shown properly in tabs of List template pages.
33918320	3-28571274031	POL-10185	BP	Searching reference sheet lines based on reference sheet resource name does full table scan on ohi_reference_sheet_lines table
Description:	Searching reference sheet lines based on reference sheet resource name does full table scan on ohi_reference_sheet_lines table when the clustering factor of index ohi_ref_sheet_line_uk1 is close to the number of rows in the table ohi_reference_sheet_lines
Resolution:	Searching reference sheet lines based on reference sheet resource name has been optimized
33920499		POL-10190	BP	Premium is not being displayed for the policies in which contract period is not present
Description:	Premium is not being displayed for the policies in which the contract period is not present.
Resolution:	Premium can be seen for all policies with contract periods also when a premium calculation is available.
33940676	3-28853456301	POL-10239	BP	Optimize process and apply registrations operation when more registrations are applied
Description:	When there are several registrations to apply, for example, 40 registrations, the processandapplyregistrations operation queries the premiums and adjustments for each registrations instead of fetching them only once for the entire duration of the operation.
Resolution:	Caching the registration plans, the processandapplyregistrations operation queries the premiums and adjustments for each registration only once now for the entire duration of the operation. This optimizes the process and improves the performance.
33947297		POL-10258	BP	Apply Registrations process creates duplicate Calculation Results when custom segmentation logic is used
Description:	Apply Registrations process creates duplicate Calculation Results if the Policy Enrollment Product spans more than an year and if a custom Policy Calculation Period segmentation logic is used to set the calculation date of the policy calculation periods to a similar date for all.
Resolution:	Apply Registrations functionality will not create duplicate Calculation Results when custom segmentation logic sets the calculation date of the periods
33957432		POL-10277	BP	In the policy enrollment product section, the value of commission type is not rendered after saving
Description:	In policies with policy enrollment products, commission type is not visible.
Resolution:	User can now see commission type after saving of policy enrollment product.
33964946		POL-10294	BP	Create Person Covered Services based on Product Covered Service time validity
Description:	During Person Covered Service creation, the configured Product Covered Services are considered. It only selects the Product Covered Services that are valid on the system date. So, no Person Covered Service will be generated for Product Covered Services that have already ended.
Resolution:	A new Person Covered Service will be created per Product Covered Service, bounded by the time the person was enrolled on this product, regardless of the system date.
33965688		POL-10295	BP	Importing flex code with date field using configuration migration tool fails with GEN-FIEL-008 error
Description:	Importing flex code with date field using configuration migration tool fails with GEN-FIEL-008 error
Resolution:	Importing flex code with date field using configuration migration tool no longer fails with GEN-FIEL-008 error
33979741		POL-10305	BP	Improvements in calculate premium activity
Description:	Implement the following performance optimizations in calculate premium activity: 1) When dynamic fields and dynamic records are accessed on Policy object from multiple dynamic logic in the calculate premium flow, the dynamic fields and dynamic records are construct every time they are accessed using Policy object 2) Optimize dynamic logic execution by not adding extensions support if the dynamic logic does not have any extensions
Resolution:	Performance of accessing dynamic fields and records on Policy object has been improved; Performance of dynamic logic execution (that does not have any extensions) has been improved
33986026		POL-10315	BP	Pend reason code is not shown in the View Pend reasons dialog
Description:	Pend reason code is not shown in the view pend reasons dialog in policies page.
Resolution:	Pend reason code is shown in the view pend reasons dialog in policies page.
33992076	3-28943885661	POL-10320	BP	Flex codes on premium schedule lines do not display the descriptor of flex code values
Description:	Flex codes on premium schedule lines do not display the descriptor of flex code values.
Resolution:	Flex codes on premium schedule lines now display descriptor values also in JET
34008262		POL-10343		Group Account Product Page: Insurable class fields display issue in view mode
Description:	Group Account Product Page: Insurable class fields are not getting displayed after filling the value and saving the record.
Resolution:	Insurable class fields are getting displayed in view mode after saving the product details in Group Account Products page
34013320	3-28969712761	POL-10348	BP	Pended Policies cannot be edited
Description:	Pended Policies cannot be edited
Resolution:	Edit Policy button is visible now for pended Policies and they can be edited in JET Policies screen

BugDB

Internal

Summary

33904891

3-28538236711

POL-10114

Value is not visible for a flexcode configured under tab-table component

Description:

When a flex code is configured for a tab-table component. It doesn’t show the selected value even when it’s saved.

Resolution:

Flex code values are shown properly in tabs of List template pages.

33918320

3-28571274031

POL-10185

Searching reference sheet lines based on reference sheet resource name does full table scan on ohi_reference_sheet_lines table

Description:

Searching reference sheet lines based on reference sheet resource name does full table scan on ohi_reference_sheet_lines table when the clustering factor of index ohi_ref_sheet_line_uk1 is close to the number of rows in the table ohi_reference_sheet_lines

Resolution:

Searching reference sheet lines based on reference sheet resource name has been optimized

33920499

POL-10190

Premium is not being displayed for the policies in which contract period is not present

Description:

Premium is not being displayed for the policies in which the contract period is not present.

Resolution:

Premium can be seen for all policies with contract periods also when a premium calculation is available.

33940676

3-28853456301

POL-10239

Optimize process and apply registrations operation when more registrations are applied

Description:

When there are several registrations to apply, for example, 40 registrations, the processandapplyregistrations operation queries the premiums and adjustments for each registrations instead of fetching them only once for the entire duration of the operation.

Resolution:

Caching the registration plans, the processandapplyregistrations operation queries the premiums and adjustments for each registration only once now for the entire duration of the operation. This optimizes the process and improves the performance.

33947297

POL-10258

Apply Registrations process creates duplicate Calculation Results when custom segmentation logic is used

Description:

Apply Registrations process creates duplicate Calculation Results if the Policy Enrollment Product spans more than an year and if a custom Policy Calculation Period segmentation logic is used to set the calculation date of the policy calculation periods to a similar date for all.

Resolution:

Apply Registrations functionality will not create duplicate Calculation Results when custom segmentation logic sets the calculation date of the periods

33957432

POL-10277

In the policy enrollment product section, the value of commission type is not rendered after saving

Description:

In policies with policy enrollment products, commission type is not visible.

Resolution:

User can now see commission type after saving of policy enrollment product.

33964946

POL-10294

Create Person Covered Services based on Product Covered Service time validity

Description:

During Person Covered Service creation, the configured Product Covered Services are considered. It only selects the Product Covered Services that are valid on the system date. So, no Person Covered Service will be generated for Product Covered Services that have already ended.

Resolution:

A new Person Covered Service will be created per Product Covered Service, bounded by the time the person was enrolled on this product, regardless of the system date.

33965688

POL-10295

Importing flex code with date field using configuration migration tool fails with GEN-FIEL-008 error

Description:

Importing flex code with date field using configuration migration tool fails with GEN-FIEL-008 error

Resolution:

Importing flex code with date field using configuration migration tool no longer fails with GEN-FIEL-008 error

33979741

POL-10305

Improvements in calculate premium activity

Description:

Implement the following performance optimizations in calculate premium activity:
1) When dynamic fields and dynamic records are accessed on Policy object from multiple dynamic logic in the calculate premium flow, the dynamic fields and dynamic records are construct every time they are accessed using Policy object
2) Optimize dynamic logic execution by not adding extensions support if the dynamic logic does not have any extensions

Resolution:

Performance of accessing dynamic fields and records on Policy object has been improved; Performance of dynamic logic execution (that does not have any extensions) has been improved

33986026

POL-10315

Pend reason code is not shown in the View Pend reasons dialog

Description:

Pend reason code is not shown in the view pend reasons dialog in policies page.

Resolution:

Pend reason code is shown in the view pend reasons dialog in policies page.

33992076

3-28943885661

POL-10320

Flex codes on premium schedule lines do not display the descriptor of flex code values

Description:

Flex codes on premium schedule lines do not display the descriptor of flex code values.

Resolution:

Flex codes on premium schedule lines now display descriptor values also in JET

34008262

POL-10343

Group Account Product Page: Insurable class fields display issue in view mode

Description:

Group Account Product Page: Insurable class fields are not getting displayed after filling the value and saving the record.

Resolution:

Insurable class fields are getting displayed in view mode after saving the product details in Group Account Products page

34013320

3-28969712761

POL-10348

Pended Policies cannot be edited

Description:

Pended Policies cannot be edited

Resolution:

Edit Policy button is visible now for pended Policies and they can be edited in JET Policies screen

Issues that were backported in previous Release / Patch

No backports.