Autoconfig Completed With Error Jtfictx.sh INSTE8_PRF 1

ERROR

When attempting to run the autoconfig in apps Tier its completed with error jtfictx.sh INSTE8_PRF 1.

ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10502: index JTF.JTF_AMV_ITEMS_URL_CTX does not exist
ORA-06512: at “CTXSYS.DRUE”, line 160
ORA-06512: at “CTXSYS.CTX_DDL”, line 1119
ORA-06512: at “CTXSYS.AD_CTX_DDL”, line 336
ORA-06512: at line 96

 

 

SOLUTION

1. Drop the index JTF_AMV_ITEMS_URL_CTX from APPS and JTF schema and then recreate it under JTF schema.

Before dropping this index from apps schema Please make sure to have a valid backup then drop the index JTF_AMV_ITEMS_URL_CTX from APPS then with same code you can re-create in JTF schema or  using  “jtfiaibu.sql” script you can re-create

2) Run the following:

$ cd $JTF_TOP/patch/115/sql/
$ sqlplus apps/apps @jtfiimt.sql JTF JTF NULL NULL

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

NOTE:
Script jtfiimt.sql will create the JTF Text index preferences for the following indexes :
JTF_AMV_ITEMS_DESC_CTX
JTF_AMV_ITEMS_NAME_CTX
JTF_AMV_ITEMS_TEXT_CTX
JTF_AMV_ITEMS_URL_CTX
JTF_TASKS_TL_IM

Script jtfiaibu.sql will drop and recreate the “JTF_AMV_ITEMS_URL_CTX” Intermedia Text index.

Rerun Autoconfig.  “jtfictx.sh” should complete without error.