Webutil Configuration steps for Oracle Fusion Middleware Forms 11g R2

There are some additional steps you will need to accomplish in order to make confugration work properly.

  • Download Jacob Package 1.14.3 for (11.1.2.0).
  • URL: https://sourceforge.net/projects/jacob-project/files/jacob-project/1.14.3/jacob-1.14.3.zip/download
  • Now Place the Jacob.jar  into /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java Directory
  • Place Jacob-1.14.3-x64.dll into/weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win64
  • Place Jacob-1.14.3-x86.dll into/weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win32

Follow the steps mentioned below to create Webutil user in Database:

Step 1:

  • Login from SYS

Step 2:

  • CREATE USER Webutil IDENTIFIED BY Webutil

Step 3:

  • Grant connect, resource to Webutil

Step 4:

  • Connect Webutil/Webutil

Step 5:

  • Runsql  from C:/Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/ run create_webutil_db.sql

Step 6:

  • Create public synonym webutil_db for webutil.webutil_db;

Step 7:

  • Connect sys as sysdba

Step 8:

  • Grant execute on webutil_db to public;

Step 9:

  •  Edit formweb.cfg:
  • Path: C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config\formweb.cfg (edit formweb.cfg)

Archive= frmall.jar, frmwebutil.jar

  • (Edit the webutil section)

 

[Webutil]

WebUtilArchive=frmwebutil.jar, jacob.jar

Archive=frmall.jar, frmwebutil.jar, jacob.jar

WebUtilLogging=on

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

archive=frmall.jar

lookAndFeel=oracle

Step 10:

  • Edit webutil.cfg file:
  • Path: C:\Oracle\Middleware\Oracle_FRHome1\forms\templates\config\webutil.cfg (webutil.cfg change the following entries)

transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE

Step 11:

  • Edit default.env file:
  • Path: C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config\default.env (default.env change the following entries)
  • In FORMS_PATH add these path:

FORMS_PATH=C:\Oracle\Middleware\asinst_1\FormsComponent\forms;

C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil

  • In CLASS_PATH add these path:

CLASSPATH=C:\Oracle\Middleware\Oracle_FRHome1\forms\java\frmwebutil.jar;

C:\Oracle\Middleware\Oracle_FRHome1\forms\java\frmall.jar;

C:\DevSuiteHome_1\forms\java\jacob.jar

  • In WEBUTIL_CONFIG add these path:

WEBUTIL_CONFIG=C:\Oracle\Middleware\asinst_1\config\FormsComponent\forms\server\webutil.cfg

  • At the end add path:

FORMS=C:\Oracle\Middleware\Oracle_FRHome1\forms

Step 12:

Regenerate the webutil.pll using following command:

frmcmp module=C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil.pll userid=webutil/webutil module_type=library compile_all=yes;

Step 13:

Now:

  • Open Oracle forms builder 11g Create a new form,a new block & a canvas.
  • Attach webutil.pll on Navigator—> Attached Libraries in Forms.
  • Click file—>open—>C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil.olb click webutil.olb file and it will create some entries in object library (in navigator)
  • Click on object libraries there u have webuitl, right click on webutil chose option object library.
  • There you have two webutil objects.
  • Drag webutil object to object group (in navigator window) subclass it.

The Very 1st Impression On Golden Tiger