'ORA-20000: 822100-The User ops$xxxx Is Maintained In Oracle Clinical'
Last updated on JULY 20, 2016
Applies to:Oracle Thesaurus Management System - Version: 4.6.0
Information in this document applies to any platform.
Navigation: Definition > Define Dictionaries > Dictionary Link Tab
You also determined that that the dictionaries are only available to users that were created in TMS. Users that were created using the OCL_ADD_USER.SQL receive the error:
FRM-41830: List of Values contains no entries
Upon checking the Define User screen you cannot query up (Press F8 ) the user OPS$TMS_TESTA.
When you click on 'Get O* Clinical Data' from Define User screen in TMS, you receive the following error:
ORA-0001: unique constraint (OPA.OPA_ACCOUNTS_UK1) violated
ORA-06512: at line 1
ORA-06512: at "OPA.OPA_USER_MT_SCHEMA",line209
FRM-40735: STD_OPTION1 trigger raised unhandled exception ORA-00001.
Also when you try to create a new user in TMS you receive the following error message:
'ORA-20000: 822100-The user OPS$XXXX Is Maintained in Oracle Clinical'
OCCURRENCE PATTERNS: consistent since creating the users via OCL_ADD_USER.SQL
WORKAROUNDS: None available
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