Autoconfig fails with DRG-10502: Index JTF.JTF_AMV_ITEMS_URL_CTX


Autoconfig failing with the below error:


Executing script in InstantiateFile:
script returned:
**************************************************** started at Fri Jul 7 18:32:47 UTC 2023

SQL*Plus: Release - Production on Fri Jul 7 18:32:48 2023

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

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
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 186
ORA-06512: at "CTXSYS.CTX_DDL", line 1231
ORA-06512: at "CTXSYS.AD_CTX_DDL", line 336
ORA-06512: at line 96
ORA-06512: at line 96


1. Connect to Mid-tier node to directory: $JTF_TOP/patch/115/sql

2. sqlplus apps/apps_pwd

@jtfiimt.sql jtf jtf
@jtfiaitd.sql jtf jtf
@jtfiaitn.sql jtf jtf
@jtfiaitt.sql jtf jtf
@jtfiappr.sql apps
@jtfiaibu.sql jtf jtf apps
@jtfntsci.sql jtf jtf
@jtftkimi.sql jtf jtf

3. Verify all status columns are with VALID status
select index_name, domidx_status, domidx_opstatus, funcidx_status, status
from dba_indexes where index_type='DOMAIN' and index_name like 'JTF_AMV_ITEMS%';

4. Rerun autoconfig.

If you like please follow and comment