Release Notes for Oracle Health Insurance Claims Adjudication Patch 3.21.1.0.2

This document contains the release notes for Oracle Health Insurance Claims Adjudication Patch 3.21.1.0.2.

Version compatibility: Oracle Health Insurance Claims Adjudication Release 3.21.1.x is only compatible with other Oracle Health Insurance applications release version 3.21.1.x unless explicitly stated otherwise.

Enhancements

No enhancements.

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

Ref	Action	Subject	Description
NXT-22273	Modified	Reference Sheets	Claims application was not showing the Reference Sheets option on menu option. It is now available.

Ref

Action

Subject

Description

NXT-22273

Modified

Reference Sheets

Claims application was not showing the Reference Sheets option on menu option. It is now available.

Deprecated items (to be removed in future release)

This section intentionally left blank.

Breaking Changes

This section intentionally left blank.

Bug Fixes

BugDB	SR	Internal	BP	Summary
32594368	3-25194634741	NXT-22216	BP	The urls to collect data from source system for CMT import, should be based on the request url
Description:	Subsequent requests made to collect data from source system for CMT import is not based on the request url.
Resolution:	If a rest service asks for metadata information, then it is now assumed to always obey the header of request URL. So, any subsequent requests made are now based on the request URL.
32609242	3-25255922421	NXT-22241	BP	CLA-FL-BENS-066 error is attached to claimline even when policy product exists
Description:	When there are multiple policy products for the same product, application intermittently picks up the wrong policy product and this causes CLA-FL-BENS-066 error.
Resolution:	The product is not reselected when previous products are added. This avoids CLA-FL-BENS-066 error.
32656520	3-25194388651	NXT-22302	BP	Benefits task should not fail with NPE if incorrect subscription date is returned by the enrollment response
Description:	Enrollment Information regarding contracts of some claims is outside the scope of the claimLine service date which leads to null pointer exception (NPE) at benefits task. Reprocessing these claims by sending them again with claims in and overwrite flag resolves the issue. But , NPE still need to be avoided .
Resolution:	A new message "CLA-FL-BENS-068" has been introduced for such scenarios. This will be attached to claim line message with message description as "Unable to complete benefit selection successfully". Also, an error message will be logged in log file .
32663803	3-25194388651	NXT-22325	BP	NPE in benefits step is seen where claim has claimline(s) having case definition details as ancillary lines.
Description:	When a claim has multiple policy product including history with same product, there are multiple product benefit specifications for this product because initial selection happens based on the policy product and not on the product. In OHI, if a claimline is an ancillary detail to the case definition attached to the ben spec, then those lines are deleted. Since there are multiple product benefit specifications selected for the same benefit specification, when second time the same benefit spec is processed, it again tries to delete ancillary lines which are now no longer there, and hence gets Null Pointer Exception (NPE).
Resolution:	One product is selected only once. The benefitspecification selection cache is extended to have product id as key and not policy product id .
32663846	3-25194388651	NXT-22329	BP	Claim processing fails with NPE in finalize task when consumptions are finalized before periods
Description:	When there are no existing provider limit counter periods for the provider limit counter, then application returns null which cause Null pointer exception and claim gets stuck. However, there are preliminary provider limit counter periods that should be finalized before finalizing consumption. So sometimes that doesn’t happen in the same order as intended, which is periods before consumption.
Resolution:	It is ensured that periods are finalized before consumption and that those finalized periods are available to be queried while finalizing consumption. Also, null check is added incase if no periods are found.
32718142	3-25228475161	NXT-22387	BP	Claims search in GUI taking long time.
Description:	Queries having call for table(ohi_util_pkg.split_ids(:1)) calculates wrong cardinality estimated rows as 8k due to which query uses poor plan. As a result search query takes long time.
Resolution:	This issue is fixed by implementing extensible optimizer feature available from Oracle DB 12.2 onwards. Query performance is now improved.
32756401	3-25577949681	NXT-22417	BP	Supported paths in claimscalloutresponse IP metadata doesn’t work.
Description:	Supported paths in claimscalloutresponse IP returns "Not Found" because paths in metadata doesn’t contain "/claimscalloutresponse" prefixed in them . Example - It is /custom instead of /claimscalloutresponse/custom in the metadata .
Resolution:	All the supported paths are prefixed with "/claimscalloutresponse" now. This fixes the 'Not Found' error in claimscalloutresponse IP.
32766628	3-25664580391	NXT-22425	BP	CLA-IP-ENRO-009 error is thrown when the families in the enrollment response have a time gap between them
Description:	When the families in the enrollment response have a time gap between them, CLA-IP-ENRO-009 error is thrown even though a family code is present for all days on which the policy product is enrolled.
Resolution:	Even if there is gap between the end date on previous line(family) and start date on current line (family) in the enrollment response, current family line will be selected provided product is valid in the specified period.
32768828	3-25455694151	NXT-22430	BP	Scrollbar resets when changing the method/rule in DPPC page.
Description:	Scrollbar and Start date reset when changing method/rule in DPPC page.
Resolution:	The scrollbar and the start date do not reset now when the value for method/rule is changed in DPPC page.
32804939	3-25726570421	NXT-22493	BP	Duplicating a claim line which has a value for an Overriding Claim Line Parameter gives error.
Description:	Duplicating a claim line which has a value for an Overriding Claim Line Parameter gives error.
Resolution:	Duplicating a claim line which has a value for the overriding claim line parameter does not give any error now and it saves correctly.
32816965	3-25352091891	NXT-22505	BP	Claims application not Showing the Reference Sheets option on menu option
Description:	In claims application, the Reference Sheet option is not visible on the menu item under the system.
Resolution:	Reference sheet option is now available in the menu items in System.
32847537	3-25807956679	NXT-22541		Scroll required between tabs to navigate to all tabs in a page without zooming out
Description:	Customer needs to display more than 7 tabs, but the screen cannot fit all of them. Since there is no option to scroll between tabs the only option is to zoom out to be able to see all the tabs
Resolution:	Now the scroll option is available for the tabs, so now without zooming out the user can navigate from one tab to another in case of more no. of tabs.
32847608	3-25689550511	NXT-22542	BP	Updating dynamic records on multiple record definitions with same key field name does not work
Description:	Update of dynamic records do not work with multiple record definitions having same key name because existing records are filtered only on key and value but not field usage name.
Resolution:	Updating dynamic records on multiple record definitions with same key field name work as expected with this change. Now the existing records are filtered on field usage name also.
32857624	3-25777646831	NXT-22559		Not able to filter the results in Lov’s based on anything else apart from code.
Description:	The user is not able to perform search for anything else apart from the code in the LOVs. Steps to reproduce 1. Find an LOV which have multiple search criteria for the search. 2. Click on the gear icon beside the search icon on the LOV. 3. Select any other option apart from code for search criteria. 4. Try to search a result based on that field which should return a result. Expected: The LOV should work properly and return proper search results based on the selected search criteria.
Resolution:	Now able to filter/search the results based on checkbox selected from advanced attribute (i.e gear icon)

BugDB

Internal

Summary

32594368

3-25194634741

NXT-22216

The urls to collect data from source system for CMT import, should be based on the request url

Description:

Subsequent requests made to collect data from source system for CMT import is not based on the request url.

Resolution:

If a rest service asks for metadata information, then it is now assumed to always obey the header of request URL. So, any subsequent requests made are now based on the request URL.

32609242

3-25255922421

NXT-22241

CLA-FL-BENS-066 error is attached to claimline even when policy product exists

Description:

When there are multiple policy products for the same product, application intermittently picks up the wrong policy product and this causes CLA-FL-BENS-066 error.

Resolution:

The product is not reselected when previous products are added. This avoids CLA-FL-BENS-066 error.

32656520

3-25194388651

NXT-22302

Benefits task should not fail with NPE if incorrect subscription date is returned by the enrollment response

Description:

Enrollment Information regarding contracts of some claims is outside the scope of the claimLine service date which leads to null pointer exception (NPE) at benefits task. Reprocessing these claims by sending them again with claims in and overwrite flag resolves the issue. But , NPE still need to be avoided .

Resolution:

A new message "CLA-FL-BENS-068" has been introduced for such scenarios. This will be attached to claim line message with message description as "Unable to complete benefit selection successfully". Also, an error message will be logged in log file .

32663803

3-25194388651

NXT-22325

NPE in benefits step is seen where claim has claimline(s) having case definition details as ancillary lines.

Description:

When a claim has multiple policy product including history with same product, there are multiple product benefit specifications for this product because initial selection happens based on the policy product and not on the product. In OHI, if a claimline is an ancillary detail to the case definition attached to the ben spec, then those lines are deleted. Since there are multiple product benefit specifications selected for the same benefit specification, when second time the same benefit spec is processed, it again tries to delete ancillary lines which are now no longer there, and hence gets Null Pointer Exception (NPE).

Resolution:

One product is selected only once. The benefitspecification selection cache is extended to have product id as key and not policy product id .

32663846

3-25194388651

NXT-22329

Claim processing fails with NPE in finalize task when consumptions are finalized before periods

Description:

When there are no existing provider limit counter periods for the provider limit counter, then application returns null which cause Null pointer exception and claim gets stuck. However, there are preliminary provider limit counter periods that should be finalized before finalizing consumption. So sometimes that doesn’t happen in the same order as intended, which is periods before consumption.

Resolution:

It is ensured that periods are finalized before consumption and that those finalized periods are available to be queried while finalizing consumption. Also, null check is added incase if no periods are found.

32718142

3-25228475161

NXT-22387

Claims search in GUI taking long time.

Description:

Queries having call for table(ohi_util_pkg.split_ids(:1)) calculates wrong cardinality estimated rows as 8k due to which query uses poor plan. As a result search query takes long time.

Resolution:

This issue is fixed by implementing extensible optimizer feature available from Oracle DB 12.2 onwards. Query performance is now improved.

32756401

3-25577949681

NXT-22417

Supported paths in claimscalloutresponse IP metadata doesn’t work.

Description:

Supported paths in claimscalloutresponse IP returns "Not Found" because paths in metadata doesn’t contain "/claimscalloutresponse" prefixed in them . Example - It is /custom instead of /claimscalloutresponse/custom in the metadata .

Resolution:

All the supported paths are prefixed with "/claimscalloutresponse" now. This fixes the 'Not Found' error in claimscalloutresponse IP.

32766628

3-25664580391

NXT-22425

CLA-IP-ENRO-009 error is thrown when the families in the enrollment response have a time gap between them

Description:

When the families in the enrollment response have a time gap between them, CLA-IP-ENRO-009 error is thrown even though a family code is present for all days on which the policy product is enrolled.

Resolution:

Even if there is gap between the end date on previous line(family) and start date on current line (family) in the enrollment response, current family line will be selected provided product is valid in the specified period.

32768828

3-25455694151

NXT-22430

Scrollbar resets when changing the method/rule in DPPC page.

Description:

Scrollbar and Start date reset when changing method/rule in DPPC page.

Resolution:

The scrollbar and the start date do not reset now when the value for method/rule is changed in DPPC page.

32804939

3-25726570421

NXT-22493

Duplicating a claim line which has a value for an Overriding Claim Line Parameter gives error.

Description:

Duplicating a claim line which has a value for an Overriding Claim Line Parameter gives error.

Resolution:

Duplicating a claim line which has a value for the overriding claim line parameter does not give any error now and it saves correctly.

32816965

3-25352091891

NXT-22505

Claims application not Showing the Reference Sheets option on menu option

Description:

In claims application, the Reference Sheet option is not visible on the menu item under the system.

Resolution:

Reference sheet option is now available in the menu items in System.

32847537

3-25807956679

NXT-22541

Scroll required between tabs to navigate to all tabs in a page without zooming out

Description:

Customer needs to display more than 7 tabs, but the screen cannot fit all of them. Since there is no option to scroll between tabs the only option is to zoom out to be able to see all the tabs

Resolution:

Now the scroll option is available for the tabs, so now without zooming out the user can navigate from one tab to another in case of more no. of tabs.

32847608

3-25689550511

NXT-22542

Updating dynamic records on multiple record definitions with same key field name does not work

Description:

Update of dynamic records do not work with multiple record definitions having same key name because existing records are filtered only on key and value but not field usage name.

Resolution:

Updating dynamic records on multiple record definitions with same key field name work as expected with this change. Now the existing records are filtered on field usage name also.

32857624

3-25777646831

NXT-22559

Not able to filter the results in Lov’s based on anything else apart from code.

Description:

The user is not able to perform search for anything else apart from the code in the LOVs.
Steps to reproduce
1. Find an LOV which have multiple search criteria for the search.
2. Click on the gear icon beside the search icon on the LOV.
3. Select any other option apart from code for search criteria.
4. Try to search a result based on that field which should return a result.

Expected: The LOV should work properly and return proper search results based on the selected search criteria.

Resolution:

Now able to filter/search the results based on checkbox selected from advanced attribute (i.e gear icon)

Issues that were backported in previous Release / Patch

No backports.