R12: adconfig.log - jtfictx.sh INSTE8_PRF 1 - ORA-29874: warning in the execution of ODCIINDEXALTER routine - DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed

Oracle E-Business Suite: R12.1.2 on Linux 32, Concurremt Manager on Linux 64 bit
Oracle Database: 11.2.0.3 on HP UX Itanium

The autoconfig executed during the clone of test instance failed for the following error:

jtfictx.sh started at Sun Sep  8 01:51:08 CDT 2013


SQL*Plus: Release 10.1.0.5.0 - Production on Sun Sep 8 01:51:09 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
DECLARE
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/u01/app/oracle/erp/11.2.0/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 96

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
jtfictx.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************


Troubleshooting:

I tried all the below metalink notes and wasn't successful.


1. "Jtfictx.sh" Failed During Autoconfig On Application Tier, ORA-29874, DRG-10595 (Doc ID 1271186.1)
2. Autoconfig Failed On Apps Tier "jtfictx.sh INSTE8_PRF" . Running manually "jtfictx.sh " Failed on "DRG-10758: index owner does not have the privilege" (Doc ID 1357760.1)
3. Autoconfig Completed With Error 'Jtfictx.sh Inste8_prf 1' (Doc ID 372363.1)
4. Autoconfig is Failing With "DRG-10561: Index Jtf_amv_items_url_ctx Is Not Valid For Requested" Error (Doc ID 1334405.1)
5. Several Scripts Failing With A ORA-29855 Executing ODCIINDEXCREATE Routine During Upgrade To 12.1.1 (u6678700.drv) (Doc ID 1286033.1)
6. Creating a Text Index Fails with DRG-00100 [51021],[drwaf.c],[1615] (Doc ID 1576539.1)

Solution:

The culprit for the issue is the CTXSTS.DEFAULT_LEXER. INDEX_THEMES attribute was made YES.

1) Login to the database as ctxsys and run
exec ctx_ddl.set_attribute('DEFAULT_LEXER','INDEX_THEMES','no');
2) Now drop and rebuild the indexes as following:
$ cd $JTF_TOP/patch/115/sql/
$ sqlplus apps/apps @jtfiimt.sql JTF JTF NULL NULL

Note:  The "jtfiaibu.sql" script is used to drop and recreate the "JTF_AMV_ITEMS_URL_CTX" Intermedia Text index.

$ cd $JTF_TOP/patch/115/sql/
$ sqlplus apps/apps @jtfiaibu.sql JTF JTF APPS


Reference:
Oracle Text may not include Theme Functionality after Installation (Doc ID 262701.1)
Missing Oracle Text Supplied Knowledge Base after Database 11g Installation (Doc ID 557239.1)
"Jtfictx.sh" Failed During Autoconfig On Application Tier, ORA-29874, DRG-10595 (Doc ID 1271186.1)