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 |
4.24.1.0.0 |
POL-15334 |
Additional data masking functions This enhancement introduces two new data masking functions:
Along with the new masking functions:
|
4.24.1.0.7 |
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 ofohi_install.cfg.template
and name itohi_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:
-
Open a command window and browse to
<OHI_ROOT>/util/install
. -
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
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 |
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. |