Custom Top creation in Oracle EBS R12.2

I'm using Oracle EBS R12.2.7 and below are the steps I followed to create custom top. Here I used the name xxerp for my custom top,custom schema and the tablespace for this schema. 

1.Download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice" from My Oracle Support.

2.Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.

3.Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use "xxerpprod.txt".

4.Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will use "xxerpterr.txt".

5.Open newprods.txt in a text editor.

a.Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (i.e. keep the case sensitivity).

b.Modify other values as below.

6.Create a custom schema,tablespace for that schema and provide the required grants to that schema.

7.Edit newprods.txt file and change the default_tspace to APPS_TS_TX_DATA. 

8.Edit xxerpprod.txt file Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity). 

      a.Change all references of prodid 278 to your own application ID. You can run the following SQL to find out if your selected custom application ID number is available or not. Here I've used the port 50005.

select decode(count ,0, 'Selected number is Available', 'Selected number already in use') Status, &&enter_custom_applID selected_number from (select count(*) as count from (select 'x' from fnd_oracle_userid where oracle_id= &&enter_custom_applID union select 'x' from fnd_application where application_id= &&enter_custom_applID ) );

9.Open xxerpterr.txt in a text editor and Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity).

     a.Change the text "Oracle_Support_Diagnostic_Tools" to "xxerp_custom_app".

10.Copy the following text files to the $APPL_TOP/admin directory.

11.Change directory to the admin directory under $APPL_TOP and run adsplice

12.When prompted for location, name of AD Splicer control file and to regenerate the environment file accept the default answers.

Once adsplice completed successfully, follow the below steps to confirm successful creation of custom top.

select * from fnd_application where application_short_name = 'XXERP';

select * from fnd_product_installations where APPLICATION_ID = 50005;

select * from dba_users where username = 'XXERP';

All these above queries should return only one row.

Logout and login to a new session and confirm the below to ensure that the environment file is regenerated properly with the entry of our custom top.

Have created the custom top successfully.

Ref : Creating a Custom Application in Oracle E-Business Suite Release 12.2 (Doc ID 1577707.1)

                      ****************************நன்றி****************************