CREATE TASK API ERROR: DOMAIN INDEX IS MARKED LOADING/FAILED/UNUSABLE

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    CREATE TASK API ERROR: DOMAIN INDEX IS MARKED LOADING/FAILED/UNUSABLE

XXFZ_CS_BPA_WF_PKG.CREATE_FIRST_LEVEL_TASKS(SERVEREQ, 2876326-19270424, 201514, RUN, Create Task API error : Create Task API error : -29861 ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE)
Wf_Engine_Util.Function_Call(XXFZ_CS_BPA_WF_PKG.CREATE_FIRST_LEVEL_TASKS, SERVEREQ, 2876326-19270424, 201514, RUN)

Solution:

SELECT INDEX_NAME,TABLE_NAME,DOMIDX_OPSTATUS FROM DBA_INDEXES WHERE DOMIDX_OPSTATUS <> 'VALID';

1 IRC_SEARCH_CRITERIA_CTX IRC_SEARCH_CRITERIA FAILED

Rebuild the index using 

Alter index index_name rebuild;

References:

Ref: Note: 312640.1 - Oracle Text: Re-installation of Applications 11i (11.5.10) Oracle Text Indexes

Get Oracle Certifications for all Exams
Free Online Exams.com