Release Notes for Oracle Insurance Gateway Patch 4.23.2.0.3
This document contains the release notes for Oracle Insurance Gateway Patch 4.23.2.0.3.
| Version compatibility: Oracle Insurance Gateway Release 4.23.2.x is only compatible with other Oracle Health Insurance applications release version 4.23.2.x unless explicitly stated otherwise. |
Enhancements
| ID | Summary | Patch |
|---|---|---|
OIG-4336 |
Method to keep long running transaction alive with database During the transformation process in OIG, a data file is created and several requests are sent to the Policies system to fetch additional information. These requests can take varying amounts of time to complete, depending on the size of the data and how quickly the other system responds. While waiting for these responses, the connection to the database is not actively used. Because of this inactivity, the system may automatically close the connection after a certain period of time. When the process tries to update the data file after the responses are received, it fails with a timeout error, as the original connection to the database is no longer valid. Documentation Links: |
4.23.1.0.10, 4.24.1.0.4, 4.25.1.0.0, 4.26.1.0.0 |
Additional Upgrade Steps
Post-Deploy Phase
1) OHI Agent upgrade
Upgrade OHI Agent: Refer to Downloading and Running Oracle Health Insurance Agent for steps to perform the Agent upgrade.
Bug Fixes
| BugDB | SR | Internal | Summary |
|---|---|---|---|
38001707 |
3-40873628911 |
OIG-4451 |
Implement retry mechanism and content length verification during data file download in OIG |
Description: |
If an exception is encountered during data file download in OIG due to java.io.EOFException, the data download process fails and has to be recovered manually. A retry mechanism can be introduced that retries the download with some time gap so that the failure can be avoided altogether. Also, if an incomplete data file is received in OIG due to connection closed by external system, the partial data file is saved and step is marked as Done, leading to potential issues in later steps. A content length verification method can be introduced that verifies that the content-length returned in response header is same as size of downloaded data file so that the step can be marked Failed if data file is downloaded partially. |
||
Resolution: |
To address issues of incomplete or failed data file downloads in Oracle Insurance Gateway (OIG), a content length validation has been implemented. This mechanism is triggered when OIG detects partial data by comparing the actual content length with the expected value provided in a custom response header X-Content-Length. This header is now included in the POL/NXT data file response to facilitate accurate validation. If a mismatch is found, indicating a partial download, the system will automatically log and retry the download to ensure the complete file is retrieved. Note : The content length validation will only happen if X-Content-Length header is available in the response of the Data File IP. Please check if the fix is implemented in the applicable OHI Component by checking the release notes for a bug fix with summary containing 'custom content-Length header' |
||
37994194 |
OIG-4442 |
Performance degradation during OIG purge operations |
|
Description: |
The auto-purge job has been scheduled successfully. While the majority of purging tasks and batch data processing completed within a few hours, the OIG_EXCHANGE_LOG purge has been running for an extended period without completion. |
||
Resolution: |
The OIG purge operation is now completing within the expected duration after optimizing the purging logic by implementing a commit-size based design. |
||