'Missing mandatory relation ...' in TMS_DICT_CONTENTS table (Doc ID 1144254.1)

Last updated on JANUARY 16, 2015

Applies to:

Oracle Thesaurus Management System - Version 4.6.0 to 4.6.5 [Release 4.6.0 to 4.6.2]
Information in this document applies to any platform.
***Checked for relevance on 24-APR-2012***
***Checked for relevance on 16-Jan-2015***

Symptoms

TMS is integrated with AERS, and upgrading Meddra to version 13 , based on details outlined in appendix A of the AERS 4.6 Installation manual. The following error are found after activating new version.

TMS_DICT_CONTENTS Table

Missing mandatory relation between CODING-VT
Missing mandatory relation between PT-LLT
More than one primary path has been entered for this term
Term already active in this level (or in this group)

Changes

For additional details, see:

AERS 4.6.1 Installation manual;
Appendix A: 'Updating Oracle AERS-TMS Dictionaries with new dictionary versions'

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