How to configure webutil in forms 12.2.1.4

 

1.       Create webutil schema

SQL> create user webutil identified by Concept_ora1;

SQL> grant dba to webutil;

 

Login to application server, and connect to sqlplus

 Cd D:\app\oracle\product\12.2.1.4\bin

D:\weblogic\Middleware\12.2.1.4\bin>sqlplus webutil@PRDPDB

 

SQL> @D:\app\oracle\product\12.2.1.4\forms\create_webutil_db.sql

SQL> create public synonym webutil_db for webutil.webutil_db;

 

2.       Download the jacob version 1.2 and unzip it in the directory of your choice - https://github.com/freemansoft/jacob-project/releases

 

unzip jacob-1.20.zip

cd jacob-1.20

copy Jacob.jar D:\app\oracle\product\12.2.1.4\forms\java\

copy jacob-1.20-x86.dll D:\app\oracle\product\12.2.1.4\forms\webutil\win32

copy jacob-1.20-x64.dll D:\app\oracle\product\12.2.1.4\forms\webutil\win64

 

edit below file

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\components\FORMS\instances\forms1\bin\sign_webutil.bat

 

replace “D:\app\oracle\product\12.2.1.4\jdk\bin” with “D:\app\oracle\product\12.2.1.4\oracle_common\jdk\bin”

and edit following parameters

SET JAR_KEY_PASSWORD=xyz123

SET KEYSTORE_PASSWORD=xyz123

SET VALIDDAYS=3600

 

Use sign_webutil.bat to sign Jacob.jar using following command:

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\components\FORMS\instances\forms1\bin\sign_webutil.bat D:\app\oracle\product\12.2.1.4\forms\java\jacob.jar

 

3.       Download webutil_demo form from the following link and place the webutil_demo.fmb form in the path D:\app\oracle\product\12.2.1.4\forms

https://www.dropbox.com/s/mdkhjh7997r8arh/webutil_demo.fmb?dl=0

 

4.     Compile webutil.pll to create webutil.plx

 

Open forms compiler

D:\app\oracle\product\12.2.1.4\bin\frmcmp.exe

Navigate to path D:\app\oracle\product\12.2.1.4\forms

 and compile webutil_demo.fmb

Double click on webutil_demo.fmb and connect to database and compile forms.

 

1.       Make the following modifications to the [webutil] configuration of the formsweb.cfg file,

Edit formsweb.cfg in

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

 

In [default]

section search for archive and add Jacob.jar , frmwebutil.jar

archive=frmall.jar,frmwebutil.jar,jacob.jar

[wutil]

WebUtilArchive=frmwebutil.jar,jacob.jar

baseSAAfile=webutilsaa.txt

archive=frmall.jar,jacob.jar,frmwebutil.jar

form=D:\app\oracle\product\12.2.1.4\forms\webutil_demo.fmx

WebUtilMaxTransferSize=24573

 

5.       Modify webutil.cfg file

In following location D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\components\FORMS\instances\forms1\server

 

Change following parameters

 

transfer.database.enabled=FALSE

to

transfer.database.enabled=TRUE

 

transfer.appsrv.enabled=FALSE

to

transfer.appsrv.enabled=TRUE

 

transfer.appsrv.accessControl=TRUE

to

transfer.appsrv.accessControl=FALSE

 

 

Also change following ,

From

install.syslib.0.0.7.1=jacob-1.18-M2-x86.dll|167424|1.18-M2|true

To

install.syslib.0.0.7.1=jacob-1.20-x86.dll|189440|1.20|true

 

From

install.syslib.0.1.7.1=jacob-1.18-M2-x64.dll|204800|1.18-M2|true

To

install.syslib.0.1.7.1=jacob-1.20-x64.dll|227328|1.20|true

 

 transfer.appsrv.read.1=c:\temp

#List transfer.appsrv.write.<n> directories

transfer.appsrv.write.1=c:\temp

Note: verify name, size  ,version of jacob-1.18-M2-x64.dll and jacob-1.18-M2-x86.dll. 

 

Edit default.env in

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

and add following in CLASSPATH variable in following location

 CLASSPATH= D:\app\oracle\product\12.2.1.4\forms\java\jacob.jar

 

Open webutil form from browser.

Note: Make sure end user has jre 1.8 32bit installed to open the form window without any issue.

URL: http://csapp2:9001/forms/frmservlet?config=wutil

 

Provide username:webtuil

Password: xyz123

Database: PRDPDB

 

If DOWNLOAD/UPLOAD features don’t work,

open the webutil_demo.fmb through forms compiler and check program units section.

Look for DOWNLOAD_AS and UPLOAD_AS section and make sure its path is pointing to c:/temp path and temp directory exists inside C:/