Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.23.1.0.5

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

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

Summary

Patch

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

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

This section intentionally left blank.

Web Services

Ref	Action	Description
POL-14132	Added	clearsubmissioncaches IP New IP to clear coherence submission caches.

Ref

Action

Description

POL-14132

Added

clearsubmissioncaches IP

New IP to clear coherence submission caches.

Data Conversion

This section intentionally left blank.

Dynamic Logic

This section intentionally left blank.

UI Changes

This section intentionally left blank.

Breaking Changes

This section intentionally left blank.

Bug Fixes

BugDB	SR	Internal	Summary
36593620		POL-15137	Remove the usage of utl_tcp DBMS package in extract functionality
Description:	Using utl_tcp DBMS package requires explicit grant in SaaS environments. This has operational challenges as the grants that are explicitly granted are periodically revoked by DBA as part of a scheduled process
Resolution:	Removed the usage of utl_tcp DBMS package in extract functionality and replaced it with a standard DB function
36502542	3-36334533791	POL-15013	Access mapping (relation links api) missing for organization/person page
Description:	Upon clicking the person in the policy enrollment, the member window opens but does not loads the person details
Resolution:	Person details are loaded on clicking the person in the policy enrollment and there is no error related to access
36589107		POL-15129	Search on Datasetdefinitiondetails should return entity name in href link of Change Event Rules
Description:	When performing search on the entity datasetdefinitiondetails, in the response the href link of Change Event Rules should end with the entity name but was null
Resolution:	The resource endpoint was not matching with the entity name, hence getting null in the href. Updated the resource endpoint to match with the entity name Change Event Rules
36482359		POL-14987	Change event rules that monitor a person cannot trigger policy level output
Description:	No policy mutations are created for policy events of level Insurable Entity and type Output, with output definition of level Policy.
Resolution:	The corresponding policy mutations are now created for policy events of level Insurable Entity and type Output with output definition of level Policy.
36518257	3-36449302871	POL-15032	"Change Event Rules" Entity is missing in Configuration Migration Set
Description:	The entity "Change Event Rules" is missing in Configuration Migration Set
Resolution:	The entity "Change Event Rules" is available under Configuration Migration Set and has the same functionality as other entities.
36457033	3-36178016821,3-36314937451,3-36339863591	POL-14933	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
36485011	3-35901354371	POL-14993	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
36445475	3-36168869491	POL-14919	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.
36393276	3-35684326321	POL-14790	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
36562914	3-34871101921	POL-15101	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.
36403712		POL-14804	Global activities: Business error shown on bulk update invoke
Description:	Invoke a new activity on the global activities page in the JET UI. Pick BULK_UPDATE as the activity type and populate the required fields. Populate the group account from the drop down list. On Invoking the activity, getting business error.
Resolution:	Invoke activity is successful without business error for Bulk update using Group Account

BugDB

Internal

Summary

36593620

POL-15137

Remove the usage of utl_tcp DBMS package in extract functionality

Description:

Using utl_tcp DBMS package requires explicit grant in SaaS environments. This has operational challenges as the grants that are explicitly granted are periodically revoked by DBA as part of a scheduled process

Resolution:

Removed the usage of utl_tcp DBMS package in extract functionality and replaced it with a standard DB function

36502542

3-36334533791

POL-15013

Access mapping (relation links api) missing for organization/person page

Description:

Upon clicking the person in the policy enrollment, the member window opens but does not loads the person details

Resolution:

Person details are loaded on clicking the person in the policy enrollment and there is no error related to access

36589107

POL-15129

Search on Datasetdefinitiondetails should return entity name in href link of Change Event Rules

Description:

When performing search on the entity datasetdefinitiondetails, in the response the href link of Change Event Rules should end with the entity name but was null

Resolution:

The resource endpoint was not matching with the entity name, hence getting null in the href. Updated the resource endpoint to match with the entity name Change Event Rules

36482359

POL-14987

Change event rules that monitor a person cannot trigger policy level output

Description:

No policy mutations are created for policy events of level Insurable Entity and type Output, with output definition of level Policy.

Resolution:

The corresponding policy mutations are now created for policy events of level Insurable Entity and type Output with output definition of level Policy.

36518257

3-36449302871

POL-15032

"Change Event Rules" Entity is missing in Configuration Migration Set

Description:

The entity "Change Event Rules" is missing in Configuration Migration Set

Resolution:

The entity "Change Event Rules" is available under Configuration Migration Set and has the same functionality as other entities.

36457033

3-36178016821,3-36314937451,3-36339863591

POL-14933

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

36485011

3-35901354371

POL-14993

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

36445475

3-36168869491

POL-14919

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.

36393276

3-35684326321

POL-14790

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

36562914

3-34871101921

POL-15101

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.

36403712

POL-14804

Global activities: Business error shown on bulk update invoke

Description:

Invoke a new activity on the global activities page in the JET UI. Pick BULK_UPDATE as the activity type and populate the required fields. Populate the group account from the drop down list. On Invoking the activity, getting business error.

Resolution:

Invoke activity is successful without business error for Bulk update using Group Account

Issues that were backported in previous Release / Patch

No backports.