My Oracle Support Banner

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.


On Oracle Healthcare Analytics Data Integration (OHADI) version,

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


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.