Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 3.22.2.0.1

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

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

No enhancements.

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

This section intentionally left blank.

Data Conversion

This section intentionally left blank.

Dynamic Logic

This section intentionally left blank.

UI Changes

This section intentionally left blank.

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

34867195

POL-11720

BP

Display attribute set to 'never' is not working for dynamic fields mentioned in floorplan when autoinclude is set to yes

Description:

Dynamic field is shown in persons page UI and able to edit it in extensibility drawer, even though the property is added to the floorplan and display attribute is set to never.

Resolution:

Dynamic field is not shown in extensibility drawer when configured in the floorplan and display attribute 'never' is set

34868014

POL-11730

BP

Additional Fields: Apply and Cancel buttons are shown in View mode

Description:

Apply and Cancel buttons are shown in View mode in additional fields drawer

Resolution:

Only Cancel button is displayed for view mode in additional fields drawer

34868497

POL-11732

BP

File uploader cannot upload .zip files on MAC and LINUX

Description:

The user is not able to import zip files using file uploader on MAC and LINUX systems.

Resolution:

File uploader can import Zip files on Mac and Linux.

34871379

3-28306159971

POL-11739

BP

Enrollment products are not created due to an error in the adjustment rules

Description:

Enrollment products are not created due to an error in the adjustment rules

Resolution:

Enrollment products can be imported after CMT migration without any error in adjustment rules.

34871739

POL-11743

BP

Add to Floorplan - Next button is not responding

Description:

Create a usage Field and click on add to floor plan. Select custom Floor plan and click on next. Select the set and select 'Create new tile'. Now Next button is not responding

Resolution:

Next button is working fine in Usages page when Add To Floorplan action is performed

34872575

POL-11746

BP

Group Setup: Group Account LOV is not responding in bill Allocation tab

Description:

Create group client and group account, navigate to products and create new row. Now open Group Setup and navigate to Tab Bill Allocation. When trying to access group account drop down it is not responding

Resolution:

Search is performed without errors when context string has a trailing space as well

34874833

POL-11754

BP

Unsaved pop up message is showing when user clicks on add button after searching with blank data in search box

Description:

On performing a blank search and then clicking the add button, unsaved pop up is being shown. Pop-up is also shown while scrolling to fetch more rows. The issue doesn’t occur if new rows are added without doing a blank search

Resolution:

Unsaved pop up message doesn’t show when user clicks on add button in table pages, after performing a blank search

34875822

3-31142348479

POL-11757

BP

Flexcodesystem and flexcodes imported through cmt set on a target environment are not correctly mapped for all the translations

Description:

When a CMT set having flexcodes values is imported, then flexcodes are not correctly mapped to their respective field usages for all the translations. They are working fine only for locale translation.

Resolution:

After this fix, when importing flexcodesystem and flexcodes with CMT, flexcodes are correctly mapped to their respective field usages for all the translations.

34876003

3-31459159051

POL-11759

BP

Extract on financialgroupingcombinations low performance issue

Description:

Extract on financialgroupingcombinations is having low performance issue because currently full table scan is happening on FIN_TRANS_PROCESS_DATA table.

Resolution:

Added indexes on FIN_TRANS_PROCESS_DATA table in policies application to improve performance.

34885853

3-31391733371

POL-11776

BP

OHI accepts dynamic field numeric content of 13 digits while 12 is defined as max. length

Description:

When a Field Definition is created as type 'Number' with a specific length, with no Decimal value, and when value is assigned to it from that specific UI page, the accepted length of the number is one greater than the specified value.

Resolution:

Field Definition of type 'Number' accepts correct length even with no Decimal value.

34904071

POL-11809

BP

Policy details page is not refreshed automatically when user navigates from PUR object navigation

Description:

Navigate to policy update requests object navigation link for any policy. Pick any PUR in 'Queued' status and click on 'Apply Update' action button. PUR record will now goes to 'Loaded' status. Navigate to Policy details observer still old version of policy details are displayed, user has to click on refresh button manually to view the version drop down in order to view the latest version of policy.

Resolution:

Policy details page is refreshed automatically when user navigates from policy update requests object navigation after 'Apply Update' action

34911346

POL-11816

BP

Apply button is not responding in additional fields drawer when mandatory dynamic records are configured

Description:

Make a Dynamic Record as mandatory from usages page. Create a new claim and click on additional fields drawer. Apply button is not responding, in the browser console an error to fill in the Extensibility tab level is logged

Resolution:

Apply button in additional fields drawer works fine with mandatory dynamic records configured

34911595

POL-11818

BP

Field with SVTV Flex code and mandatory are not responding in additional fields drawer

Description:

Create SVTV Flex code which is mandatory for Enrollment products and fill the data for this field in the additional fields drawer. It results in an error stating to fill the data

Resolution:

SVTV Flex code field values can be added without any error in additional fields drawer

34912870

3-31473737731

POL-11820

BP

Purge Policy Operation is slow

Description:

Purging a policy with calculation results is slow.

Resolution:

Added foreign key indexes to improve performance. Also in purge operation, removal of calculation result lines referring to other lines (so called reversals) is added. Furthermore, when a policy enrollment product is removed, the performance is improved.

34916508

3-31593141171

POL-11827

BP

System generates Person Covered Services for Policies in Edit status

Description:

When a person in enrolled on multiple Policy, the Person Covered Services will be generated for all the policy enrollments on all enrolled Policies regardless of the Policy status. That includes Policies in Edit and Canceled status.

Resolution:

Person Covered Services are only generated for policies in Processing or Approved status.

34916857

POL-11829

BP

While creating a policy account transaction On Policy accounts page, the LOV on the account transaction type selects the wrong subset

Description:

While creating a policy account transaction On Policy accounts page, the dropdown on the account transaction type selects the wrong subset.

Resolution:

While creating a policy account transaction in Policy accounts page, 'Account Transaction Type' dropdown shows proper filtered values.

34921610

3-29584669481

POL-11841

BP

OptimisticLockingException when updating lastlogintimestamp of the user

Description:

Updating lastLoginTimestamp is controlled by a system property ohi.ws.last.login.update.threshold i.e the lastLoginTimestamp is not updated if the user logs-in multiple times with in the same hour.But if there are concurrent requests next second after this hour, both the API/IP requests try to update the same user record, system throws 500 error in this case.

This causes problem in updating the LASTLOGINTIMESTAMP

Resolution:

Error thrown by the system is ignored in case there are concurrent requests to update the same user record. The LASTLOGINTIMESTAMP will be set according to the first request that updates the user record amongst all the incoming concurrent requests.

34941939

POL-11855

BP

Update of Non-transferable attributes is not allowed

Description:

When using the Policy-In IP Patch functionality, non-transferable child entities updation is allowed for time valid entities. But, this only works when the child entity that is sent in, including the updates, has the same start- and end date as the existing child entity. This causes issues when user tries to update end date

Resolution:

When an updated child entity is sent in, the system will update the existing entity without matching on end date.

34944203

3-31663358871

POL-11857

BP

Tier evaluation not working as expected

Description:

Correct tier is not picked up during the premium calculation when premium tier enrollment type is set to be exactly - 0 and its throwing an error.

Resolution:

Correct tier will be picked up for exactly - 0 case as well from now on.

34963766

POL-11919

BP

Provider search is taking around 30sec average to load a provider

Description:

Provider search takes an average of around 30sec as response time.

Resolution:

Added function based index on REL_PROVIDERS table NAME column to improve performance.

34976243

3-31608496476

POL-11954

Support backward compatibility for Line Of business to Insurance Type in Policy In (Patch) IP

Description:

The policy’s reference to line of business has been renamed to insurance type. This creates a breaking change on the Policy In (Patch) IP as the 'new' insuranceTypeCode is mandatory.

Resolution:

If the payload does not contain the insuranceTypeCode attribute, the application uses the lineOfBusinessCode to determine the insurance type. In this case, the application does not set the line of business. In this scenario, if lineOfBusinessCode does not match any insurance type, the application returns POL-IP-POLI-026.

The response always contains the insuranceTypeCode, regardless of whether it was set by the logic specified above.

If the customer wants to uptake the new features around the line of business, the policy in payload needs to be adjusted to include the insuranceTypeCode attribute.

In release 4.23.1.0.0 this backward compatibility feature in Policy In (Patch) IP is no longer supported. This feature only applies for Policy In IP and is not supported in the generic API.

34976329

POL-11955

BP

Activity recovery at startup time does not set process_stop_datetime

Description:

When an activity in 'Initial' or 'In process' status was set to 'Technical Error' status, process_stop_datetime was not set accordingly hence giving an impression that the activity’s elapsed time keeps increasing.

Resolution:

The update query which sets the 'Technical Error' status has been modified to set the correct process_stop_datetime as well.

34977415

POL-11957

BP

Floorplan changes for Auto Include Extensibility.

Description:

The floorplan page allows auto include extensibility to set to be true and also existing floorplans have auto include extensibility set to true for templates other than SEARCH TABLE, VIEW EDIT LIST and VIEW EDIT HIERARCHICAL RECURSIVE.

Resolution:

All the existing floorplans of templates other than SEARCH TABLE, VIEW EDIT LIST and VIEW EDIT HIERARCHICAL RECURSIVE have auto include extensibility flag set to false and also while creating new floorplan, it conditionally displays the auto include extensibility based on the template.

34997351

3-31868801241

POL-12018

BP

Generate mutations activity does not check policy events on older approved versions

Description:

If there are policy events of event level 'Policy' on older approved policy (not latest approved version), then the generate mutations activity does not create mutations from these events, but does remove them.

Resolution:

The generate mutations activity correctly checks policy events of event level 'Policy', and creates mutations from them, also if the policy events are on older approved policy versions.

Issues that were backported in previous Release / Patch

No backports.