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:
Oracle Healthcare Foundation - Version 8.0.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |