OATM Generate Migration Commands Fails With Ora-20001: Tablespace APPS_TS_TX_IDX Does Not Exist

(Doc ID 1375456.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Application Object Library - Version to 12.1.3 [Release 11.5 to 12.1]
Oracle Applications Technology Stack - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
The Oracle Applications Tablespace Model (OATM) migration utility fails following an upgrade to 11.5.10+


Following an upgrade to 11.5.10+, when trying to run the Oracle Applications Tablespace Model (OATM) it fails with the following errors:

ORA-20001: Tablespace APPS_TS_TX_IDX does not exist.
ORA-06512: at "APPS.FND_TS_MIG_UTIL", line 98
ORA-06512: at "APPS.FND_GEN_MIG_CMDS", line 893
ORA-06512: at "APPS.FND_GEN_MIG_CMDS", line 2108
ORA-06512: at "APPS.FND_GEN_MIG_CMDS", line 2144
ORA-06512: at line 18


Issue caused by failing to implement changes to the database init<SID>.ora


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