My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

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


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.


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)


For additional details, see:

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


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.