Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.23.1.0.10

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

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

No enhancements.

Upgrade Steps for Installation

To perform the upgrade, perform the following steps:

  1. Perform any pre-upgrade steps.

  2. Stop all the managed nodes running the existing version of the application.

  3. Perform any pre-undeploy steps.

  4. Undeploy the existing version of the application.

  5. Back up the database.

  6. Perform any post-undeploy steps.

  7. Unpack the release bundle into a directory that we refer to as OHI_ROOT from now on.

  8. Change Installation Configuration: In <OHI_ROOT>/util/install, make a copy of ohi_install.cfg.template and name it ohi_install.cfg.

  9. Edit ohi_install.cfg to contain your specific database connection data and other configuration settings. The settings are explained in the file itself.

  10. Make sure NO connections are present to the database using the OHI_xxx_USER account (where xxx is the abbreviation of the application)

  11. 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 .

  12. Make the required changes to the ohi properties file

  13. Perform any post-upgrade steps

  14. Start WebLogic application server

  15. Deploy the Application

  16. 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.

Breaking Changes

This section intentionally left blank.

Bug Fixes

BugDB SR Internal Summary

37436372

3-38082342431

POL-16418

Improve the Activity recovery query when node crashes

Description:

When a node is crashed, the other nodes try to recover the activities from the crashed node. During this recovery the select query on activities was too costly resulting in SQLException "Socket read interrupted" - i.e connection timeout.

Resolution:

The SELECT query was optimized, and the index on the activity table was updated to prevent a full table scan. This significantly reduced the recovery cost and effectively resolved the connection timeout issue.

37406102

3-39093009551

POL-16401

Data file deletion operation during extract run is expensive

Description:

The data-file deletion operation is a costly affair during extract execution. The query perform index fast full scan causing slowness

Resolution:

The select and delete query on dat_data_files was improved by joining with data file-set id

37647440

3-39093831091

POL-16715

GEN-TMVL-011 is thrown during Person Covered Service generation

Description:

When submitting a policy, Person Covered Services are generated if the dynamic logic with signature 'Person Covered Service' is configured. In that dynamic logic a user can configure the setPersonCoveredService method which regenerates Person Covered Services. This operation is sometimes throwing a GEN-TMVL-011 error, indicating a time overlap in Person Covered Services. This error is thrown when an existing Person Covered Service is first updated, then deleted and re-inserted.

Resolution:

Person Covered Service generation is not throwing a GEN-TMVL-011 error when an existing Person Covered Service is being updated, then deleted and re-inserted.

Issues that were backported in previous Release / Patch

No backports.