Release Notes for Oracle Insurance Gateway Release 3.22.1.0.0

This document contains the release notes for Oracle Insurance Gateway Release 3.22.1.0.0.

Version compatibility: Oracle Insurance Gateway Release 3.22.1.x is only compatible with other Oracle Health Insurance applications release version 3.22.1.x unless explicitly stated otherwise.
OHI applications expose the technical ID (created by sequence generator) in HTTP API and IP. This might be changed to an alternate technical ID (the data type might not be an integer) in a future release. Hence, it is advised to follow the generated HATEOAS links instead of hard-coding/bookmarking the IDs in the external integrations.
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 Description Included in Patch

AUT-2077

New User Provisioning Features

This enhancement

  • Introduces a new auditing table User Role History

  • Makes it possible to remove a user even after the user has logged in

  • Introduces a new access restriction type 'User Credentials Acl Type(USRCRD)' for accessing user credentials

  • Updates the generic HTTP API and provisioning integration point to provide access to the new auditing information

NXT-20382

New Advanced Search Features

This enhancement introduces the ability to do between, less than and greater than searches on dates, number, and amount fields, in the advanced search.

NXT-20655

Invalidate and re-populate non-entity cache

The application keeps non-entity caches for extensibility configuration. In some scenarios it is possible for the cached content and the database to be out of sync. This situation can be resolved by restarting the server.

This enhancement introduces new web service that provides an alternative to restarting the server. Calling this web service clears the non-entity cache.

NXT-21416

Use Vault as alternative secrets store with WebLogic deployments

Next to Fusion Middleware / WebLogic Oracle Platform Security Services (OPSS), OHI applications also support HashiCorp Vault as alternative secrets store. See the Installation Guide for details.

3.21.3.0.4

NXT-22299

RestClient Connection Pool

This enhancement introduces a REST client connection pool. Any application invoking REST calls now consume the connections from a shared connection pool, instead of creating a new connection every time. The parameters for using connection pool, e.g. Number of connections, etc, are configurable.

NXT-22573

Conditional Display of Fields in Lists and Tabs

This enhancement introduces the ability to control the display of fields within a row in a table and multi-value list within the form region.

NXT-22658

Overview of External End-Points

This enhancement introduces a new integration point that generates an overview of all defined end-points to which the application sends messages.

NXT-22766

Show Loading Icon for Page Navigation

This enhancement introduces the display of the loading icon when a user navigates the menu. This provides the user with a visual cue that the application is in the process of loading the page.

NXT-23006

The TaskProcessingResource exposes the current AQ queue depth

This allows customers to monitor the backlog of work stored in the queue.

NXT-23097

JavaScript Extension Toolkit Upgrade

This release includes an upgrade of the JavaScript Extension Toolkit (JET) technology. In addition to several non-functional improvements, this upgrade also further improves to the look and feel of the application.

NXT-23098

Infinite Scrolling on Search Pages

This enhancement introduces infinite scrolling on search pages, i.e., new search results are fetched every time the user scrolls down further. This enhancement replaces the pagination of search results.

NXT-23507

Improved Login Page

This enhancement aligns the look and feel of the Login page with Oracle’s latest standard

NXT-23648

Application Owner Schema Change

The privilege SELECT ON SYS.V_$PARAMETER is no longer required in the application and is removed from the installer. This change impacts only fresh installations.

3.21.3.0.3

NXT-24203

New Integration Point to Retrieve Configuration Migration Sets

This enhancement introduces a new integration point that retrieves the list of available configuration migration sets from a specific source environment. This service enables the UI page that shows inbound data sets to include configuration migration data sets on other environments.

OIG-1728

CorrelationId is expanded to contain exchangeStepId

CorrelationId is used to resolve exchange from notification and update the status of exchange and exchange step. However, if there are multiple long-running operations in the same exchange, and multiple notifications are coming back, then the notifications are mismatched with the long-running operations. This is because correlationId in notification contains only exchangeId, but no indication of which step the notification is for.

Now, to resolve this mismatch, the correlationId will include both exchangeId and exchangeStepId, instead of only the exchangeId. Format of correlationId will be <exchangeId>-<exchangeStepId>

OIG-1952

Remove Data Files for completed Exchanges

This enhancement adds the capability to remove Data Files for completed Exchanges in order to save disk space. A new optional configuration field 'Remove Data Files After Completion?' is added to the Integration. When enabled, all Data Files for Exchanges of this Integration are removed after the Exchange completes. Field 'Files Deleted Date' on the Exchange shows when the Data Files for the Exchange were removed. Technically, the CLOB column of relevant Data Files is emptied. The Data File Sets and child Data File records remain intact. The feature is backward compatible, i.e. for the configuration field 'Remove Data Files After Completion?' a 'null' value is considered 'No'.

OIG-2184

Australian Localization AS2805_A and AS2805_B interfaces store the updated value for Provider Reference

The AS2805_A interface updated to map claim.providerReference to : value of "ohi.as2805_a.provider.reference.prefix" property + incomingMessage.RRN + incomingMessage.terminalID + incomingMessage.terminalLocalDate + incomingMessage.terminalLocalTime for the below operations: 1) Cancel 2) Transaction Reversal and Transaction Reversal Repeat 3) Cancellation Reversal and Cancellation Reversal Repeat

The AS2805_B interface updated to map claim.providerReference to : value of "ohi.as2805_b.provider.reference.prefix" property + incomingMessage.RRN + incomingMessage.terminalID + incomingMessage.terminalLocalDate + incomingMessage.terminalLocalTime for the below operations: 1) Cancel 2) Void 3) Auto Void

3.21.3.0.3

OIG-2218

Reduce the number of REST clients

With this enhancement, the rest-client ID used for rest destination will be the destination code instead of the <integration_code>-<integration-step-code> leading to more optimal use of costly rest-client objects.

3.21.3.0.4

OIG-2273

Control polling interval for blocking Exchange

To provide a synchronous/blocking experience for a client, the system utilizes a polling scheme to check the exchange’s progress. As part of this change, an integration specific property is introduced, which once set, will serve as the polling interval. This provides more control to adjust the property as and when required for any integration.

By default ( if property not set ) and minimum polling interval is 1000 ms.

OIG-2477

JSON re-indexing package for OIG

A new Package OIG_TEXT_INDEX_MAINTENANCE_PKG has been introduced for creating the oracle text index OIG_EXCHANGE_IDX1 on OIG_EXCHANGE table in Oracle 19c format with Sync frequency option. This needs to be executed as explained in the Post-upgrade stage.

3.21.3.0.6, 3.21.3.0.7

OIG-2497

Audience in tokenstore Key

Australian Eclipse Integration: extended the Eclipse token store.

POL-10220

User Interface Improvements

This enhancement introduces the following features the create policy page to improve operational agility of the end-user:

  • The ability to auto-populate start dates

  • The ability to make native multi-value fields appear and behave as single value fields

  • The ability to copy an record in creation mode

POL-5071

New Pages for Data Exchanges

This enhancement introduces new user interface pages for inbound and outbound file exchanges.

POL-5073

New pages: Members and Membership

This enhancement introduces:

  • A new member page

  • A new floor plan template

  • A new color (orange) that can be selected for labels

  • The ability to configure address formats

  • The ability to add filter to a multivalue list

POL-7230

Dynamic Logic Test Integration Point

This enhancement introduces a new integration point that enables dynamic logic unit tests within the application, without having to invoke the entire core process to trigger an invocation of the logic.

POL-9190

Immediate Primary Date Format Changes

This enhancement introduces the ability to change the primary date format on the default country without having to restart the server to effectuate the change.

POL-9288

Improved Look and Feel

This enhancement introduces several small changes to menus and alignments to improve the overall look and feel of the application.

POL-9798

New Features Quick Search and Advanced Search

A new mode is added to the quick search component - AND mode. This mode allows specifying values specific to the search criterion.

In addition, for quick and advanced search, at the property level, it is possible to configure "like", "likeic" or "eq" as queryOperator. It is also possible to configure if the value should be converted to uppercase or not.

POL-9955

Light Deployment (without ADF, with Vault)

This enhancement introduces an alternative, light deployment EAR file, in addition to the standard EAR. This new light EAR file deploys on Weblogic slim middleware and is placed under the lightApplication directory of the release zip. This deployment do not use Oracle Platform Security Services (OPSS) and does not support ADF pages.

Upgrade Steps for Installation

To perform the upgrade, perform the following steps:

  1. Perform any pre-upgrade steps.

  2. Stop all the managed nodes running the .existing version of the application.

  3. Perform any pre-undeploy steps.

  4. Undeploy the existing version of the application.

  5. Back up the database.

  6. Perform any post-undeploy steps.

  7. Unpack the release bundle into a directory that we refer to as OHI_ROOT from now on.

  8. Change Installation Configuration: In <OHI_ROOT>/util/install, make a copy of ohi_install.cfg.template and name it ohi_install.cfg.

  9. Edit ohi_install.cfg to contain your specific database connection data and other configuration settings. The settings are explained in the file itself.

  10. Make sure NO connections are present to the database using the OHI_xxx_USER account (where xxx is the abbreviation of the application)

  11. 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 .

  12. Make the required changes to the ohi properties file

  13. Perform any post-upgrade steps

  14. Start WebLogic application server

  15. Deploy the Application

  16. Perform any post-deploy steps

Additional Upgrade Steps for Installation

The following phases are defined:

  1. pre-upgrade: Application is still running

  2. pre-undeploy: Application is stopped, but not undeployed.

  3. post-undeploy: Application is undeployed. Database is backed up

  4. post-upgrade: Released upgrade script has run.

  5. post-deploy: New application is deployed and is up and running.

Stage: pre-upgrade

Action: execute the following query to find future duplicates

select usrs.login_name
,      dupes.alias
from   ohi_users usrs
,      ohi_user_preferences uspr
,      (select uspr_id
        ,      alias
        from   ohi_bookmarks
        group  by uspr_id
        ,      alias
        having count(*) > 1
       ) dupes
where  uspr.id = dupes.uspr_id
and    usrs.id = uspr.usrs_id

This query lists bookmark aliases per user that have more than one occurrence and will violate the new unique constraint. Update the alias of the violations such that there are no more duplicates

Stage: post-undeploy

1) Action: Apply mandatory WebLogic patches

The following are the mandatory (minimal required) patches. Please apply them in the order listed below:

  • 33416868: WLS PATCH SET UPDATE 12.2.1.4.210930 (OCT 2021 PSU)

  • 32211968: ECLIPSELINK - ALL VERSIONS - GOES INTO DEAD LOCK DOING OBJECT BUILDING

After applying the above patch(es), if the managed server fails to start due to coherence errors, please follow the solution described in Doc ID 2634266.1

2) The following steps are to be performed before running the upgrade script:

Action: Privilege changes to SYSTEM user, the below commands should be executed as SYSDBA:

GRANT SELECT ON sys.gv_$aq TO system WITH GRANT OPTION;
REVOKE SELECT ON sys.v_$parameter FROM system;
REVOKE EXECUTE ON sys.dbms_system FROM system;

Action: Privilege changes to USER schema, below command should be executed as SYSTEM user

GRANT SELECT ON sys.gv_$aq TO OHI_OIG_USER;

Action: Privilege changes to OWNER schema, below commands should be executed as SYSTEM user

GRANT CREATE TRIGGER TO OHI_OIG_OWNER;

3) Please execute the SQL statement with the user: OHI_OIG_OWNER. This SQL is to fix the known issue of custom floorplans getting overridden by OHI floorplans with same ID.

begin
   execute immediate 'alter table ohi_floor_plans_tl disable constraint ohi_floor_plan_tl_fk1';
   for rec in (
       select
           id
       from
           ohi_floor_plans_b
       where
           id in ( 15121 )
           and ind_system = 'N'
   ) loop
       update ohi_floor_plans_b
       set
           id = ohi_floor_plan_s1.nextval
       where
           id = rec.id;

       update ohi_floor_plans_tl
       set
           base_table_id = ohi_floor_plan_s1.currval
       where
           base_table_id = rec.id;

   end loop;

   execute immediate 'alter table ohi_floor_plans_tl enable constraint ohi_floor_plan_tl_fk1';
   commit;
end;
/

Stage: post-upgrade

A new oig_text_index_maintenance_pkg has been provided as part of the patch. Post upgrade of the patch login as ohi_oig_owner and execute the below command to recreate the index.

begin
  oig_text_index_maintenance_pkg.create_index (15);
end;
/

Configuration Properties

Ref Action Subject Description

NXT-21416

Added

ohi.vault.clientpem.url

Resource URL to Vault Client pem

NXT-21416

Added

ohi.vault.clientkeypem.url

Resource URL to Vault Client Key pem

NXT-21416

Added

ohi.vault.pem.url

Resource URL to Vault pem

NXT-21416

Added

ohi.vault.token

Vault token

NXT-21416

Added

ohi.secure.secrets.store

The type of store the OHI application uses for secrets

NXT-21416

Added

ohi.vault.address

Vault address. Must use HTTPS

NXT-21416

Added

ohi.vault.environment.identifier

To distinguish secrets on a per OHI application instance basis

NXT-21416

Added

ohi.vault.kv.secrets.engine

By default, OHI applications assume that Vault’s Key-Value secrets engine is enabled at root path "secret"

NXT-21416

Added

ohi.vault.namespace

OHI specific Vault namespace section, under the path determined by properties ohi.vault.kv.secrets.engine/ohi.vault.namespace to look for secrets

NXT-22299

Added

ohi.service.{0}.client.pool.timeout.connection

The max time, in milliseconds, a connection can take to connect to destinations. A value of 0 means never timeout. This property is specific to clientId {0}. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.client.response.content.maxsize

Maximum allowed response content size in MegaBytes (MB).

NXT-22299

Added

ohi.service.{0}.client.pool.timeout.idle

The max time, in milliseconds, a connection can be idle. This property is specific to client {0}. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.{0}.client.pool.timeout.addressresolution

The max time, in milliseconds, to resolve the host address. This property is specific to client {0}. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.{0}.client.pool.destination.maxqueued

The maximum number of connections in the pool allowed to be queued per destination for client {0}. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.{0}.client.pool.destination.maxconnections

The maximum number of connections in the pool per destination for client {0}. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.client.pool.timeout.connection

The time in milliseconds before the attempt to connect to an outbound service times out. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.client.pool.timeout.idle

The max time, in milliseconds, a connection can be idle. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.client.pool.timeout.addressresolution

The max time, in milliseconds, to resolve the host address. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.client.pool.destination.maxconnections

The maximum number of connections in the pool per destination. Effective immediately for non-cached clients

NXT-22299

Added

ohi.service.client.pool.destination.maxqueued

The maximum number of connections in the pool allowed to be queued per destination. Effective immediately for non-cached clients.

NXT-22299

Added

ohi.service.client.pool.active

Enable or disable to leverage connection pool functionality

OIG-2184

Added

ohi.as2805_a.provider.reference.prefix

Mandatory property to define the prefix to create the claim provider reference for AS2805_A messages. If the provider reference exceeds the allowed limit of 250 characters the starting characters of the property value will be used thereby limiting the provider reference to the max allowed limit.

OIG-2184

Added

ohi.as2805_b.provider.reference.prefix

Mandatory property to define the prefix to create the claim provider reference for AS2805_B messages. If the provider reference exceeds the allowed limit of 250 characters the starting characters of the property value will be used thereby limiting the provider reference to the max allowed limit.

OIG-2243

Added

ohi.ui.httplink.{0}

This property is used for defining the address of the http link. {0} represents a custom identifier that can be specified to provide more context to the http link configuration.

OIG-2367

Added

ohi.eclipselink.concurrency.manager.waittime

A value larger than 0 (milliseconds) enables internal persistence deadlock detection and related extended logging; effectively driving org.eclipse.persistence.internal.helper.ConcurrencyManager. This is an optional property. Default value is 1 millisecond.

OIG-2367

Added

ohi.eclipselink.concurrency.manager.maxsleeptime

Related to ohi.eclipselink.concurrency.manager.waittime. Controls the time interval (in milliseconds) for the system to throw an exception after a deadlock was detected. This is an optional property. Default value is 40000 milliseconds.

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.subject.id.type

The "dhs-subjectIdType" value represents class of the subject(type) while retrieving token. (DEFAULT VALUE : "Fund Location Id"

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.subject.id

The "dhs-subjectId" value represents class of subject user(id) specified while pinging agency. (DEFAULT VALUE :WEB00001)

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.product.id

The "dhs-productId" value represents the latest application version used to submit the "Web Service Request". (DEFAULT VALUE : "ECLIPSE API V1.0")

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.location.id

The "dhs-locationId" value represents the class of the location(id) while the retrieving token also used in the dhs-correlationId. (DEFAULT ID : "WEB00001")

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.ibm.client.id

The value represents x-ibm-client-id used while pinging agency. (DEFAULT VALUE : "http://humanservices.gov.au/PRODA/org" )

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.audit.id.type

The "dhs-auditIdType" value represents the class of audit user specified. If supplied will always be Location Id. (DEFAULT VALUE : "Location Id"

OIG-2391

Added

ohi.integration.australia.eclipse.ping.header.audit.id

The "dhs-auditId" value is the unique Location Id (Minor ID) for the source agency who is sending the "Web Service Request" while pinging agency. (DEFAULT VALUE : WEB00001)

OIG-2464

Removed

ohi.datasetoperations.notification.common.structure

The property ohi.datasetoperations.notification.common.structure is removed. From this release onwards, the notification will be sent only in the new/common format.

POL-5073

Added

ohi.jsui.formatted.address.organization

Added a new property to show formatted address for organizations resource

POL-5073

Added

ohi.jsui.formatted.address.person

Added a new property to show formatted address for persons resource

Web Services

Ref Action Subject Description

NXT-20655

Added

Non-Entity Cache Integration Point

'/api/nonentitycache/invalidateall' IP invalidates all the non entity caches. It supports POST HTTP request. Successful response returned by this IP is 204.

NXT-22658

Added

Outbound Integration Point

A new IP that shows all the outbound integration points and their endpoints

NXT-23006

Modified

Control Task Processing

The existing status response is extended with information about the number of items in the task processing queue

NXT-24203

Added

Fetch Available Datasets Integration Point

'api/dataexchange/datasets/fetchavailabledatasets/<dataSetDefinitionCode>/<dataSetVersion>' IP fetches all the datasets from the configured source environments. It supports GET HTTP request. Successful response returned by this IP is 200.

OIG-1952

Modified

exchange API

Added attribute filesDeletedDate

OIG-1952

Modified

integration API

Added attribute removeFilesOnCompletion

POL-7230

Added

Test Dynamic Logic Integration Point

New Integration Point

Data Conversion

This section intentionally left blank.

Dynamic Logic

Ref Action Subject Description

POL-7230

Added

Test Unit

New signature

UI Changes

Ref Action Subject Description

NXT-20382

Added

queryOperator : bet / lt / gte

queryOperator property is supported on dates, number, and amount fields while configuring floorplan for advanced search

NXT-22766

Added

JET Pages

Loading Indication would be shown on navigating to any other pages

NXT-23097

Added

JavaScript Extension Toolkit Upgrade

OHI is upgraded to new JET version

NXT-23507

Modified

Login Page

New look and feel for the Login page

OIG-1952

Modified

Integration Page

Attribute 'Remove Data Files After Completion?' added

POL-10220

Modified

JET policies page

Create policy page improvements

POL-5071

Added

FN0041 Outbound Exchange

User can use this page to export different data set from one application to another.

POL-5071

Added

FN0040 Inbound Exchange

User can use this page to import different data set from one application to another.

POL-5071

Modified

FN0056 Configuration Migration Sets

Build and Download action to Configuration Migration Sets Page

POL-5073

Added

Membership

Contains foldout of person details and policy details such as policy enrollment list and policy enrolled products.

POL-9288

Modified

Menu CSS improvement

CSS changes made on menu

POL-9288

Modified

All pages

Modified tab bar

POL-9798

Modified

Quick Search and Advanced Search Component

toUppercase can be configure as 'true' or 'false' at property level to convert the search value to uppercase or not.

POL-9798

Modified

Quick Search Component

New mode 'AND' is added in Quick Search Component, which allows specifying values specific to the search criterion.

POL-9798

Modified

Quick Search and Advanced Search Component

Possible to add 'like', 'likeic' and 'eq' as queryOperator in Quick and Advanced Search Component.

Deprecated items (to be removed in future release)

This section intentionally left blank.

Breaking Changes

Ref Action Subject Description

OIG-2218

Modified

OAuth Rest Client Configuration

For an OAuth configuration defined using api/generic/oauthclientcredentialsgrantconfigurations API, the rest client Id should be replaced with the destination code instead of <integration_code>-<integration-step-code>.

OIG-2218

Modified

Eclipse Integrations for Sending Outbound Requests to the Agency

For Eclipse integration containing rest destination with PRODA as the authentication feature the audience defined using ohi.integration.australia.eclipse.service.provider.<REST Client ID>.audience and service provider defined using ohi.integration.australia.eclipse.service.provider.<REST Client ID> should be modified to use destination code as the rest client Id.

OIG-2273

Added

ohi.exchange.await.poll.frequency.<integration_code>

Polling interval specific to an integration code. Default and minimum value of 1000 ms.

OIG-2273

Removed

ohi.exchange.await.poll.divider

A value with which the maximum blocking timeout is divided for polling interval.

OIG-2273

Removed

ohi.exchange.await.poll.factor

A percentage factor to add to the calculated polling interval.

OIG-2391

Modified

ohi.integration.australia.eclipse.header.subject.id.type

This property has been renamed to ohi.integration.australia.eclipse.token.header.subject.id.type

OIG-2391

Modified

ohi.integration.australia.eclipse.header.audit.id.type

This property has been renamed to ohi.integration.australia.eclipse.token.header.audit.id.type

OIG-2464

Removed

ohi.datasetoperations.notification.common.structure

The property ohi.datasetoperations.notification.common.structure is removed. From this release onwards, the notification will be sent only in the new/common format.

Bug Fixes

BugDB SR Internal BP Summary

31523984

OIG-1284

Search Exchanges: pagination is not working properly

Description:

Search Exchanges: pagination is not working properly.

  1. When filtered the search results based on certain conditions.

  2. When changed the search results count from the default(10 rows), it is displaying as the text area.

  3. After applying the filter conditions, pagination is not displayed.

Resolution:

With the new release, paging control has been removed.

33208065

OIG-2144

Change AS2805 response if Health Fund system is not available

Description:

If OIG to OHI communication is not happening due to system issues or due to error(e.g. use of wrong credentials for the destination), the AS2805_A and AS2805_B response code was set as 00 Approved.

Resolution:

If OIG to OHI communication is not happening, due to system issues or due to error, the AS2805_A and AS2805_B response code will be 91 Health Fund Down and 93 System problem respectively.

33427486

OIG-2233

Unsaved Changes Popup Handler Inconsistency

Description:

Unsaved Changes Popup Handler Inconsistency is coming across custom pages.

Resolution:

Pop up works as expected.

33432110

OIG-2234

Generated change logs are incomplete when cmt import payload contains different subtypes of an entity

Description:

When a CMT import with audit trail enabled is done and below conditions are true , then the generated audit trail change log is incomplete

  1. There are different subtypes exists for an entity. For example - IntegrationSteps can have TransformStep and ActivityStep.

  2. They are mapped to the same table.

  3. In the CMT import payload, there are updates on more than one subtype for the same entity. For example - TransformStep is removed and ActivityStep is added.

Resolution:

Generated change logs are complete when there are updates on more than one subtype for the same entity

33454164

OIG-2237

Missing navigation menu on application landing page

Description:

Missing navigation menu on application landing page.

Resolution:

Fixed the error encountered while displaying bookmarks, as the component was being initialized only during basic authentication. It was impacting the whole navigation menu. Now all the navigation menu shows up with all supported authentication mechanisms.

33458812

OIG-2240

QueryAPI with EQ operator returning 204 response when value has leading zeros

Description:

QueryAPI with EQ operator returns 204 response when the field value has leading zeros. It works fine with LIKE operator

Resolution:

QueryAPI with EQ operator returns expected response when the field value has leading zeros.

33460400

OIG-2243

Add a new system property that updates immediately without restart

Description:

Add a new system property ohi.ui.httplink.{0} which is effective immediately on update and does not require restart.

Resolution:

Added a new system property ohi.ui.httplink.{0} where ChangeEffective is set to Immediate.

33485514

OIG-2253

ECLIPSE: if retrieving a token fails the cause cannot be determined

Description:

If retrieving a token for ECLIPSE services results in an unexpected response then the system does not log the response payload. That makes it hard to determine the root cause.

Resolution:

The system logs the response payload for non-HTTP 2xx responses to assist in determining the action that needs to be taken.

33514900

OIG-2264

CMT import stops when a Dynamic Logic contains regexp character(s) fails

Description:

When import of dynamic logic containing regexp character(s) fails (for example if the dynamic logic referenced in that dynamic logic could not be found), then CMT stops importing any other entities and the result is shown as success.

Resolution:

CMT import is shown as failure when import of dynamic logic with regexp character(s) fails. And all the other entities are imported.

33551661

OIG-2282

Boilerplate texts are not loading for some of the timestamp formats.

Description:

Boilerplate texts were not loading when provided timestamp was in different formats.

Resolution:

Fix was made to load boilerplate texts for different timestamp formats.

33607989

OIG-2323

'Created on' and 'Updated on' date displays incorrect format in configuration migration sets screen.

Description:

In JET Screens, date is formatted according to the primary date format of the default country. If the primary date format is not specified for the default country, then the system shows an incorrect date format. instead of showing the system default as 'DD-MM-YYYY'.

Resolution:

System default date format 'DD-MM-YYYY' is applied when the primary date format is not specified.

33621644

OIG-2329

Query on generic API with a condition on child list and order by nulls first returns an error message

Description:

When making a query on any generic API, when a condition on a child list is made and also an "order by" clause with "nulls first" is added, invalid SQL is formed, so an error is returned, rather than performing the requested query.

Resolution:

The generic API no longer creates invalid SQL and performs the requested query as expected.

33552400

OIG-2339

Removing column URI from OHI_BOOKMARK_UK1

Description:

In 3.21.3.0.0 unique constraint OHI_BOOKMARK_UK1 was created on the combination of user preferences, alias and URI of the bookmark. The URI column should be removed from the constraint.

Resolution:

The attribute URI is removed from the Unique Key on Bookmarks

33665867

OIG-2342

GET on "/keystores" immediately after restarting the system did not always show existing key stores

Description:

In some cases the GET request returned an HTTP 204 No Content response.

Resolution:

Timely cache initialization fixed the issue.

33669801

3-27942896191

OIG-2344

Boilerplate text created for links is not replaced, unless it is referred to in lowercase

Description:

When the user creates a boilerplate text for links and mentions it in links in uppercase, it is not replaced unless it is referred to in lowercase.

Resolution:

Any boilerplates given for links will be replaced in UI irrespective of the casing of letters.

33727930

OIG-2367

CMT export is stuck when deadlock occurs in Eclipselink

Description:

CMT export process is stuck when deadlock occurs in Eclipselink code. This happens, for example when a HTTP-API PATCH operation on a configuration entity is performed while CMT (which includes that configuration entity) export process is running in parallel.

Resolution:

Install the mandatory WebLogic patches 33416868 (WLS PATCH SET UPDATE 12.2.1.4.210930) and 32211968 (ECLIPSELINK - ALL VERSIONS - GOES INTO DEAD LOCK DOING OBJECT BUILDING)

33761812

OIG-2382

Integration Step is not matched on functional key during CMT import

Description:

CMT Import was failing due to integration step was being matched only on UUID.

Resolution:

CMT Integration step would not fail now , as the matching will proceed to functional keys match, if UUID does not match.

33766496

3-27896665871

OIG-2385

Default commit size for Purge Operation improved

Description:

The commit-size of a Purge request can be supplied on the request. However it had a default commit-size of 1, which led to slow processing.

Resolution:

Default commit-size changed to 5000.

33771302

OIG-2391

Ping request fails with unauthorized error

Description:

Ping request to the agency was failing with 401 because of missing headers

Resolution:

Ping request to the agency from PHI should now return successfully activated message

33929200

OIG-2457

Optimistic locking error leading 500 internal server for received notification

Description:

Blocking exchange failed with optimistic locking error when the response of the process and timeout happens almost simultaneously.

Resolution:

The blocking exchange will not fail before retrying in case optimistic locking occurs when the response of the process received and timeout happens almost simultaneously.

33957013

OIG-2472

Integration code if contains the name eclipse then the endpoint /eclipse replace that with empty string leading to no integration in OIG

Description:

The mapping of integration code for the eclipse endpoint in the agent was not proper in case the integration code starts with the term "eclipse", which leads to integration not found error.

Resolution:

The mapping of eclipse endpoint in agent has been modified to handle the scenario in case the integration code starts with eclipse.

34030399

OIG-2503

Data files are purged very slowly when the volume is large

Description:

When purging exchanges with included datafiles, purging of datafiles is very slow (compared to purging exchanges), and it takes a long time to complete.

Resolution:

The purge operation for datafiles is significantly improved.

34031398

OIG-2510

Eclipse software activation response validation doesn’t give detailed reason of the reason of failure

Description:

Eclipse activation response validation didn’t show the reason for failure.

Resolution:

Eclipse activation response validation will show the reason for failure as well

34048420

OIG-2521

CMT does not load as2805 integrations properly

Description:

CMT doesn’t include integration type while exporting and importing

Resolution:

CMT will include integration type while exporting and importing

34066194

3-29171386311

OIG-2524

Subflow creation when payload provided is very large

Description:

Subflow creation step fails when the payload is large

Resolution:

Subflow creation step won’t fail in creation step if the payload size is in limit of defined by CLOB datatype in Oracle 19c

34165404

OIG-2569

Getting a large data file using data file set integration point fails with java.sql.SQLRecoverableException error

Description:

Sending a GET request to the data file set integration point for a large data file (about 1.5 GB) fails with java.sql.SQLRecoverableException

Resolution:

With this bug fix, it is now possible to download a large data file without getting an error

Issues that were backported in previous Release / Patch

BugDB Internal Summary Backport BugDB SR

33460400

OIG-2243

Add a new system property that updates immediately without restart

3.21.3.0.1

33460410

33485514

OIG-2253

ECLIPSE: if retrieving a token fails the cause cannot be determined

3.21.3.0.2

33488044

33485514

OIG-2253

ECLIPSE: if retrieving a token fails the cause cannot be determined

3.21.2.0.6

33488030

33514900

OIG-2264

CMT import stops when a Dynamic Logic contains regexp character(s) fails

3.21.3.0.4

33664455

33551661

OIG-2282

Boilerplate texts are not loading for some of the timestamp formats.

3.21.3.0.4

33587596

33669801

OIG-2344

Boilerplate text created for links is not replaced, unless it is referred to in lowercase

3.21.3.0.5

33679598

33761812

OIG-2382

Integration Step is not matched on functional key during CMT import

3.21.3.0.6

33766471

3-27896665871

33766496

OIG-2385

Default commit size for Purge Operation improved

3.21.3.0.6

33767371

3-27896665871

33771302

OIG-2391

Ping request fails with unauthorized error

3.21.3.0.5

33771525

3-27852590281

33957013

OIG-2472

Integration code if contains the name eclipse then the endpoint /eclipse replace that with empty string leading to no integration in OIG

3.21.3.0.6

33957024

34048420

OIG-2521

CMT does not load as2805 integrations properly

3.21.3.0.7

34048433

34066194

OIG-2524

Subflow creation when payload provided is very large

3.21.3.0.7

34066199

3-29171386311

Known Issues

BugDB SR Internal Summary

33767440

3-28173135801

OIG-2387

File upload fail with java heap size error

Description:

When a large file is uploaded to the exchange, exchange fails with the error OIG-GATE-019: citing Java heap space as error

34164754

OIG-2567

Outbound exchange: values are not getting updated after building a data set

Description:

When trying to build a data set, exactVersionMatch and disableDeleteByOmission are not getting updated. Also If we try to update the inclusionDate by passing empty value it is not getting updated.

34169385

OIG-2571

TestDynamicLogic IP - Failure response Code is 418 instead of 400

Description:

Testdynamiclogic IP doesn’t have correct response code for unsuccessful execution of test unit. It should be 400 as it is in the implementation, but it is 418.

34174921

OIG-2578

The record searched upon gets cleared off after the display of the results in tab-table

Description:

Go to Integrations Page. Search for any integration record and open it in view mode. Click on Integration Parameters Tab and search for any record. The result will be displayed but the search keyword entered in quick search or advanced search components, disappears.