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 SEPTEMBER 26, 2016

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

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