Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 3.22.2.0.22

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

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:

  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

36211596

3-35379874711

POL-14420

FTS on high volume tables while creating policy level child activities for calculate premium resulting in a longer execution time

Description:

Inserting policy-level child activities was inefficient as the insert using select query performs FTS on high-volume tables. This resulted in a longer execution time for calculating premium activities.

Resolution:

The query creating child activities was improved to address the performance issue

36227311

3-35379874711

POL-14469

SQL execution plan to delete selected financial transactions for large group is inefficient

Description:

SQL execution plan to delete selected financial transactions (at the end of generate financial messages activity) for large group is inefficient

Resolution:

The SQL is optimized

Issues that were backported in previous Release / Patch

No backports.