My Oracle Support Banner

Coding a term from Classify VT Omissions gives the error: ORA-01400: cannot insert null into ("TMS"." TMS_DICT_CONTENTS"."TERM_UPPER") (Doc ID 2186650.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Oracle Thesaurus Management System - Version 5.0.1 to 5.1.0 [Release 5.0 to 5.1]
Information in this document applies to any platform.

Symptoms

The issue appears when trying to code a verbatim Term from the Omissions screen e.g. "STOMACH REFLUX". When the User attempts to code the
term from Classify VT Omissions, it throws the error:

ORA-01400: cannot insert null into ("TMS"."
TMS_DICT_CONTENTS"."TERM_UPPER")

Also, you may not be able to see the same Term from the "Distinct Verbatim Term Omissions" screen. But when you search again in the Distinct tab (after
querying from the All tab) it then appears. First F7 / F8 in the All tab, then F7 / F8 in the Distinct tab.

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

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