Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.23.1.0.11

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

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-13518

Endpoint change for data masking definitions

As part of this enhancement, the endpoint to configure and maintain data masking definitions is updated to /datamaskingdefinitions along with updated response messages.

4.24.1.0.0

POL-15334

Additional data masking functions

This enhancement introduces two new data masking functions:

  • Text hash with seed, preserve size

  • Number hash with seed, preserve size

Along with the new masking functions:

  • New fields are added to the list of allowed native fields that can be part of the masking process.

  • Additional tables/columns are now purged as part of the masking process.

4.24.1.0.7

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

Ref Action Description

POL-13518

Added

datamaskingdefinitions IP

deidentificationmetadata IP got renamed to datamaskingdefinitions IP

POL-13518

Added

datamaskingdefinitions API

deidentificationmetadata API got renamed to datamaskingdefinitions API

Data Conversion

This section intentionally left blank.

Dynamic Logic

This section intentionally left blank.

UI Changes

This section intentionally left blank.

Breaking Changes

Ref Action Description

POL-13518

Removed

deidentificationmetadata IP

deidentificationmetadata IP got renamed to datamaskingdefinitions IP

POL-13518

Removed

deidentificationmetadata API

deidentificationmetadata API got renamed to datamaskingdefinitions API

Bug Fixes

BugDB SR Internal Summary

37749025

3-40052010521

POL-16811

SQL to fetch premium schedule lines in Quote IP uses inefficient access path

Description:

The SQL query used for fetch premium schedule lines in the Quote IP uses inefficient access path, leading to high response time.

Resolution:

The SQL query has been optimized to follow a more efficient access path and a new index has been added to the table to enhance search performance.

37660902

3-39289517481

POL-16730

Getting row lock contention when running sampleinvoice IP

Description:

sampleinvoice IP taking more than 60s to return the response. The Api call internally invokes a plsql procedure that puts record under lock for the current transaction. When sampleinvoice is triggered for same policy ID, response time of more than 60s is observed.

Resolution:

A NOWAIT clause was incorporated into the PL/SQL procedure to immediately terminate any concurrent process waiting for the lock to be released. This fix optimizes the response time of the sampleinvoice IP call

37739254

3-40052010521

POL-16801

Database query to validate policy account in Quote IP uses inefficient access path

Description:

The database query to validate policy account in Quote IP uses inefficient access path, leading to high response time.

Resolution:

The database query is optimized to use a more efficient access path.

37749568

POL-16820

Activities are not purged when auto-purge job is enabled for Policies.

Description:

Following errors are being experienced in policies environment during the usage of Auto purge.

Error starting at line : 25 in command - BEGIN ohi_auto_purge_pkg.purge_all; END; Error report - ORA-20000: Failed jobs detected, check the table user_scheduler_job_run_details for details ORA-06512: at "OHI_POLICIES_OWNER.OHI_PARALLEL_JOBS_PKG", line 114

Cause for the error -

ORA-02292: integrity constraint (OHI_POLICIES_OWNER.FIN$ACTIVITY_BUCKET_FK1) violated - child record found ORA-06512: at "OHI_POLICIES_OWNER.OHI_ACT_PURGE_PKG", line 42 ORA-06512: at line 1

Resolution:

Ordering the PL/SQL script to delete child records before parent records resolved the issue.

Issues that were backported in previous Release / Patch

No backports.