The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files so the EBS can work properly. When you want to add customizations the a template, you place that template in the ‘custom’ directory in the $product_top/template, and autoconfig uses this custom template instead of the default Oracle template…
But how do you know which templates are customized ?
I ran into the following script in the $AD_TOP/bin directory…. adtmplreport.sh
Use the following syntax
./adtmplreport.sh contextfile= ‘path to your contextfile’
And you get a report with all the templates used by autoconfig, the target directory and if there is a custom version of the template. Very nice script…
So for example the adovars.env file and its custom version…
TEMPLATE FILE : /opt/software/applmgr/EBS/appl/ad/11.5.0/admin/template/adovars_ux.env
TARGET FILE : /opt/software/applmgr/EBS/appl/admin/adovars.env
TEMPLATE FILE : /opt/software/applmgr/EBS/appl/ad/11.5.0/admin/template/APPLSYS_ux.env
CUSTOM TEMPLATE : /opt/software/applmgr/EBS/appl/ad/11.5.0/admin/template/custom/APPLSYS_ux.env
TARGET FILE : /opt/software/applmgr/EBS/appl/EBS_ebs-p01.env
![Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005")
This is an excellent stuff
Hi Bas thanks a lot. i am using lot of posts on this site in my work
about myself
Name:Hitendra Santosh
Job:Consultant- Apps DBA
Company:Intelligroup
Country:India
Great post, Bas! I didn’t know about that script. I will definitely use this in the future. Thanks