Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.23.2.0.3

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

Version compatibility: Oracle Health Insurance Enterprise Policy Administration Release 4.23.2.x is only compatible with other Oracle Health Insurance applications release version 4.23.2.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

ID	Summary	Patch
NXT-28449	Additional functionality for UI Form component With this enhancement, the UI `Form` component now supports: Editable list resources Sort capabilities for tables configured within a `Form` Conditionally hiding a sub-section	4.23.2.0.1
POL-14132	Clearance of activities stuck in In Process stage from coherence submission caches using IP Due to excessive load, the processing-pattern grid service stops processing activities, causing them to be stuck in the in process stage for a long time. Manually marking these activities to technical error (TE) and resubmitting them results in an exception as a reference to these activities already exist in coherence submission caches. Thus, the recovery of activities is only possible upon a full restart. The new integration point supports the clearance of coherence submission caches to facilitate the activity recovery process to avoid a complete restart. Documentation Links: Developer Guide - Clear Coherence Submission Cache Integration Point	3.22.2.0.26, 4.23.1.0.5

NXT-28449

Additional functionality for UI Form component

With this enhancement, the UI Form component now supports:

Editable list resources
Sort capabilities for tables configured within a Form
Conditionally hiding a sub-section

4.23.2.0.1

POL-14132

Clearance of activities stuck in In Process stage from coherence submission caches using IP

Due to excessive load, the processing-pattern grid service stops processing activities, causing them to be stuck in the in process stage for a long time. Manually marking these activities to technical error (TE) and resubmitting them results in an exception as a reference to these activities already exist in coherence submission caches. Thus, the recovery of activities is only possible upon a full restart. The new integration point supports the clearance of coherence submission caches to facilitate the activity recovery process to avoid a complete restart.

Documentation Links:
Developer Guide - Clear Coherence Submission Cache Integration Point

3.22.2.0.26, 4.23.1.0.5

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-14846	Added	ohi.oauth.token.jwt.assertion.param.name Name of JWT assertion parameter used in OAuth token request. It could be different across OAuth server. Default value is "assertion"

Ref

Action

Description

POL-14846

Added

ohi.oauth.token.jwt.assertion.param.name

Name of JWT assertion parameter used in OAuth token request. It could be different across OAuth server. Default value is "assertion"

Web Services

Ref	Action	Description
POL-14132	Added	clearsubmissioncaches IP New IP to clear coherence submission caches.
POL-14846	Added	Generic API for OAuthParameter Introduced generic APIs to manage OAuth parameters. Refer /generic/oauthparameters/metadata to know available endpoints to manage OAuthParameter entity
POL-14846	Modified	oauthclientcredentialsgrantconfigurations Supports configuration of OAuth parameters through oAuthClientParameters
POL-14846	Modified	oauthassertionjwtbearergrantconfigurations Supports configuration of OAuth parameters through oAuthClientParameters

Ref

Action

Description

POL-14132

Added

clearsubmissioncaches IP

New IP to clear coherence submission caches.

POL-14846

Added

Generic API for OAuthParameter

Introduced generic APIs to manage OAuth parameters. Refer /generic/oauthparameters/metadata to know available endpoints to manage OAuthParameter entity

POL-14846

Modified

oauthclientcredentialsgrantconfigurations

Supports configuration of OAuth parameters through oAuthClientParameters

POL-14846

Modified

oauthassertionjwtbearergrantconfigurations

Supports configuration of OAuth parameters through oAuthClientParameters

Data Conversion

This section intentionally left blank.

Dynamic Logic

This section intentionally left blank.

UI Changes

Ref	Action	Description
NXT-28449	Modified	Policy Enrollment page Form Table is made editable and sort is enabled in the form table for policy enrollment page with 'MEDICARE_ADVANTAGE' tag

Ref

Action

Description

NXT-28449

Modified

Policy Enrollment page

Form Table is made editable and sort is enabled in the form table for policy enrollment page with 'MEDICARE_ADVANTAGE' tag

Breaking Changes

This section intentionally left blank.

Bug Fixes

BugDB	SR	Internal	Summary
36552243	3-36171988661	POL-15073	Date Paid To is not reset when enrollment ended and future dated payments exist
Description:	When policy enrolllment products are all (retroactively) ended while applied registrations exist after the end date, the date paid to is not reset to the end date of the policy enrollment products when apply registrations is executed.
Resolution:	If there are no new calculation results, but only reversed calculation results (which means that the (unzipped) registrations are no longer applicable for that period that is reversed): the date paid to is set to the start date of the first reversed calculation result minus one day.
36508201	3-36340300401	POL-15022	Unable to add a new contract period for renewal
Description:	After creating and approving a policy there is no way add a new policy Contract Period
Resolution:	Multiple policy Contract Periods can be added when policy page is in edit mode
36410453	3-34612052061	POL-14818	JWT bearer grant type is not working
Description:	OHI supports both client_credentials and urn:ietf:params:oauth:grant-type:jwt-bearer (shortly referred as JWT bearer) grant types in OAuth, however JWT bearer grant type is not working as expected.
Resolution:	Fixed logical issues in code to make it working
36463891	3-36178016821,3-36314937451,3-36339863591	POL-14944	Parameter value of type percentage with value 0 is not displayed
Description:	When a parameter on enrollment products of type percentage has a value of 0, it’s not displayed in JET
Resolution:	Parameter Value of type Percentage with value 0 will be displayed in enrollment products section of policies page
36485010	3-35901354371	POL-14992	Incorrect value in changelist payload sent by jet ui for integration connector
Description:	The Payload for changelist in Integration Connector sent by JET UI contains incorrect values
Resolution:	The Payload for changelist in Integration Connector sent by JET UI is corrected as per documentation and Integration Connector works fine without issues in payload
36416431	3-34612052061	POL-14846	OAuth parameters should be configurable
Description:	OHI product supports only standard OAuth parameters. As its value/name can deviate across OAuth server, OHI application isn’t able to establish connection with OAuth server.
Resolution:	Introduced capability in OHI product to define custom OAuth parameters. These parameters can be reused across different OAuth clients later.
36445473	3-36168869491	POL-14918	Adding multiple parameters in Enrollment, Parameter Domain tab ends up in GEN-ORA-01400
Description:	Create a Enrollment Products, along with 'percentage parameter' of Parameter Domains tab. Make sure to added 2 or more using Attach and Next button and when saving getting Error: GEN-ORA-01400: "PARA_ID" column is mandatory for the table "POL_PARAMETER_DOMAINS"
Resolution:	Attach & Next button works properly now. Thus, able to add multiple parameters in Enrollment, Parameter domain tab without any error.
36562440		POL-15097	Macro payload that is sent out contains displayName instead of usageName for macro parameters.
Description:	A macro definition that triggers an OIG integration which has 2 fields- 'Usage Name' and 'Display Name'. The resulting payload needs to include the usage name, when sending parameters to OIG. But it includes the display name.
Resolution:	UsageName is included in macro payload instead of displayName for macro parameters in the payload.
36393269	3-35684326321	POL-14789	Data from technical table is not cleaned up if an extract activity fails which leads to data accumulation
Description:	Data from technical tables were only getting cleaned for activities in 'CO' status which was causing accumulation of huge data.
Resolution:	Along with status 'CO' all other statuses except 'IN', 'IP' and 'QD' are now included as part of cleaning process. This ensures a more cleaner technical table, hence overcoming the issue of data accumulation
36562913	3-34871101921	POL-15100	filename contains diacritics, upload erroneously transforms the filename to some other characters.
Description:	Uploading a file , where the filename contains diacritics, erroneously transforms the filename into different characters.
Resolution:	By incorporating standard encoding for UTF-8 and ISO_8859-1 in multiform requests, filename with diacritics is not getting corrupted.
36167114		POL-14268	Deselect all checkbox is not working in table component
Description:	Deselect all checkbox is not working in table component used in pages like claimlines, Enrollment Event Notifications
Resolution:	Deselect all checkbox works as expected in table component and all the rows loaded in the page are deselected

BugDB

Internal

Summary

36552243

3-36171988661

POL-15073

Date Paid To is not reset when enrollment ended and future dated payments exist

Description:

When policy enrolllment products are all (retroactively) ended while applied registrations exist after the end date, the date paid to is not reset to the end date of the policy enrollment products when apply registrations is executed.

Resolution:

If there are no new calculation results, but only reversed calculation results (which means that the (unzipped) registrations are no longer applicable for that period that is reversed): the date paid to is set to the start date of the first reversed calculation result minus one day.

36508201

3-36340300401

POL-15022

Unable to add a new contract period for renewal

Description:

After creating and approving a policy there is no way add a new policy Contract Period

Resolution:

Multiple policy Contract Periods can be added when policy page is in edit mode

36410453

3-34612052061

POL-14818

JWT bearer grant type is not working

Description:

OHI supports both client_credentials and urn:ietf:params:oauth:grant-type:jwt-bearer (shortly referred as JWT bearer) grant types in OAuth, however JWT bearer grant type is not working as expected.

Resolution:

Fixed logical issues in code to make it working

36463891

3-36178016821,3-36314937451,3-36339863591

POL-14944

Parameter value of type percentage with value 0 is not displayed

Description:

When a parameter on enrollment products of type percentage has a value of 0, it’s not displayed in JET

Resolution:

Parameter Value of type Percentage with value 0 will be displayed in enrollment products section of policies page

36485010

3-35901354371

POL-14992

Incorrect value in changelist payload sent by jet ui for integration connector

Description:

The Payload for changelist in Integration Connector sent by JET UI contains incorrect values

Resolution:

The Payload for changelist in Integration Connector sent by JET UI is corrected as per documentation and Integration Connector works fine without issues in payload

36416431

3-34612052061

POL-14846

OAuth parameters should be configurable

Description:

OHI product supports only standard OAuth parameters. As its value/name can deviate across OAuth server, OHI application isn’t able to establish connection with OAuth server.

Resolution:

Introduced capability in OHI product to define custom OAuth parameters. These parameters can be reused across different OAuth clients later.

36445473

3-36168869491

POL-14918

Adding multiple parameters in Enrollment, Parameter Domain tab ends up in GEN-ORA-01400

Description:

Create a Enrollment Products, along with 'percentage parameter' of Parameter Domains tab. Make sure to added 2 or more using Attach and Next button and when saving getting Error: GEN-ORA-01400: "PARA_ID" column is mandatory for the table "POL_PARAMETER_DOMAINS"

Resolution:

Attach & Next button works properly now. Thus, able to add multiple parameters in Enrollment, Parameter domain tab without any error.

36562440

POL-15097

Macro payload that is sent out contains displayName instead of usageName for macro parameters.

Description:

A macro definition that triggers an OIG integration which has 2 fields- 'Usage Name' and 'Display Name'. The resulting payload needs to include the usage name, when sending parameters to OIG. But it includes the display name.

Resolution:

UsageName is included in macro payload instead of displayName for macro parameters in the payload.

36393269

3-35684326321

POL-14789

Data from technical table is not cleaned up if an extract activity fails which leads to data accumulation

Description:

Data from technical tables were only getting cleaned for activities in 'CO' status which was causing accumulation of huge data.

Resolution:

Along with status 'CO' all other statuses except 'IN', 'IP' and 'QD' are now included as part of cleaning process. This ensures a more cleaner technical table, hence overcoming the issue of data accumulation

36562913

3-34871101921

POL-15100

filename contains diacritics, upload erroneously transforms the filename to some other characters.

Description:

Uploading a file , where the filename contains diacritics, erroneously transforms the filename into different characters.

Resolution:

By incorporating standard encoding for UTF-8 and ISO_8859-1 in multiform requests, filename with diacritics is not getting corrupted.

36167114

POL-14268

Deselect all checkbox is not working in table component

Description:

Deselect all checkbox is not working in table component used in pages like claimlines, Enrollment Event Notifications

Resolution:

Deselect all checkbox works as expected in table component and all the rows loaded in the page are deselected

Issues that were backported in previous Release / Patch

No backports.