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.

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

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