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.
OHADI 2.0.0, users run into the following issue loading:
HLI runs two interfaces which seem similar and collide:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms