Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.25.1.0.5

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

Version compatibility: Oracle Health Insurance Enterprise Policy Administration Release 4.25.1.x is only compatible with other Oracle Health Insurance applications release version 4.25.1.x unless explicitly stated otherwise.

In accordance with the OHI error correction policy (Document 1494031.1 on My Oracle Support), error correction support will be provided for this release and the previous two releases.

Enhancements

ID	Summary	Patch
NXT-31011	Access Restriction on Download Feature This enhancement links the ability to download data from the JET user interface to a user role. Only users with access to the Download Data restriction grant can download data from JET UI using the download action. Documentation Links: Security Guide - User Access - Data Access Restriction Types - Download Data Restriction
POL-17810	Premium Calculation: Changes for Amount column This enhancement enhances Amount columns in Run example and Premium Calculation dialogs to show the value of result lines, at line level and total at various aggregation levels.

Summary

Patch

NXT-31011

Access Restriction on Download Feature

This enhancement links the ability to download data from the JET user interface to a user role. Only users with access to the Download Data restriction grant can download data from JET UI using the download action.

Documentation Links:
Security Guide - User Access - Data Access Restriction Types - Download Data Restriction

POL-17810

Premium Calculation: Changes for Amount column

This enhancement enhances Amount columns in Run example and Premium Calculation dialogs to show the value of result lines, at line level and total at various aggregation levels.

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

Configuration Properties

Ref	Action	Description
POL-17049	Added	ohi.activityprocessing.separate.execution.group.initial.wait.time This property configures the initial wait time (in seconds) for an activity execution before it is re-tried.
POL-17049	Added	ohi.activityprocessing.separate.execution.group.max.retry.count This property configures the max number of times an activity in the activity group can be re-executed for failures during execution.

Ref

Action

Description

POL-17049

Added

ohi.activityprocessing.separate.execution.group.initial.wait.time

This property configures the initial wait time (in seconds) for an activity execution before it is re-tried.

POL-17049

Added

ohi.activityprocessing.separate.execution.group.max.retry.count

This property configures the max number of times an activity in the activity group can be re-executed for failures during execution.

Web Services

This section intentionally left blank.

Data Conversion

Ref	Action	Description
NXT-31011	Added	OHI_ACCESS_RESTRICTION_GRANTS The new access restriction will be provided to all non system active roles (with retrieve flag as Y), having at least a system function access grant with retrieve flag as Y

Ref

Action

Description

NXT-31011

Added

OHI_ACCESS_RESTRICTION_GRANTS

The new access restriction will be provided to all non system active roles (with retrieve flag as Y), having at least a system function access grant with retrieve flag as Y

Dynamic Logic

This section intentionally left blank.

UI Changes

Ref	Action	Description
POL-17810	Modified	Policies page Amount columns show the value of result lines, at line level and total at various aggregation levels like premium and surcharges

Ref

Action

Description

POL-17810

Modified

Policies page

Amount columns show the value of result lines, at line level and total at various aggregation levels like premium and surcharges

Breaking Changes

Ref	Action	Description
NXT-31011	Added	OHI_ACCESS_RESTRICTION_GRANTS JET (UI) will implement a new access restriction called "Download 'Data'" to manage the visibility of the Download button. Users who are not granted this access restriction will no longer see the download action, making this a breaking change.

Ref

Action

Description

NXT-31011

Added

OHI_ACCESS_RESTRICTION_GRANTS

JET (UI) will implement a new access restriction called "Download 'Data'" to manage the visibility of the Download button. Users who are not granted this access restriction will no longer see the download action, making this a breaking change.

Access Restrictions

Ref	Action	Description
NXT-31011	Added	OHI_ACCESS_RESTRICTIONS_B A new access restriction of type DWDATA and code as UI_DATA_DOWNLOAD has been added. The same has been assigned to ALL_FUNCTIONS_ACCESS_ROLE
POL-17736	Modified	CO0019 keyboardshortcuts API and floorplans.enhance IP added to CO0019 function code and also removed duplicate access restrictions from setup access role which were part of CO0019

Ref

Action

Description

NXT-31011

Added

OHI_ACCESS_RESTRICTIONS_B

A new access restriction of type DWDATA and code as UI_DATA_DOWNLOAD has been added. The same has been assigned to ALL_FUNCTIONS_ACCESS_ROLE

POL-17736

Modified

CO0019

keyboardshortcuts API and floorplans.enhance IP added to CO0019 function code and also removed duplicate access restrictions from setup access role which were part of CO0019

Bug Fixes

BugDB	SR	Internal	Summary
38408803	3-38943334671	POL-17745	An empty change list is created for connector configurations when a connector is created using JET UI.
Description:	When creating a connector configuration through JET UI, an empty change list is added by default. This empty list blocks any change event from getting transmitted to external systems.
Resolution:	Empty change list is removed when saving a connector in UI
37854835		POL-17049	The applyRegistration activity is blocked due to table lock held by nextcalculationcyle IP process
Description:	ApplyRegistration activity is sometime getting blocked due to table lock held by concurrently running nextcalculationcyle IP process Two new protected properties were introduced to implement retry logic. 1. ohi.activityprocessing.separate.execution.group.initial.wait.time 2. ohi.activityprocessing.separate.execution.group.max.retry.count
Resolution:	A retry mechanism has been incorporated into the applyRegistration activity execution, giving concurrent nextcalculationcyle IP processes time to finish and release their locks, so subsequent attempts complete successfully without encountering a resource-busy exception.
38455974		POL-17791	Date fields should be shown at the last in Reference Sheet Lines table
Description:	Sequence is applied for dynamic columns but Start Date and end date is not displayed at the last in Reference Sheet Lines table
Resolution:	Columns are sorted based on sequence and Start/End date are shown at the last
38439930		POL-17774	In Activity pages, for Column 'created By', values are not displayed on scroll
Description:	Policy Activities page: user log (created By) values are not displayed when user tries to load records with scroll bar.
Resolution:	createdByJET & lastUpdatedByJET properties re now displayed in Search pages when user scrolls
38353210		POL-17663	Tab Space is present in floorplan Code
Description:	MEDICAREDISENROLLMENTREASONS flooplan has space in the code, which needs to be removed. Also unique name to be given for system floorplan, view and Edit Object List template of MEDICAREDISENROLLMENTREASONS
Resolution:	Space is removed in floorplan code for MEDICAREDISENROLLMENTREASONS and code is changed for MedicareDisEnrollmentReasons LOV as MEDICAREDISENRREASONSLOV
38406131		POL-17742	Include error cause in RuntimeException for POST/PATCH save requests of Dynamic Logic
Description:	For POST/PATCH requests of dynamic logic, the error response only provides the location of the corresponding trace file. To identify the root cause, the user must manually check the trace file, which is inconvenient.
Resolution:	The error response has been improved to include both the actual error details and the location of the corresponding trace file. This will allow users to quickly identify the root cause of the issue.
38405720		POL-17739	Reprocessing a Policy executes all process steps
Description:	When Policy processing fails due to a technical error, the system retries processing the policy. During the retry, the process steps are executed one by one, but the system does not stop executing them once a pend rule is applicable and the policy is pended. As a result, multiple pend rules can be executed and applied, resulting in the system trying to pend the policy multiple times and throwing a NullPointerException.
Resolution:	When Policy processing fails due to a technical error, the system retries processing the policy and it will stop processing once a pend rule applies.
38400812		POL-17736	Remove duplicate access from setup access role
Description:	Remove duplicate access from setup access role which are already present in CO0019
Resolution:	keyboardshortcuts API and floorplans.enhance IP added to CO0019 function code and also removed access restrictions which was duplicate entry of CO0019 mapping from setup access role

BugDB

Internal

Summary

38408803

3-38943334671

POL-17745

An empty change list is created for connector configurations when a connector is created using JET UI.

Description:

When creating a connector configuration through JET UI, an empty change list is added by default. This empty list blocks any change event from getting transmitted to external systems.

Resolution:

Empty change list is removed when saving a connector in UI

37854835

POL-17049

The applyRegistration activity is blocked due to table lock held by nextcalculationcyle IP process

Description:

ApplyRegistration activity is sometime getting blocked due to table lock held by concurrently running nextcalculationcyle IP process

Two new protected properties were introduced to implement retry logic. 1. ohi.activityprocessing.separate.execution.group.initial.wait.time 2. ohi.activityprocessing.separate.execution.group.max.retry.count

Resolution:

A retry mechanism has been incorporated into the applyRegistration activity execution, giving concurrent nextcalculationcyle IP processes time to finish and release their locks, so subsequent attempts complete successfully without encountering a resource-busy exception.

38455974

POL-17791

Date fields should be shown at the last in Reference Sheet Lines table

Description:

Sequence is applied for dynamic columns but Start Date and end date is not displayed at the last in Reference Sheet Lines table

Resolution:

Columns are sorted based on sequence and Start/End date are shown at the last

38439930

POL-17774

In Activity pages, for Column 'created By', values are not displayed on scroll

Description:

Policy Activities page: user log (created By) values are not displayed when user tries to load records with scroll bar.

Resolution:

createdByJET & lastUpdatedByJET properties re now displayed in Search pages when user scrolls

38353210

POL-17663

Tab Space is present in floorplan Code

Description:

MEDICAREDISENROLLMENTREASONS flooplan has space in the code, which needs to be removed. Also unique name to be given for system floorplan, view and Edit Object List template of MEDICAREDISENROLLMENTREASONS

Resolution:

Space is removed in floorplan code for MEDICAREDISENROLLMENTREASONS and code is changed for MedicareDisEnrollmentReasons LOV as MEDICAREDISENRREASONSLOV

38406131

POL-17742

Include error cause in RuntimeException for POST/PATCH save requests of Dynamic Logic

Description:

For POST/PATCH requests of dynamic logic, the error response only provides the location of the corresponding trace file. To identify the root cause, the user must manually check the trace file, which is inconvenient.

Resolution:

The error response has been improved to include both the actual error details and the location of the corresponding trace file. This will allow users to quickly identify the root cause of the issue.

38405720

POL-17739

Reprocessing a Policy executes all process steps

Description:

When Policy processing fails due to a technical error, the system retries processing the policy. During the retry, the process steps are executed one by one, but the system does not stop executing them once a pend rule is applicable and the policy is pended. As a result, multiple pend rules can be executed and applied, resulting in the system trying to pend the policy multiple times and throwing a NullPointerException.

Resolution:

When Policy processing fails due to a technical error, the system retries processing the policy and it will stop processing once a pend rule applies.

38400812

POL-17736

Remove duplicate access from setup access role

Description:

Remove duplicate access from setup access role which are already present in CO0019

Resolution:

keyboardshortcuts API and floorplans.enhance IP added to CO0019 function code and also removed access restrictions which was duplicate entry of CO0019 mapping from setup access role

Issues that were backported in previous Release / Patch

No backports.