Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 3.22.2.0.14

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

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

ID Summary Patch

POL-13072

Ability to calculate sample invoice and invoice for the duration before the start of regular collection cycle

System calculates the period before regular cycle start as part of first cycle. However, it is expected that to calculate only catch up in case of invoice and sample invoice IP.

POL-13215

Enable open parameter values on ended policy enrollment products

This enhancement enables having parameter values and policy add-ons with open end dates on policy enrollment products with an end date.

POL-13270

Unsend Financial Messages for a Financial Transaction Set

This enhancement introduces a new activity, 'Unsend financial messages per set,' enabling users to unsend the financial messages generated for financial transactions of type 'Premium' and 'Premium Based Commission ' for a specific Financial Transaction Set.

Documentation Links:
Operations Guide

POL-13309

Datafile Link query improvement

Performance improvement of datafile query returning the datafile link using message code/datafile code.

POL-13310

Disable gather stats on FIN$SELECTED_FIN_TRANSACTIONS

When concurrent GENERATE_FIN_MSG_XML activities are executed in parallel, statistics gathering on fin$selected_fin_transactions table consumes high DB time and CPU. The statistics gathering is optimized now.

POL-13311

Disable gather stats on ACT$ACTIVITY_BUCKETS

When concurrent SELECT_TRANSACTIONS_IN_SET activities are executed in parallel, statistics gathering on act$activity_buckets table consumes high DB time and CPU. The statistics gathering is optimized now (also introduced a new table fin$activity_buckets to use in SELECT_TRANSACTIONS_IN_SET activity).

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 BP Summary

35634076

POL-13279

BP

Creating POL fails when "POL Code Generation" dynamic logic is executed first time after invalidating dynamic logic cache

Description:

Creating policies fails when "POL Code Generation" dynamic logic is executed first time after invalidating dynamic logic cache.

Resolution:

After dynamic logic is invalidated, dynamic logic is queried by code and that does not do an implicit flush. Code will be created with the dynamic logic provided in "POL Code Generation"

35633917

POL-13277

BP

Records are not sorted even if default sort is defined in payload for widgets

Description:

Create/update any widget to have default sort section added in payload. Add the widget as a card/dashboard. Records are not sorted in widgets

Resolution:

Records are sorted properly as defined in the payload for widgets

35629487

3-33527140221

POL-13269

BP

Using coalesce function when creating group account child activities in CALCULATE_PREMIUM activity follows an inefficient access path

Description:

Using coalesce function when creating group account child activities in CALCULATE_PREMIUM activity follows an inefficient access path

Resolution:

Creation of group account child activities in CALCULATE_PREMIUM activity is optimized

35573984

3-33590706721

POL-13145

BP

Unable to view the values of 'Parameter Domains' in drill down View for Group Account Products.

Description:

When a user navigates to Manage Group Account Page > Products Object Navigation Link > Parameter Domain Tab, the user is unable to view the values of "parameter domains" in the drill down View for Group Account Products.

Resolution:

Parameter domain values visible in drill down view for Group Account Products.

Issues that were backported in previous Release / Patch

No backports.