Error No: -2146233088 Description: ORA-30554: function based index ARGUS_APP.IDX_DUP_SEARCH_DATA is disabled
Last updated on DECEMBER 06, 2017
Applies to:Oracle Argus Safety - Version 7.0.0 and later
Information in this document applies to any platform.
***Reviewed for currency: 09-JUN-2013***
Oracle Argus Safety 7.0
Error on the “Case Search Criteria” windows on Argus 7.0 Production
Getting the attached error screen when doing a search on the “Case Search Criteria” window on Argus 7.0 Production environment.
ARGUS_APP.IDX_DUP_SEARCH_DATA is disabled ORA-06512: at
"ARGUS_APP_.PKG_TEXT_SEARCH", line 70 ORA-06512: at line 1
Confirmed from DBA that "Both the package and index are available and compiled with no errors."
Steps to reproduce the error:
- Case Actions
- Entered in a few fields that matched a case I had previously entered
- Click "Search" to begin searching for the duplicate case.
- Error message appears e.g.
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