R12 E-Business Suite Autoconfig Fails On Script jtfictx.sh With Errors ORA-29874: warning in the execution of ODCIINDEXALTER routine And DRG-100595 and DRG-11000 After An Upgrade To 12.1.3 And RDBMS

(Doc ID 2223844.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.


E-Business Suite R12 Applications DBA, Upgrade Related issues



After an upgrade from R12.0.6 to R12.1.3 including a database migration from to,  AutoConfig fails with the following error:

jtfictx.sh started at Mon Jan 16 09:00:00 2017

SQL*Plus: Release - Production on Mon Jan 16 09:00:00 2017

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-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-11000: invalid keyword SYNC
ORA-06512: at "SYS.DBMS_SQL", line 1120
ORA-06512: at line 96

Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
jtfictx.sh exiting with status 1
.end std out.
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

  AutoConfig could not successfully execute the following scripts:
  Directory: /prodapps/PROD/inst/apps/UPDB8_oupapp/admin/install
  jtfictx.sh INSTE8_PRF 1

AutoConfig is exiting with status 1

The issue can be reproduced at will with the following steps:
1. Upgrade R12.0.6 to R12.1.3
2. Upgrade database from to
3. Run AutoConfig on DB Tier and then run AutoConfig on AP Tier.


 Upgraded EBS from R12.0.6 to R12.1.3 and Database from to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms