Deploy Webutil in Oracle EBS R12
Author: Nolem Lin
MSN: nolem_lin@hotmail.com
Creation Date: 2010/09/17
Document Ref: None
Version: Draft 1A
Testing environment: Sun SPARC Solaris 10 , Redhat enterprise server 5.3
Goal: Deploy Webutil in
Oracle E-Business Suite
Release 12
Introduction
I am newbie in EBS , but use form developer for a long time , on 2010/08/03 , I log SR in My Oracle Support , and OCS response until 2010/09/07, but reply me such useless information (my request is not in OCS support policy), I am really disappointed with OCS , so I try to solve my question by myself , and I succssed , now share with all, if you want to share it with others, Please keep author information, thanks.
Deploy method :
==================================================================
1. enable your ebs‘s
ap server environment,
ex: my instance : test1 , hostname :f4800
ex:. /ebs/test1/inst/apps/test1_f4800/ora/10.1.2/test1_f4800.env
. /ebs/test1/apps/apps_st/appl/test1_f4800.env
2.run adtmplreport
to get all autoconfig file template reference
applmgr@F4800 # adtmplreport.sh contextfile=$CONTEXT_FILE
#####################################################################
Generating Report .....
#####################################################################
For details check log file:
/ebs/test1/inst/apps/test1_f4800/admin/log/09162156.log
3. read log file to check
file we must customize
a. find appsweb.cfg
ex:
TEMPLATE FILE: /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/forms_web_1012_cfg.tmp
TARGET FILE: /ebs/test1/inst/apps/test1_f4800/ora/10.1.2/forms/server/appsweb.cfg
b.find txkGenDefaultEnv
ex:
TEMPLATE FILE: /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/txkGenDefaultEnv.tmp
TARGET FILE: /ebs/test1/inst/apps/test1_f4800/admin/install/txkGenDefaultEnv.pl
4. make EBS customization and webutil config file directory
mkdir –p /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/custom
mkdir –p /ebs/test1/inst/apps/test1_f4800/ora/10.1.2/forms/webutil
5. copy 3 file of template above to our custom file
a. cp –i /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/forms_web_1012_cfg.tmp /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/forms_web_1012_cfg.tmp
b. cp –i /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/txkGenDefaultEnv.tmp /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/txkGenDefaultEnv.tmp
c. cp –i $OA_HTML/US/appsbase.htm $OA_HTML/US/appsbaseCustom.htm
6. edit 2 customize file add webutil deploy config
a. vi /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/forms_web_1012_cfg.tmp
i. add our webutil config ex:
;Customization webutil config
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
WebUtilArchive=/OA_JAVA/oracle/apps/fnd/jar/frmwebutil.jar,/OA_JAVA/oracle/apps/fnd/jar/jacob.jar
ii. find %OA_HTML%/US/appsbase.htm
config and modify it to our custom .htm
baseHTML=%s_oahtml%/US/appsbaseCustom.htm
baseHTMLJInitiator=%s_oahtml%/US/appsbaseCustom.htm
b.vi /ebs/test1/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/txkGenDefaultEnv.tmp
i. find WEBUTIL_CONFIG and modify it to our custom path ex:
#Customization webutil env parameter
WEBUTIL_CONFIG=/ebs/test1/inst/apps/test1_f4800/ora/10.1.2/forms/webutil/webutil.cfg
7. edit your customization webutil.cfg
a. find install.syslib.location and modify to reference to your ebs server download URL .ex:
install.syslib.location=http://f4800.gbe.com.tw:8005/OA_JAVA/oracle/apps/fnd/jar
b. if you want to deploy your version jacob.dll or Customization library , add your own ex:
install.syslib.0.7.1=jacob.dll|106496|1.10.1|true
install.syslib.0.7.2=mycustom.dll|76686|1.0|true
c. modify your download and upload directory ,and enabled file transfer
transfer.database.enabled=FLASE => transfer.database.enabled=TRUE
transfer.appsrv.enabled=FALSE=> transfer.appsrv.enabled=TRUE
transfer.appsrv.read.1=/mydownload
transfer.appsrv.write.1=/myupload
8. upload your webutilfiles to server path that we set
a. upload jacob.dll, JNIsharedstubs.dll, d2kwut60.dll, frmwebutil.jar, jacob.jar to $OA_JAVA/oracle/apps/fnd/jar
b.upload webutil.cfg to the path that you set in WEBUTIL_CONFIG
cp webutil.cfg /ebs/test1/inst/apps/test1_f4800/ora/10.1.2/forms/webutil/webutil.cfg
9. edit your customization appsbaseCustom.htm to add webutil reg
a. find comment // JAR files and declare your webutilparameter
//Custom Webutil Jar file
var xwebutiljarfile = "%WebUtilArchive%"
var xWebUtilLogging = "%WebUtilLogging%"
var xWebUtilLoggingDetail = "%WebUtilLoggingDetail%"
var xWebUtilErrorMode = "%WebUtilErrorMode%"
var xWebUtilDispatchMonitorInterval = "%WebUtilDispatchMonitorInterval%"
var xWebUtilTrustInternal = "%WebUtilTrustInternal%"
var xWebUtilMaxTransferSize = "%WebUtilMaxTransferSize%"
b. find string var xarchive = xajarfile + xujarfile + xbjarfile + xcjarfile + xdjarfile;
change it to
var xarchive = xajarfile + xujarfile + xbjarfile + xcjarfile + xdjarfile + "," + xwebutiljarfile
c. find string var xmacarchive = xmacbjarfile + xmaccjarfile + xmacdjarfile + xujarfile
change it to
var xmacarchive = xmacbjarfile + xmaccjarfile + xmacdjarfile + xujarfile + "," + xwebutiljarfile