My Oracle Support Banner

Code Repository Table Is Left Out From the Join Condition In The HCD Encounter Source View V_ENCOUNTER_F_INIT / V_ENCOUNTER_F_INCR (Doc ID 2598616.1)

Last updated on OCTOBER 30, 2019

Applies to:

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

Symptoms

On OHF 7.1.4 version

ACTUAL BEHAVIOR
---------------
When using OHF 7.1.4 Informatica ETLs, the initial load workflow wf_SIL_HCD_W_HCD_ENCOUNTER_F was running for two days and it didn’t retrieve any source data from the database.

EXPECTED BEHAVIOR
-----------------------
Source view V_ENCOUNTER_F_INIT and workflow “wf_SIL_HCD_W_HCD_ENCOUNTER_F” performance is expected to be improved.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ETL
2. The workflow “wf_SIL_HCD_W_HCD_ENCOUNTER_F” run for more than 2 days.
3. Customer identified a defect from view V_ENCOUNTER_F_INIT and fix the issue.
4. SR is created to log a bug



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


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