Release Notes for Oracle Health Insurance Claims Adjudication Patch 3.22.1.0.7
This document contains the release notes for Oracle Health Insurance Claims Adjudication Patch 3.22.1.0.7.
Version compatibility: Oracle Health Insurance Claims Adjudication 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. |
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 ofohi_install.cfg.template
and name itohi_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:
-
Open a command window and browse to
<OHI_ROOT>/util/install
. -
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:
|
Stage: pre-upgrade
Note: OHI delivers the new field N1202 with this patch. If record with the code N1202 found in the table cod_fields_b then below script will update the id with the new Id 169150 and its reference in the tables cod_flex_code_field_usages_b and cod_dynamic_field_usages_b.
It is recommended to take the DB backup before running the script.
Please execute the SQL statement with user: OHI_CLAIMS_OWNER.
declare
l_cod_field_id cod_fields_b.id%type;
begin
select id into l_cod_field_id from cod_fields_b where code='N1202';
DBMS_OUTPUT.PUT_LINE ('Updating the id ' || l_cod_field_id || ' of table cod_fields_b for code N1202');
execute immediate 'alter table cod_fields_tl disable constraint cod_field_tl_fk1';
execute immediate 'alter table cod_flex_code_field_usages_b disable constraint cod_flex_code_field_use_fk3';
execute immediate 'alter table cod_dynamic_field_usages_b disable constraint cod_dynamic_field_usage_fk1';
update cod_fields_b set id = 169150 where id = l_cod_field_id;
update cod_fields_tl set base_table_id = 169150 where base_table_id = l_cod_field_id;
update cod_flex_code_field_usages_b set fiel_id = 169150 where fiel_id = l_cod_field_id;
update cod_dynamic_field_usages_b set fiel_id = 169150 where fiel_id = l_cod_field_id;
commit;
execute immediate 'alter table cod_fields_tl enable constraint cod_field_tl_fk1';
execute immediate 'alter table cod_flex_code_field_usages_b enable constraint cod_flex_code_field_use_fk3';
execute immediate 'alter table cod_dynamic_field_usages_b enable constraint cod_dynamic_field_usage_fk1';
exception
when no_data_found then
DBMS_OUTPUT.PUT_LINE ('Update of the seed data id is skipped as no matching record was found. Please proceed with further upgrade step');
end;
/
Bug Fixes
BugDB | SR | Internal | BP | Summary |
---|---|---|---|---|
34699003 |
NXT-25538 |
BP |
Provider Pricing Clause - when rule type is Provider Limit Rules, and pricing rule selected is of type Service Days, quantifier is displayed as '#', it should be 'Days' |
|
Description: |
In Provider Pricing Clause page, when a provider limit rule is selected which has provider limit category type as 'D', the quantifier type should be displayed as 'Days' but instead '#' is shown as the quantifier type. |
|||
Resolution: |
When the provider limit rule with provider limit category of type 'D' is selected, the quantifier type is shown as 'Days'. |
|||
34703087 |
NXT-25542 |
BP |
When reference property is set with "criteriamandatory": true, blank search on lov is not showing error messages. |
|
Description: |
When criteria mandatory is set to true for a reference property in the floorplan, error message is not shown when a blank search is done. |
|||
Resolution: |
When criteria mandatory is set to true and a blank search is performed, an error message is shown indicating searching without criteria is not allowed. |
|||
34697680 |
3-30823746721 |
NXT-25534 |
BP |
Extract activity with high volume may cause OutOfMemoryError |
Description: |
Extract activity with high volume (and if multiple extract activities are processed concurrently) may cause OutOfMemoryError. All the child activities are submitted at once to the coherence grid for processing, causing contention and memory issues in coherence. |
|||
Resolution: |
Processing of the child activities (PROCESS_EXTRACT_ITEMS) originated from the parent activity (SELECT_EXTRACT_ITEMS) is now throttled. Also, the memory footprint of running the activity PROCESS_EXTRACT_ITEMS is reduced. |
|||
34793861 |
NXT-25743 |
BP |
Widgets - Custom pie chart widgets with group by and query parameter is not working |
|
Description: |
Custom pie chart widgets are not loading when group by and query parameters are present in query. User will give full query string in floorplan however the system constructs the query string by adding explicit "q" |
|||
Resolution: |
Custom pie chart widgets are getting loaded when group by and query parameters are specified. |
|||
34790503 |
NXT-25715 |
BP |
If a claim has Combination of Denied and Approved claimlines, while clicking on 'Pricing' icon, the page stuck |
|
Description: |
If a claim has Combination of Denied and Approved claimlines, while clicking on 'Pricing' icon, the page stuck |
|||
Resolution: |
On click of Pricing icon in claimline tab, it is possible to navigate to pricing page with pricing data being displayed |
|||
34803934 |
NXT-25767 |
BP |
Claimline Detail Page: While clicking on Summary Button, when we expand all the sections, an error appears and not able to close the drawer |
|
Description: |
Claimline Detail Page: While clicking on Summary Button, when we expand all the sections, an error appears and not able to close the drawer |
|||
Resolution: |
Able to close the Summary button drawer in claimline detail page |
|||
34804247 |
NXT-25772 |
BP |
Error Messages shown in console while performing any action with a claimline that doesn’t have claimLineMessages attached |
|
Description: |
When a claimline does not have any claim line message attached, and claim is in change status, while performing any action on that claimline, a console error is shown |
|||
Resolution: |
Error Messages are not shown in console while performing any action with a claimline that doesn’t have claimLineMessages attached |
|||
34804327 |
NXT-25774 |
BP |
Not able to resolve pend reason for a claimline from claimline details page |
|
Description: |
Not able to resolve pend reason for a claimline when trying from 'Claim Line Pend Reasons Tab' of claim line detail page. |
|||
Resolution: |
Able to resolve pend reason for a claimline from claimline details page. |
|||
34799450 |
3-31158495511 |
NXT-25754 |
BP |
Boilerplates not displayed after upgrade |
Description: |
Newly added boilerplates are not displayed after upgrade. |
|||
Resolution: |
Resetting boilerplate related localstorage (cache) after application upgrade. |
|||
34615214 |
3-30406742931 |
NXT-25428 |
BP |
Generate step of Financial message generation throwing error when we exceed invoice amount 99999999 |
Description: |
When we submit a generate activity with total invoice amount over 99999999 we get error back in calling service where Ohi rejects the request with message. |
|||
Resolution: |
Up to 10 digits are now allowed for invoiceAmount of activity type of code "GENERATE_FIN_MESSAGES_EMBEDDED" |
|||
34685907 |
3-30829017561 |
NXT-25527 |
BP |
Access restrictions on pend reasons are not enforced |
Description: |
User should not be able to resolve the pend reason when a pendReason is created with access restriction type 'pend reason resolution' and user does not have access to that accessrestriction type. |
|||
Resolution: |
User can resolve the pend reason in Claims page when a PendReason is created with access restriction type 'pend reason resolution' and only when user has access to that access restriction type. |
|||
34743271 |
3-30969222841,3-31093057821 |
NXT-25632 |
BP |
Claim line information disappears after an alert is raised. |
Description: |
When a submit operation is performed that is interrupted with an error, error details are shown on the screen but the tab level claim line details are missing. |
|||
Resolution: |
When the submit operation is interrupted with an error in claims, the page shows all the tab level data and also the errors related to the submit operation. |
|||
34780945 |
3-31189721631,3-31193687511,3-31004245611 |
NXT-25693 |
BP |
Not able to open claimline details and getting console error |
Description: |
Not able to open claimline details and getting console error. This issue occurs for claims with pricing information and got introduced in 3.22.1.0.6 patch |
|||
Resolution: |
Able to open claimline details now on click of view icon for claims which have pricing information as well. |
|||
34683509 |
NXT-25524 |
BP |
Aggregating financial messages activity GENERATE_FIN_MSG_XML failed on high volume data |
|
Description: |
Aggregating financial messages activity GENERATE_FIN_MSG_XML failed when volume of data was high. The failure was due to oracle DB internal ORA-00600, which occurred while committing a high amount of data through the JPA layer. Aggregating financial messages at the end of GENERATE_FIN_MSG_XML fails with ORA-00600 error when the volume (number/size of financial messages) is high |
|||
Resolution: |
An alternate XML aggregation logic has been implemented to fix ORA-00600 error |
|||
34642536 |
3-30622792761 |
NXT-25475 |
BP |
Unable to select applicable person covered service |
Description: |
In the event that there are more than one person covered services for the same service within the time window for a single policy product, the application is unable to select the appropriate person covered services. |
|||
Resolution: |
Instead of retrieving the person covered service with the same start and end date as the policy product, it is retrieved based on the person covered service active on the start date of the policy product. |
|||
34703150 |
NXT-25544 |
BP |
Property selection not working for lov configured in set1 and set2 |
|
Description: |
When user configures propertySelection : true property in LOV floorplan, it is not working for the lov fields which are configured in set1, set2 and it is misaligned in set3 |
|||
Resolution: |
PropertySelection configuration in lov floorplan will work for the lov fields which are configured in set1, set2 and set3 |
|||
34767451 |
NXT-25670 |
BP |
'No Pricing Data Available' displayed under Contract Reference field under Claim Line Summary section |
|
Description: |
'No Pricing Data Available' displayed under Contract Reference field under Claim Line Summary section |
|||
Resolution: |
The boilerplate 'No Pricing Data Available' is removed and won’t be shown now, instead the header itself is blank if there is no pricing data. |