My Oracle Support Banner

Performance Issue In HCD Workflow “wf_SIL_HCD_W_HCD_ORDER_F” (Doc ID 2585775.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

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

Symptoms

On Oracle Healthcare Foundation (OHF) 7.1.4 version

ACTUAL BEHAVIOR
---------------
Customer is experiencing performance issue in HCD “wf_SIL_HCD_W_HCD_ORDER_F” workflow which processes the orders data into HCD. The initial load HCD workflow “wf_SIL_HCD_W_HCD_ORDER_F” is running more than 2 days and processed only 14 Million clinical orders. The throughput is ~100 rows/sec which is very low. The total orders to be processed is 62 Million. Customer is looking an assistance in tuning the orders workflow performance.

EXPECTED BEHAVIOR
-----------------------
Expect initial load HCD workflow “wf_SIL_HCD_W_HCD_ORDER_F” to run faster and complete to load 62 Million records within reasonable time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Run initial load HCD workflow “wf_SIL_HCD_W_HCD_ORDER_F”
2. Took more than 2 days to process 14 Million clinical orders.

 

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.