ORA-00001 Error When Importing Oracle Clinical Users into TMS (Doc ID 1353522.1)

Last updated on NOVEMBER 04, 2011

Applies to:

Oracle Thesaurus Management System - Version: 4.6.0 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.

Symptoms

TMS 4.6.0

When trying to import O*C (Oracle Clinical) users into TMS the following error is returned:

ORA-00001: unique constraint (OPA.OPA_ACCOUNTS_UK1) violated


Steps to Reproduce:

  1. Log into TMS
  2. TMS
  3. Security
  4. Define Users
  5. Click on button [Get O*Clinical Account data]


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