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 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle Applications Technology Stack - Version 11.5.10.2 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+


Symptoms

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

Changes

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

Cause

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