Adsplice in Oracle Apps 11i

In oracle apps, Adsplice is an ad utility which is used to add off-cycle products to oracle apps i.e. products released between maintenance packs.

IDownload the product patch which contains information about the new product,adplice control file and other associated files. Go through the readme and apply pre-reqs if any. Now for using adsplice there is a control file newprods.txt. A typical newprods.txt  looks like->

product=zsa
base_product_top=*APPL_TOP*
oracle_schema=zsa
sizing_factor=100
main_tspace=ZSAD
index_tspace=ZSAX
temp_tspace=TEMP
default_tspace=ZSAD

If we are using OFA tablespace model then we need to change the last 4 parameters else for OATM it is optional.

One can then copy it in $APPL_TOP/admin and run adsplice from applmgr user and follow the prompts.Then we can verify that product is correctly spliced or not using adutconf.sql (AD Configuration report). We need to logout and login again so that the new environment is set.We can then verify that new <PROD>_TOP environment variable is set and  need to apply the patches for newly added product