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 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 Moduel.
 
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


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 Custom Top register successfully reset the custom schema password using FNDCPASS.

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

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

  3. I was married at 32 and immediately tried to get pregnant. When I was unable to conceive I had blood tests for fertility and was told that I had an FSH (follicle stimulating hormone) of 54 and would not be able to have children. Even though the doctors knew that I had been diagnosed with Hashimoto’s thyroiditis since age 25, no one bothered to check my thyroid levels. my TSH was measured at .001. My Synthroid dosage was lowered. a friend advise me to contact a spiritualist who help with fertility with his medicine, i collected his contact and explain my situation to him he prepared for me a herbal medicine which i took as describe by him. became pregnant very quickly, I had a successful pregnancy. I have my baby august 2017. to get pregnant at age 35 with my 2nd child in september 2019, thank you sir , this is his email contact if you require his help [email protected] or Facebook at priest.babaka

    Reply

Leave a Comment