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