Release Notes for Oracle Health Insurance Product Definition Patch 4.25.1.0.2

This document contains the release notes for Oracle Health Insurance Product Definition Patch 4.25.1.0.2.

Version compatibility: Oracle Health Insurance Product Definition Release 4.25.1.x is only compatible with other Oracle Health Insurance applications release version 4.25.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

NXT-31023

Search Result Download in CSV Format

This enhancement addresses the issue of referenced fields being downloaded in one column as JSON data in the CSV exports from UI. With this enhancement all the displayed data of a reference field will be downloaded into separate columns.

POL-17575

Reset a value using floorplan conditions

With this enhancement, a new optional floorplan property resetValue is introduced, which can be used within the condition block to reset the value for a field.

Documentation Links:
Developer Guide - JET User Interface - References - Components - Condition

PRD-4835

After adding service definition to product, pages gets auto refreshed

This enhancement will allow auto refresh once service definitions are added for the product.

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 of ohi_install.cfg.template and name it ohi_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:
1. Open a command window and browse to <OHI_ROOT>/util/install.
2. 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

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

This section intentionally left blank.

Breaking Changes

This section intentionally left blank.

Access Restrictions

This section intentionally left blank.

Bug Fixes

BugDB

SR

Internal

Summary

37818412

PRD-4898

Quick search value on Service definition page is shown in quick search section of update location type dialog

Description:

Quick search value specified on service definition page is also shown in update location type dialog

Resolution:

Quick search criteria on page level is not persisted in dialogs. Now dialogs display expected data without prior search criteria.

37257709

3-38637505211

PRD-4685

Query API does not return correct results when the search criteria contains an apostrophe

Description:

Query API does not return correct results when the search criteria contains an apostrophe.

Resolution:

The grammar definition for parser is changed such that it’ll escape apostrophe in strings and sql package is changed such that it’ll treat apostrophe as a part of the string/name. UI also handles apostrophe in search input and returns expected results. When configuring filter, prefilter, prefilterList, widget query etc users must manually escape apostrophes in the value of the query expression by using another.apostrophe.

38194091

3-41483288351

PRD-5039

While configuring a product, the maximum limit of parameter alias allowed is 200

Description:

After adding 200 parameter alias for the limits (configured as accumulation options) in the product, when user tries to access cost sharing details, the page freezes and does not load once 201st parameter alias is added

Resolution:

The cost sharing tab loads all the parameter values successfully when more than 200 parameteraliases are configured for a product

38309309

PRD-5074

Add error handling for duplicate columns in base view generation

Description:

Throw a clear and descriptive error message when duplicate columns are detected in views during base view generation. Currently, if a table has duplicate columns in its view, the base view generation fails silently without any error message, causing confusion and making it difficult to identify the root cause.

Resolution:

Added a duplicate columns check in base view generation process and throwing descriptive error message to user.

38350853

PRD-5093

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.

37971998

PRD-4992

Specific Networks: unable to add multiple specific networks

Description:

When user tries to add multiple specific networks, new row is not added instead the existing row is cleared

Resolution:

It is now possible to add multiple specific networks in product service definitions table

37972041

PRD-4994

Specific Network: Getting error after removing all specific networks and save

Description:

When user tries to remove specific network and its usage from product service definitions, error is displayed and record is not saved

Resolution:

Error is not shown while saving a record after removing specific networks in Products page

37975413

PRD-4995

Updated values are not loading after performing Add default service definition, user has to click on blank quick search to see updated records

Description:

After performing the "Add Service definition to Product" operation, the updated records should show. It is not auto refreshed, user has to manually refresh to see the value

Resolution:

Records are shown soon after "Add Service definition to Product" operation

38442093

PRD-5119

Regimes are not reflecting in the benefit specificstions page

Description:

Benefit Specification Page - 'Regime', 'Modifiers' and 'Specialties' column are not displaying any value, even for the benefit specs that have these fields configured.

Resolution:

Regimes, Modifiers and Specialties are now displayed in the page

38352077

PRD-5095

Duplicate entries in OHI_TABLE_COLUMNS

Description:

The table OHI_TABLE_COLUMNS keeps track of database columns which are marked as PII, but also if a column is subject to diacritics search options. Currently there are duplicate entries. As a result, when generating base views the system could throw a Null Pointer Exception.

Resolution:

The duplicate entries as merged into a single entry with PII on subtype 'PERS' and diacritic search enabled. A similar action is taken on the duplicate DATA_FILE entry from the Data Files table.

Issues that were backported in previous Release / Patch

No backports.