Reclassify Verbatim Terms Search Results in a ORA-00904: "DICT_APPROVED_FLAG": invalid Warning
Last updated on MARCH 30, 2010
Applies to:Oracle Thesaurus Management System - Version: 4.6.1 to 4.6.1 - Release: 4.6 to 4.6
Information in this document applies to any platform.
Reclassify verbatim terms: Searching for any verbatim term does not work. Pressing F7 and F8 results in a ORA-00904 warning e.g.:
It is independent of whether you want to receive all terms or if you specify and specific term.
Steps to reproduce:
- Logon to application as non-superuser
- Open Reclassify Verbatim Terms Form
- On Distinct VTA tab, execute a query
- Get error: ORA-00904: "DICT_APPROVAL_FLAG": invalid identifier
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