Here we going to discuss 'Custom top creation in oracle ebs r12.2'
Step 1:- Creating Custom TOP/Application using AD Splice
To 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.
$ adsplice
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.
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 registor successfully reset the custom schema password using FNDCPASS.
15 comments:
Hi.Can we follow same method in EBS R12.1 as well. Thanks
I think it will work for both R12.1. and R12.2. I have tested it on R12.2. Requesting you to test in on test instance first.
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 babaka.wolf@gmail.com or Facebook at priest.babaka
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. custom basketballs
There is so much in this article that I would never have thought of on my own. Your content gives readers things to think about in an interesting way. Thank you for your clear information. get more info
I found your this post while searching for some related information on blog search...Its a good post..keep posting and update the information. հնդկական վիզա առցանց
Wow, this is fascinating reading. I am glad I found this and got to read it. Great job on this content. I liked it a lot. Thanks for the great and unique info. ویزای هند به صورت آنلاین
Wow, this is fascinating reading. I am glad I found this and got to read it. Great job on this content. I liked it a lot. Thanks for the great and unique info. Visto medico per l'India
I discovered your blog post site online and check a few of your early posts. Always keep within the really good operate. I additional up your RSS feed to my MSN News Reader. Looking for forward to reading more from you later on!
visa de canadá de ee.
I really loved reading your blog. It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.Thanks alot! check this link
Thanks for your comment. We are glad that you found this content valuable. Best to you!
Thanks for your comment. We are glad that you found this content valuable. Best to you!
Thanks so much for your comment. We hope that you found it useful.
Great! Mr. Khatri. We are thankful that you found this post useful. Best of luck!
Thanks for your considered comment.
I’m glad that you found this post informative and helpful.
Best to you!
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.