Release Notes for Oracle Health Insurance Enterprise Policy Administration Patch 4.25.1.0.4

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

Version compatibility: Oracle Health Insurance Enterprise Policy Administration Release 4.25.1.x is only compatible with other Oracle Health Insurance applications release version 4.25.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
NXT-32413	Increase max rows displayed on reference sheet lines page Number of Rows displayed is increased from 500 to 1500 for reference sheet lines. With this, scroll is supported upto 1500 records. Once 1500 lines are loaded, information message to refine search criteria is displayed
POL-17674	Extend field length for the fields on agent and broker entities. This enhancement extends the field length characters for the following fields on agent and broker entities. Broker Name- length to C200 Agent First Name â€“ length to C200 Middle Name â€“ length to C500

Summary

Patch

NXT-32413

Increase max rows displayed on reference sheet lines page

Number of Rows displayed is increased from 500 to 1500 for reference sheet lines. With this, scroll is supported upto 1500 records. Once 1500 lines are loaded, information message to refine search criteria is displayed

POL-17674

Extend field length for the fields on agent and broker entities.

This enhancement extends the field length characters for the following fields on agent and broker entities.

Broker Name- length to C200 Agent First Name â€“ length to C200 Middle Name â€“ length to C500

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

Ref	Action	Description
NXT-32413	Modified	Referencesheetlines Referencesheetlines table supports scroll up to 1500 lines.

Ref

Action

Description

NXT-32413

Modified

Referencesheetlines

Referencesheetlines table supports scroll up to 1500 lines.

Breaking Changes

This section intentionally left blank.

Bug Fixes

BugDB	SR	Internal	Summary
38204793	3-41007344251	POL-17494	Unable to add product in policy from Change Product option.
Description:	Unable to add product in policy from Change Product option as Ok button is not working as expected. No action is performed after clicking on Ok button when user selects current date as start date.
Resolution:	Change Product operation works fine in Policy Page.
38384208		POL-17717	Intermittent issues with updating dynamic logic
Description:	In certain scenarios, updates made to dynamic logic were not immediately reflected at runtime because the internal cache reload process could occur before the relevant database transaction was committed. This timing issue could cause the cache to be repopulated with stale data.
Resolution:	The dynamic logic cache reload process is now triggered only when the update transaction is committed, ensuring that the cache consistently reflects the most recent changes.
38333590	3-41408859911	POL-17644	Missing access restriction mapping for accountingdetails API on payment registrations page
Description:	'accountingdetails API' is not added as seed data for functional API access mapping for Payment Registrations page
Resolution:	Missing Access Restriction mapping added for Payment Registrations page
38350823		POL-17660	eventDate attribute in logapplicationevents and logdynamiclogicevents resources ignores time component
Description:	The eventDate attribute in both logapplicationevents and logdynamiclogicevents resources ignores time component in Query API. So, the query criteria including a time component (e.g., 2025-06-15T14:30:00 are not honored. The system defaults to 00:00:00 as the time, effectively filtering by date only. Also, the response payload includes only the date portion, omitting time entirely.
Resolution:	The eventDate attribute is updated to honor the time component in Query API criteria. The response now also includes the time component (hours, minutes, and seconds). Fractional seconds (e.g., milliseconds) are not included in the response.
38158921	3-41972215731	POL-17422	Spinner icon doesn’t get closed after validate, submit in Policies page
Description:	Validate any policy which is in edit state, then the page gets into loading state. Spinner icon is displayed and doesn’t get closed automatically after the Validate Action
Resolution:	Spinner icon closes automatically after the Validate or Submit Action
38273426	3-41471633021	POL-17559	Policy Calculation Period Unique Key violation thrown by Apply Registrations activity
Description:	The system throws a Policy Calculation Period Unique Key violation during Apply Registrations, when the policy has a suspension period that has a duration for over a year.
Resolution:	The system will not throw a Policy Calculation Period Unique Key violation and the registration will be applied.
38131983	3-41237424921	POL-17390	Duplicate entries in OHI_TABLE_COLUMNS
Description:	There are duplicate entries found in OHI_TABLE_COLUMNS for the Relation table, this could result in incorrect base views and a violation of the introduced Unique Key on OHI_TABLE_COLUMNS .
Resolution:	Removed duplicate entires from OHI_TABLE_COLUMNS.
38298900	3-41728688211	POL-17611	Task remains stuck in AQ with state '3', when not dequeued before expiry
Description:	Oracle AQ max_retries parameter was set to zero by default, preventing automatic retries when a node failed to dequeue a task due to memory errors. As a result, tasks were left stuck in state '3' in the queue. This needed manual intervention by marking the task status as 'ERRORED' and recovering the task using recovery API.
Resolution:	The 'max_retries' parameter has now been increased to 5. This would allow other healthy nodes to retry the dequeue operation, reducing the chance of tasks remaining stuck in AQ unless all nodes experience issues simultaneously.
38198426		POL-17487	Data transfer export to Oracle directory has issues with CSV and JSON formats
Description:	Data transfer export has issues: CSV output is invalid when string columns with commas are not escaped, JSON export returns empty values for CLOB columns exceeding 20MB, and JSON exports show only one file even when more records exist in the database.
Resolution:	Data transfer export now generates valid CSV output with escaped special characters, supports CLOB data in JSON format, and correctly reports the number of exported files.
38372949	3-41609968491	POL-17678	Column Headers are wrapped in widgets, lookup dialog etc
Description:	Headers are getting wrapped to fit in the size in components like widgets, lookup pop-up
Resolution:	Column Headers are now, not wrapped in widgets, lookup dialog etc

BugDB

Internal

Summary

38204793

3-41007344251

POL-17494

Unable to add product in policy from Change Product option.

Description:

Unable to add product in policy from Change Product option as Ok button is not working as expected. No action is performed after clicking on Ok button when user selects current date as start date.

Resolution:

Change Product operation works fine in Policy Page.

38384208

POL-17717

Intermittent issues with updating dynamic logic

Description:

In certain scenarios, updates made to dynamic logic were not immediately reflected at runtime because the internal cache reload process could occur before the relevant database transaction was committed. This timing issue could cause the cache to be repopulated with stale data.

Resolution:

The dynamic logic cache reload process is now triggered only when the update transaction is committed, ensuring that the cache consistently reflects the most recent changes.

38333590

3-41408859911

POL-17644

Missing access restriction mapping for accountingdetails API on payment registrations page

Description:

'accountingdetails API' is not added as seed data for functional API access mapping for Payment Registrations page

Resolution:

Missing Access Restriction mapping added for Payment Registrations page

38350823

POL-17660

eventDate attribute in logapplicationevents and logdynamiclogicevents resources ignores time component

Description:

The eventDate attribute in both logapplicationevents and logdynamiclogicevents resources ignores time component in Query API. So, the query criteria including a time component (e.g., 2025-06-15T14:30:00 are not honored. The system defaults to 00:00:00 as the time, effectively filtering by date only. Also, the response payload includes only the date portion, omitting time entirely.

Resolution:

The eventDate attribute is updated to honor the time component in Query API criteria. The response now also includes the time component (hours, minutes, and seconds). Fractional seconds (e.g., milliseconds) are not included in the response.

38158921

3-41972215731

POL-17422

Spinner icon doesn’t get closed after validate, submit in Policies page

Description:

Validate any policy which is in edit state, then the page gets into loading state. Spinner icon is displayed and doesn’t get closed automatically after the Validate Action

Resolution:

Spinner icon closes automatically after the Validate or Submit Action

38273426

3-41471633021

POL-17559

Policy Calculation Period Unique Key violation thrown by Apply Registrations activity

Description:

The system throws a Policy Calculation Period Unique Key violation during Apply Registrations, when the policy has a suspension period that has a duration for over a year.

Resolution:

The system will not throw a Policy Calculation Period Unique Key violation and the registration will be applied.

38131983

3-41237424921

POL-17390

Duplicate entries in OHI_TABLE_COLUMNS

Description:

There are duplicate entries found in OHI_TABLE_COLUMNS for the Relation table, this could result in incorrect base views and a violation of the introduced Unique Key on OHI_TABLE_COLUMNS .

Resolution:

Removed duplicate entires from OHI_TABLE_COLUMNS.

38298900

3-41728688211

POL-17611

Task remains stuck in AQ with state '3', when not dequeued before expiry

Description:

Oracle AQ max_retries parameter was set to zero by default, preventing automatic retries when a node failed to dequeue a task due to memory errors. As a result, tasks were left stuck in state '3' in the queue. This needed manual intervention by marking the task status as 'ERRORED' and recovering the task using recovery API.

Resolution:

The 'max_retries' parameter has now been increased to 5. This would allow other healthy nodes to retry the dequeue operation, reducing the chance of tasks remaining stuck in AQ unless all nodes experience issues simultaneously.

38198426

POL-17487

Data transfer export to Oracle directory has issues with CSV and JSON formats

Description:

Data transfer export has issues: CSV output is invalid when string columns with commas are not escaped, JSON export returns empty values for CLOB columns exceeding 20MB, and JSON exports show only one file even when more records exist in the database.

Resolution:

Data transfer export now generates valid CSV output with escaped special characters, supports CLOB data in JSON format, and correctly reports the number of exported files.

38372949

3-41609968491

POL-17678

Column Headers are wrapped in widgets, lookup dialog etc

Description:

Headers are getting wrapped to fit in the size in components like widgets, lookup pop-up

Resolution:

Column Headers are now, not wrapped in widgets, lookup dialog etc

Issues that were backported in previous Release / Patch

No backports.