Coding a term from Classify VT Omissions gives the error: ORA-01400: cannot insert null into ("TMS"." TMS_DICT_CONTENTS"."TERM_UPPER")
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.
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"."
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.
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