OHADI: ODI-1228: Task INT_HDI_CD_REPOSITORY_DESC_STUS_CD

(Doc ID 1638661.1)

Last updated on MARCH 14, 2016

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.0 and later
Information in this document applies to any platform.

Symptoms

OHADI 2.0.0, users run into the following issue loading:

HLI runs two interfaces which seem similar and collide:

1. INT_HDI_CD_REPOSITORY_STATUS_CODE
2. INT_HDI_CD_REPOSITORY_STATUS_CD

Results in the following error message:

ODI-1228: Task INT_HDI_CD_REPOSITORY_DESC_STUS_CD (Integration) fails on the target ORACLE connection HDI.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (HDI.HDI_CD_REPOSITORY_UK) violated.

The data is colliding because the INT_ID, DAT_SRC_NUM_DI, and SRC_CHANGED_ON_DT are not unique. They were inserted by a previous step.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms