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 DECEMBER 04, 2019
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.
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