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. |
| As per the Service Description, you are obligated to request a service upgrade within 90 days of this release being generally available (GA). In line with the Oracle Cloud Services Pillar document, Section 4.2.2 End of Life, this release will be EOL in 12 months. |
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 |
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. |
||