Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.24.1.0.12
This document contains the release notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.24.1.0.12.
| Version compatibility: Oracle Health Insurance Enterprise Policy Administration Release 4.24.1.x is only compatible with other Oracle Health Insurance applications release version 4.24.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. |
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.templateand name itohi_install.cfg. -
Edit
ohi_install.cfgto 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
Breaking Changes
| Ref | Action | Description |
|---|---|---|
POL-17500 |
Modified |
Bill Allocation and Group account available product tabs System floorplan for premiumbillallocations, groupaccountproducts is modified for filter condition on Group client billing account, insurableClass, Enrollment Product, Enrollment Product Category, Group account Add On. Custom floorplans if any need to be modified by referring to system floorplan accordingly. |
POL-17341 |
Modified |
Process Flow pages, Group Clients page, Group Account Products page System floorplan for groupaccountproducts, groupclientbillingaccounts, grouprulesteps, policypendrulesteps, policyrulesteps is modified for filter condition on contactRelation, insurableClass, pendRule, calloutRule, validationRule. Custom floorplans if any need to be modified by referring to system floorplan accordingly. |
Bug Fixes
| BugDB | SR | Internal | Summary |
|---|---|---|---|
37689174 |
3-39953000191 |
POL-16766 |
PCPs with forward billing are skipped for apply registrations |
Description: |
A change in Collection Setting can result in consecutive Policy Calculation Periods (based on the start- and end date of those Policy Calculation Periods) having different pay dates. In most cases the pay date of the latest Policy Calculation Period will also be later compared to the pay date of the earliest Policy Calculation Period. But, when the earliest Policy Calculation Period was not paid for in the first place, the pay date will be pushed according to the principle of forward billing. This could result in a scenario where the latest Policy Calculation Period (based on start date), has a pay date which is earlier compared to its predecessor. When a registration is processed, the system starts applying the registration to the Policy Calculation Period with the earliest pay date and skip the forward billed Policy Calculation Period. |
||
Resolution: |
When there are Policy Calculation Periods found without a corresponding Calculation Result, the system skips Process Registrations and adds the informative message POL-FL-PREG-004 to the activity. If there is no activity spawned, no informative message is added. |
||
38041034 |
POL-17255 |
Performance degradation in activity processing due to the overhead caused by the heartbeat query |
|
Description: |
The cleanup_act_status activity monitoring heart-beat query, which performs a SELECT on the ACT_ACTIVITIES table to fetch records with status 'IP', is experiencing performance issues. The query is currently executing a full table scan as the status field is not indexed, resulting in increased execution time. |
||
Resolution: |
The query was optimized by using the VIRTUAL_UNPROCESSED_STATUS column, which is indexed and offers better performance. |
||
38216432 |
3-41533253061 |
POL-17500 |
Group client Enrollment Products Search is not working |
Description: |
Unable to add Insurable class and Enrollment product value. Getting "GEN-PROC-002: Value "undefined" provided is not of type Number" error. Similar issue is observed in Group Account Add On in Group account available product. |
||
Resolution: |
It is possible to add Insurable class, Enrollment product value and Group Account Add On by using dropdown |
||
38089636 |
3-41091694751 |
POL-17330 |
Policy details page is not loading when user validates any policy which is in edit status, also auto refresh not working after validation |
Description: |
When an existing policy contains a message without a process step, the Policy Details page fails to load. Additionally, if a policy is in edit status and a user validates and a message attached which doesn’t have process step, the page does not refresh after validation, and the Policy Details page fails to load. |
||
Resolution: |
Policy page loads now after Validate Operation without error. Note: There is a known issue that loading icon sometimes doesn’t get closed automatically in expanded view mode |
||
38250950 |
POL-17547 |
When executing data masking, ORA-00942: table or view does not exist. |
|
Description: |
When executing ohi_data_masking_pkg.mask_data_parallel, "ORA-00942: table or view does not exist" was raised. This was caused because of seed data that controls which tables or columns have to be truncated or nullified respectively contained references to non-existing tables. |
||
Resolution: |
Removed entries for non-existing tables in seed data for data masking. |
||
38013139 |
3-40699032496 |
POL-17248 |
'Submit after update?' field is not displaying correctly on the macro screens |
Description: |
When executing a macro for a Group Client or Group Account, the 'Submit after update?' field in the "Parameters" tab is not getting reflected. |
||
Resolution: |
Fix added to display value for 'Submit After Update' field in parameter tab. |
||
38068154 |
POL-17313 |
Added custom content-Length header (X-Content-Length) to the data file response for validation during file downloads in OIG |
|
Description: |
Enhance the getFileContents API in DataFile to include a custom response header X-Content-Length, allowing the calling application to verify if the full content has been received. If there’s a mismatch or if the response header is missing (incase of partial response) , the application can retry the API to retrieve the complete content |
||
Resolution: |
To address issues of incomplete or failed data file downloads in Oracle Insurance Gateway (OIG), content length validation has been implemented. This validation is triggered when OIG detects partial data by comparing the actual content length with the expected value provided in the custom response header "X-Content-Length". This header is now included in the POL data file response to enable accurate validation. |
||
38226872 |
3-40724895331 |
POL-17509 |
Tracking/Tracing of requests should not be sent to external systems |
Description: |
Tracing headers (such as B3 headers) are being sent to external systems. This leads to a 500 error response. However, when the spanId header is removed, the request goes through successfully with a 201 response |
||
Resolution: |
B3 Tracing headers will be added when the host of the request and the application are identical. |
||
38094932 |
3-41205595461 |
POL-17341 |
Unable to add a new validation rule, pend rule, or callout in the policy process flow |
Description: |
Unable to add a new validation rule, pend rule, or callout in the policy process flow. Getting "GEN-PROC-002: Value "undefined" provided is not of type Number (post , policyvalidationrules)" error. Similar issue is observed in Billings account Contact Relation field, Insurable class in Group account product and Group pend rules in Group process flow |
||
Resolution: |
It is possible to add a new validation rule, pend rule, or callout in the policy process flow. Similarly in group process flow, contact relation LOV, insurable class LOV in Group Account Products page |
||
38060674 |
3-40947650401 |
POL-17309 |
Dynamic fields information not shown in policy Bill receivers |
Description: |
Dynamic fields information not shown in policy Bill receivers since it is moved to 'more' section under Policy Bill Allocations as form table |
||
Resolution: |
Changes are made in the system specific floorplan to show Policy Bill Allocations as tab instead of form table |
||