Too Many Records Selected For Update In HCD Incremental View "V_CLAIM_PAYMT_F_INCR" That Causes Performance Degradation (Doc ID 2819015.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

Oracle Healthcare Foundation - Version 8.0.1and later
Information in this document applies to any platform.

ACTUAL BEHAVIOR
---------------
In OHF 8.01 environment, customer noticed too many records selected for update in HCD incremental view "V_CLAIM_PAYMT_F_INCR" that causes performance degradation. In general this works well except for the default record.


EXPECTED BEHAVIOR
-----------------------
Expect selected records not cause performance degradation.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a. Run the following sql:

select count(*) from hdm.HDM_CLM_PAYMT where clm_id = 1 and update_dt > sysdate -1;
7247 records updated yesterday

a. Run the following sql as well

select count(*) from hdm.HDM_CLM_PAYMT where clm_id = 1
3128993 actually processed each day

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.