R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 - ORA-29874: warning in the execution of ODCIINDEXALTER routine

R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 - ORA-29874: warning in the execution of ODCIINDEXALTER routine

In this post we will know how to resolve jtfictx.sh INSTE8_PRF 1 - ORA-29874.

During EBS clone  I faced the following error while try to run adcfgclone.pl on appsTier then autoconfig failed at appsTier.

Autoconfig completed with errors.

/apps/inst/apps/TEST_test/admin/install/jtfictx.sh

script returned:

****************************************************

jtfictx.sh started at Thu Mar 30 15:28:49 IST 2017

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Mar 30 15:28:49 2017

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-11000: invalid keyword SYNC

ORA-06512: at "SYS.DBMS_SQL", line 1120

ORA-06512: at line 96

CAUSE

The JTF_AMV_ITEMS_URL_CTX index is invalid for some reason.

SOLUTION

The simple fix for this is to drop and recreate the index.

1:- Back-up your database
2:- Rebuild the JTF_AMV_ITEMS_URL_CTX index.

a. DROP INDEX JTF_AMV_ITEMS_URL_CTX FORCE
b. sqlplus uname/pwd @jtfiaibu.sql JTF JTF APPS

3:- Re-Run Autoconfig

4:- If the above command does not compile the index correctly then please retry the process again running step 2b as:

sqlplus uname/pwd @jtfiaibu.sql JTF JTF APPS

5:- Migrate the solution as appropriate to other environments.

References:

"Jtfictx.sh" Failed During Autoconfig On Application Tier, ORA-29874, DRG-10595 (Doc ID 1271186.1)
Oracle Text may not include Theme Functionality after Installation (Doc ID 262701.1)