TMS Load Script Updates Cause Error: Term Already Active In This Level

(Doc ID 1097703.1)

Last updated on SEPTEMBER 04, 2014

Applies to:

Adverse Event Reporting System - Version: 4.5.1 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.


After loading dictionary terms into Oracle Thesaurus Management System, the following error is presented for synonyms that are being deleted and re-created with different dict_content_code values:

Term already active in this level (or in this group)

For each occurrence of the error there are three records per term: 1 for the original, 1 for the deletion DML and one for the insertion DML for the replacement term.


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