My Oracle Support Banner

Performance Issue Running Incremental View - V_BILL_LINE_FC_INCR After OHF 8.2 Upgrade (Doc ID 2872102.1)

Last updated on MAY 25, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
After upgrading to OHF 8.2, HCD incremental view "V_BILL_LINE_FC_INCR" shows a very slow performance. Before the upgrade which used run 16 minutes average in OHF version 8.0.1, now it is taking 74 minutes. 

EXPECTED BEHAVIOR
-----------------------
Expect Incremental View V_BILL_LINE_FC_INCR to run at list within 16 minutes average as in OHF version 8.0.1.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade to OHF 8.2
2. Run incremental View ETL
3. The view took 74 minutes to run completely


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

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