Release Notes for Oracle Insurance Gateway Patch 4.25.1.0.4

This document contains the release notes for Oracle Insurance Gateway Patch 4.25.1.0.4.

Version compatibility: Oracle Insurance Gateway 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

CPN-3641

Enhanced PHI logs access using base views

In SaaS deployments, PHI access logs are stored in the database for 60 days in the PHI_LOG_EVENTS table. Logs older than 60 days are moved to OCI Object Storage by a daily database scheduler job. Prior to this release, customers could query recent logs (≤ 60 days) using the logphievents generic API, but accessing older logs required raising an SR with the AMS team to retrieve files from OCI Object Storage.

This enhancement improves the customer experience by enabling PHI access logs to be extracted directly through base view generation. The PHI_LOG_EVENTS table is now included in base view generation, allowing customers to schedule a daily extract of the PHI_LOG_EVENTS_BV base view and load the extracted data into their own data warehouse for analysis and reporting.

An access restriction is created for PHI_LOG_EVENTS_BV, but it is not automatically granted to the ALL_VIEW_ACCESS_ROLE.

CPN-3799

Operational Reports and Data Transfer

The following changes are made in Operational Reports and Data Transfer:

  • In the previous release, the CSV files generated by the Data Transfer IP did not include a header row. In this release, CSV files include the header.

  • In the previous release, when a query returned no records, the Data Transfer IP responded with HTTP 200 with an empty response body. This behavior is changed to return HTTP 204 (No Content).

  • Two new error messages are introduced in the Operational Reporting IP. The IP returns an HTTP 422 response with one of the following error messages:

    • OHI-IP-ORV-008: View {0} does not exist

    • OHI-IP-ORV-009: Access restriction grant is missing to query the view {0}

  • The following issues specific to On-Prem deployments are fixed:

    • Incomplete or truncated responses when querying very large data.

NXT-32524

Table component improvements - Usability with editable row

Introduced check (Apply) icon as a table row-level action in edit mode. Clicking the check icon returns the row from edit mode to view mode. Actions in other rows will be disabled until the user clicks on the check icon of the current row being edited. Editable row remains in edit mode and persists the data when the user clicks outside the table or switches to another browser tab.

NXT-32617

UI: Ability to exclude trailing wildcard with like search

This enhancement allows excluding the automatic inclusion of the trailing wildcard for like search in quick search, advanced search, and lookups by setting the application property ohi.ui.likesearch.wildcard.enabled to false.

The system also auto-truncates the leading and trailing white space for searches.

NXT-32621

UI: Additional Features Quick Search

With this enhancement, the quick search component is extended, and it will be possible:

  • To include all types of fields in the quick search.

  • To have query operators like between, less than, greater than, etc, configurable in quick search.

  • To set specific search criteria flagged as mandatory.

NXT-32629

UI: Expandable "more" section in tables

With this enhancement, the overflow region for the table ("More" link) is now expandable to a two-column layout, allowing more information to be viewed at once.

Configuration Properties

Ref Action Description

NXT-32617

Added

ohi.ui.likesearch.wildcard.enabled

This property enables or disables the trailing '%' sign from quick, advanced search, and lookup (LOV) with the query operators like and likeic.

Web Services

Ref Action Description

CPN-3799

Modified

Data Transfer IP

  • CSV files generated by the Data Transfer IP includes the header.

  • When the query returned no records, the Data Transfer IP responds with HTTP 204 (No Content).

CPN-3799

Modified

Operational Reporting IP

Two new error messages are introduced in the Operational Reporting IP. The IP returns an HTTP 422 response with one of the following error messages:

  • OHI-IP-ORV-008: View {0} does not exist

  • OHI-IP-ORV-009: Access restriction grant is missing to query the view {0}

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

38575973

OIG-4689

Zip and Unzip operations in Data File Sets IP return HTTP 405 in SaaS

Description:

The Zip and Unzip operations in Data File Sets IP return HTTP 405 (Method Not Allowed) in SaaS. Also, UploadToUCM step fails with database error ORA-06512 in SaaS.

Resolution:

Zip and Unzip operations are now supported in the Data File Sets IP in SaaS. Also, UploadToUCM step now runs successfully and no longer fails with database error in SaaS.

38683690

OIG-4777

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. For SaaS customers, exporting columns of type CLOB in CSV or JSON format is currently not supported due to a known issue in the DBMS_CLOUD package. This limitation is tracked under Oracle Bug 38183169.

38761785

OIG-4830

Recovery of exchange failed or timed out on CheckDataTransferStatus step leads to out of memory scenario

Description:

When an exchange that failed or timed out on CheckDataTransferStatus step is recovered, the exchange gets stuck processing that step. This later leads to system running out of memory and errors are seen in application logs.

Resolution:

Recovering an exchange in the CheckDataTransferStatus step starts processing the exchange properly without getting stuck in that step or running out of memory.

38669224

3-42706054381

OIG-4773

Recovery of failed or timed out ReceiveNotification step is unsuccessful if event store is used as error destination

Description:

If an OIG exchange fails or times out in the ReceiveNotification step and event store is used as error destination, an event is created by the error workflow. However, the location header present in exchange properties used for checking the external activity status gets overwritten with the URI of the created event. When the exchange is recovered, it is unsuccessful with a HTTP 401 Unauthorized error.

Resolution:

When an OIG exchange fails or times out in the ReceiveNotification step and event store is used as error destination, an event is created by the error workflow but it no longer overwrites the location header in exchange properties. As a result, recovery of exchange is successful, processing the exchange from the failed or timed out step.

38655769

3-42551002131

OIG-4763

OHI Agent fails to read the property file

Description:

OHI Agent fails to read the properties file (application.properties) if the file is present in the same folder as OHI Agent. As a result, OHI Agent fails to start if the file is present in the same folder, also referred to as AGENT_HOME.

Resolution:

OHI Agent starts successfully after reading the properties file (application.properties) when the file is present in the same folder as OHI Agent.

Issues that were backported in previous Release / Patch

No backports.