ADSPLICER - ORA-00959: tablespace 'APPS_TS_TOOLS' does not exist

ORA-00959: tablespace 'APPS_TS_TOOLS' does not existt
This will occurred while executing the SQL statement:

"alter user IZU quota unlimited on APPS_TS_TOOLS"

When u execute the adsplice it check the availablety of APPS_TS_TOOLS Tabalespace .

APPS_TS_TOOLS is used to store the objects for several tools components like SSO , OID , Portal , Discoverer, etc

Before using AD Splice you are required to add this new Tablespace for the new products that are going to be added. If you migrated to the Oracle Applications new Tablespace model you would require to create a new Tablespace APPS_TS_TOOLs manually or you can  use Tablespace creation migration utility before using AD Splicer.

To check the availability of this  tablespace  run:

SQL:>select tablespace_name from dba_tablespaces
          where tablespace_name like 'APPS_TS%' order by 1;

TABLESPACE_NAME
APPS_TS_ARCHIVE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_TX_INTERFACE

9 rows selected.


Then  create the New Tablespace  APPS_TS_TOOLS :

SQL:>connect as SYSTEM

SQL:>CREATE TABLESPACE APPS_TS_TOOLS
DATAFILE '/*****/****/APPS_TS_TOOLS01.dbf'
SIZE 100 M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024 K
SEGMENT SPACE MANAGEMENT AUTO

ADSPLICER

AD Splicer is an AD utility which allows to register off-cycle products which are not released along with base product release of Oracle Applications. 

After using ADSplicer, AD utilities like AD Patch will recognize this as a valid Oracle Application product. This  will create new product top and creates a new environment setup.

Off-cycle products are generally released as patches. IZU is the one of the off-cycle product patches which is used to install the  Oracle Support
Diagnostics tool product

Note: In a multi-node environment ADSPLICER should be used on all the APPL_TOPs