How to register custom top in oracle apps r12

by

Here we going to discuss ‘How to register custom top in oracle apps r12‘. Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use “xxcustomzprod.txt”.

How to register custom top in oracle apps r12.

We will follow below steps to register/create custom top in r12.2.

Step 1: – Creating Custom TOP/Application using AD Splice

 
To register custom top application, we need to download patch 3636980 from Oracle support.
  • copy three *.txt file from 3636980/izu/admin to temporary directory.
  • Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use “xxcustomzprod.txt”.
  • Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will use “xxcustomterr.txt”.
  • Open newprods.txt using vi editor and make changes of izu with your CUSTOM Module.
 
product=izu
base_product_top=*APPL_TOP*
oracle_schema=izu
sizing_factor=100
main_tsp=USER_DATA
index_tsp=USER_IDX
temp_tsp=TEMP
default_tsp=USER_DATA
 
 
Open xxcustomprod.txt using vi editor and make changes of IZU with Custom Module.
 
Open xxmzterr.txt using vi editor and change all
 
cizu     Oracle_Support_Diagnostic_Tools
 
as 
 
cxxcustom xxcustom_custom_app
 
Change the text “Oracle_Support_Diagnostic_Tools” to be “xxcustom_custom_app“.
 
Copy the following text files to the $APPL_TOP/admin directory:
 
newprods.txt
xxcustomterr.txt
xxcustomprod.txt
 
 

Step 2:- Now Change directory to the admin directory under $APPL_TOP.

Run AD Splice.
 
 
 
Please enter the directory where your AD Splicer control file is located.
 
The default directory is [/data03/1225_data/1225apps/fs1/EBSapps/appl/admin] : 
 
Please enter the name of your AD Splicer control file [newprods.txt] : newprods.txt
 
Processing file /data03/1225_data/1225apps/fs1/EBSapps/appl/admin/newprods.txt…
 
Loading information for product ‘XXCUSTOM’…
 
Warning: Because the database is in new tablesp mode, AD Splicer is ignoring the tablesp settings in
 
your control file!
 
Successfully read file /data03/1225_data/1225apps/fs1/EBSapps/appl/admin/newprods.txt.
 
Verifying localizations…
 
Validating inter-product dependency information…
 
Re-organizing product information lists…
 
Adding new languages into FND_LANGUAGES…
 
begin fnd_languages_pkg.add_language; end;
 
Connecting to SYSTEM……Connected successfully.
 
Creating ORACLE usernames for products…
 
AD Splicer is creating or updating the ORACLE username XXCUSTOM
 
with password ***** for xxcustom custom app tables.
 
alter user XXCUSTOM identified by *****

New product XXCUSTOM spliced. Use FNDCPASS to change the password.
 
alter user XXCUSTOM quota unlimited on APPS_TS_ARCHIVE
 
alter user XXCUSTOM quota unlimited on APPS_TS_INTERF
 
alter user XXCUSTOM quota unlimited on APPS_TS_MEDIA
 
alter user XXCUSTOM quota unlimited on APPS_TS_NOLOGGING
 
alter user XXCUSTOM quota unlimited on APPS_TS_QUEUES
 
alter user XXCUSTOM quota unlimited on APPS_TS_SEED
 
alter user XXCUSTOM quota unlimited on APPS_TS_SUMMARY
 
alter user XXCUSTOM quota unlimited on APPS_TS_TOOLS
 
alter user XXCUSTOM quota unlimited on APPS_TS_TOOLS
 
alter user XXCUSTOM quota unlimited on APPS_TS_TX_DATA
 
alter user XXCUSTOM quota unlimited on APPS_TS_TX_IDX
 
alter user XXCUSTOM default tablesp APPS_TS_TX_DATA
 
alter user XXCUSTOM temporary tablespace TEMP
 
Recording ADSPLICE action for product: xxcustom
 
Do you wish to regenerate your environment file [Yes] ? Yes
 
Checking if AutoConfig is enabled….
 
Running AutoConfig on : All products …
 
Configuring templates from all of the product tops…
 
        Configuring AD_TOP……..COMPLETED
        Configuring FND_TOP…….COMPLETED
        Configuring ICX_TOP…….COMPLETED
        Configuring MSC_TOP…….COMPLETED
        Configuring IEO_TOP…….COMPLETED
        Configuring BIS_TOP…….COMPLETED
        Configuring CZ_TOP……..COMPLETED
        Configuring SHT_TOP…….COMPLETED
        Configuring AMS_TOP…….COMPLETED
        Configuring CCT_TOP…….COMPLETED
        Configuring WSH_TOP…….COMPLETED
        Configuring CLN_TOP…….COMPLETED
        Configuring OKE_TOP…….COMPLETED
        Configuring OKL_TOP…….COMPLETED
        Configuring OKS_TOP…….COMPLETED
        Configuring CSF_TOP…….COMPLETED
        Configuring IBY_TOP…….COMPLETED
        Configuring JTF_TOP…….COMPLETED
        Configuring MWA_TOP…….COMPLETED
        Configuring CN_TOP……..COMPLETED
        Configuring CSI_TOP…….COMPLETED
        Configuring WIP_TOP…….COMPLETED
        Configuring CSE_TOP…….COMPLETED
        Configuring EAM_TOP…….COMPLETED
        Configuring GMF_TOP…….COMPLETED
        Configuring PON_TOP…….COMPLETED
        Configuring FTE_TOP…….COMPLETED
        Configuring ONT_TOP…….COMPLETED
        Configuring AR_TOP……..COMPLETED
        Configuring AHL_TOP…….COMPLETED
        Configuring IES_TOP…….COMPLETED
        Configuring OZF_TOP…….COMPLETED
        Configuring CSD_TOP…….COMPLETED
        Configuring IGC_TOP…….COMPLETED
 
AutoConfig completed successfully.
 
Errors and warnings are listed in the log file
 
/data03/1225_data/1225apps/fs1/EBSapps/appl/admin/PHASE1/log/adsplice.log
 

Step 3:- Verify the Custom Product.

Finally verify the Custom Product in the Database after register custom top in oracle apps r12.

SQL>select * from fnd_application where application_short_name = ‘XXCUSTOM’;

Go under $CUSTOM_TOP and check  below directory created.

admin   log    mesg    out    sql 

Once completed custom top creation in oracle ebs r12, need to reset the custom schema password using FNDCPASS.

$FNDCPASS apps/<apps_password> 0 Y system/<system_password> USER XXCUSTOM <new apps passwd>
 
 
Useful Posts: –
 

16 thoughts on “How to register custom top in oracle apps r12”

Leave a Comment