My Oracle Support Banner

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

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Adverse Event Reporting System - Version 4.5.1 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution
References


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