My Oracle Support Banner

OHF Workflow Fails With "ORA-26002: Table HCD.W_HCD_INT_ORG_DH has index defined upon it" Due To Bulk Load Settings (Doc ID 2619232.1)

Last updated on FEBRUARY 02, 2024

Applies to:

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

Symptoms

On Oracle Healthcare Foundation (OHF) 7.1.1 version

When attempting to execute Informatica workflow wf_SIL_HCD_W_HCD_INT_ORG_DH, the workflow is failing due to Oracle bulk load setting on target table that has indexes built over it. Many of the workflows in the HCD_HIERARCHY_LOAD folder have similar settings.


ERROR
-----------------------
2019-12-03 13:10:52 : ERROR : (1985 | WRITER_1_*_1) : (IS | IS_Common_Datamart_Loaders_711_DEV) : <HOST_NAME>_<NODE_ID> : WRT_8229 : Database errors occurred:
ORA-26002: Table HCD.W_HCD_INT_ORG_DH has index defined upon it.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the workflow wf_SIL_HCD_W_HCD_INT_ORG_DH
2. Then workflow is failing due to Oracle bulk load setting on target table since it has indexes built over it.

 

 

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.