Reclassify Verbatim Terms Search Results in a ORA-00904: "DICT_APPROVED_FLAG": invalid Warning

(Doc ID 1066975.1)

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.

Symptoms

TMS 4.6.1

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:

  1. Logon to application as non-superuser
  2. Open Reclassify Verbatim Terms Form
  3. On Distinct VTA tab, execute a query
  4. Get error: ORA-00904: "DICT_APPROVAL_FLAG": invalid identifier
 


Changes

Recent upgrade or install of TMS 4.6.1

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