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.

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

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.

Documentation Links:
Administration Guide - Accessing PHI Logs in Oracle Health Insurance Cloud Services (OHI CS)
Developer Guide - Base Views Access Restrictions

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.

Documentation Links:
Developer Guide - Data Transfer Integration Point - Response
Developer Guide - Data Transfer Integration Point - Response File Format
Developer Guide - Operational Reporting Integration Point - Error Messages
Developer Guide - Data Transfer Integration Point - CSV

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.

Documentation Links:
Developer Guide - JET User Interface - Floor Plan Templates - View and Edit Object - List
Developer Guide - JET User Interface - References - Components - Table

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.

Documentation Links:
Installation Guide - Application Properties

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.

Documentation Links:
Developer Guide - JET User Interface - References - Components - Quick Search

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.

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

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

Additional Upgrade Steps for Installation

The following phases are defined:

pre-upgrade: Application is still running.
pre-undeploy: Application is stopped, but not undeployed.
post-undeploy: Application is undeployed. Database is backed up.
post-upgrade: Released upgrade script run is complete.
post-deploy: New application is deployed, and is up and running.

Post-Upgrade phase

A new MDC (Mapped Diagnostic Context) field, user, has been introduced for security logs. To ensure this information appears in the security log file, update the log pattern for the securityAppender (which uses RollingFileAppender) to include the user MDC field.
```
Example updated pattern:
```
```
<appender name="securityAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
    <encoder>
        <pattern>%d{ISO8601} [ %t ] %marker %c - %m [user:%X{user:-N/A}] %n</pattern>
    </encoder>
    ...
</appender>
```

Create a new securityDBAppender in SaaS deployments. This appender enables writing security logs to the database.

Example Logback configuration:

<configuration debug="true" scan="true" scanPeriod="60 seconds">
  ...
  <appender name="securityDBAppender"
            class="com.oracle.healthinsurance.loggingsupport.appender.impl.OhiSecurityLoggerAppender">
    <connectionSource class="ch.qos.Logback.core.db.JNDIConnectionSource">
      <jndiLocation>jdbc/policiesUserOhiApplicationDS</jndiLocation>
    </connectionSource>
    <logType>security</logType>
    <bufferDir>/writable/log/storage/buffer/security</bufferDir>
  </appender>
  ...
  <root level="error">
    ...
    <appender-ref ref="securityDBAppender"/>
  </root>
</configuration>

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.

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

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}`

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}