My Oracle Support Banner

TMS Load Script Updates Cause Error: Term Already Active In This Level (Doc ID 1097703.1)

Last updated on AUGUST 25, 2022

Applies to:

Adverse Event Reporting System - Version 4.5.1 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.