Execution of PKG_Global_Refresh_Procedure fails with 'ORA-00001: unique constraint (HDM.HDM_CD_REPOSITORY_S_UK) violated'

(Doc ID 2319098.1)

Last updated on OCTOBER 19, 2017

Applies to:

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

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Healthcare Analytics Data Integration (OHADI) 3.0.0.1 version,

When attempting to execute the PKG_Global_Refresh_Procedure procedure,
the following error occurs:

ERROR
-----------------------


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. From ODI connect to Oracle Healthcare Analytics Data Integration
2. Navigate to SETUP > Packages
3. Execute PKG_Global_Refresh_Procedure package.


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