Webutil Configuration - Oracle Forms&Reports Application 12c

OLE, Without OLE ( Linux/Unix/Solaris/Windows )

#oracle12c,#webutil, #12c, #forms,#weblogic,#reports,#application,#customerp



Webutil Configuration on Oracle 12c


1) We know the Webutil is a very powerful utility provided by Oracle

by using Webutil we can achieve so many things which help you in creating a very user-friendly application.


2) Simple to interact with the client system.


3) 3-tier application Oracle12c forms & reports with WebLogic to provides you with more security.


Webutil contains an inbuilt object library(webutil.olb) and a Pl/SQL library(webutil.pll) and a database package webutil_DB which we have to create on the database.


4) some of the uses of webutil are below


*Getting the information from the client system like IP address, username, system name, OS type and etc….

*Used in the transfer the file from the server to the client and vice-versa.

*Reading the image from the client system and much more.

*Working with images on the application is very simple now using webutil.

*It can be used in forms for excel file (.xls, .xlsx, .csv,…..) export and import through the forms etc…

I have used this on various programs like auto weight machine integration with the forms, for webcam integration, signature pad integration, using mac address for security, barcode printing, excel generation through forms etc...


4) Webutil configuration types.

* Webutil without ole2.

* Webutil with ole2.


if you have the requirement of ole2 then go for configuration with ole2.


In most of 6i to 10G, many clients had used ole2 in forms for various purpose.

Ole2 invoke Microsoft application like excel word etc.... and perform various operations like write/read/append/etc…



4-a) Webutil configuration without ole2 or Normal configuration.

steps to configure normal webutil


4-a1) To configure create the package WEBUTIL_DB.

this package is provided by the Oracle and you can find the package on forms directory of your oracle_home\forms\create_webutil_db.sql

e.g “E:\Oracle\Middleware\Oracle_Home\forms\create_webutil_db.sql”.


Run the sql file open this file and copy the package and create the package in the database or run this sqlfile using sys user using prompt.


4-a2) Change in webutil.cfg file.

The path for webutil.cfg is

E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\server

in this folder you will see the file webutil.cfg

comment the below lines using "# "shown in the below image.



Then enter the drive name on which you want to perform webutil operations.

Set TRUE on transfer.database.enabled, transfer.appsrv.enabled, transfer.appsrv.accesscontrol. See the below image for this.





Step 5) Then compile the webutil.pll

The path for webutil.pll is E:\Oracle\Middleware\Oracle_Home\forms\

· Then copy the webutil.plx in your execute folder(where you have .fmx files).

· Then restart the wls_forms and use the powerful utility the webutil.



4-a2) Configuring the webutil with ole2.

Do all the changes above mentioned.

To configure the webutil with ole2 firstly uncomment the below lines in webutil.cfg file by removing # from these lines.

we have commented these lines for normal configuration but for this, we have to uncomment these lines.




Then do the below steps:-


*Download the Jacob.jar zipped file from oracle site or from the below link Remember the only version of jacob.jar supports in Oracle 12c is Jacob-1.18-M2 https://sourceforge.net/projects/jacob-project/files/jacob-project/1.18-M2/. Unzip the jacob.jar When you will unzip the jacob.jar zip you will see below files in it.


docs

Jacob-1.18-M2-x64.dll

Jacob-1.18-M2-x86.dll

jacob.jar

LICENSE.TXT

README.txt


copy Jacob-1.18-M2-x64.dll in E:\Oracle\Middleware\Oracle_Home\forms\webutil\win64


copy jacob-1.18-M2-x86.dll in E:\Oracle\Middleware\Oracle_Home\forms\webutil\win32


Edit extensions.jnlp file, making the following change. Path of extensions.Jnlp file is E:\Oracle\Middleware\Oracle_Home\forms\java From

this: <!--<jar href="jacob.jar"/>--> To this : <jar href="jacob.jar"/>


Now we have to Sign the jar file To sign the jar file we have to create the keysotre file. To create Keystore file open command prompt as administrator.

Then cd E:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin

Use the below command to create the Keystore file.


E:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin>keytool.exe -genkey -alias myapp -keyalg RSA -keystore .keysotre_myapp Press Enter.


here .keystore_myapp is the name of our Keystore file.

Then it will ask you for some parameter like.


Enter Keystore password:

Re-enter new password:

What is your first and last name?

[Unknown]: Dainik Jagran

What is the name of your organizational unit?

[Unknown]: it

What is the name of your organization?

[Unknown]: JPL

What is the name of your City or Locality?

[Unknown]: Kanpur city

What is the name of your State or Province?

[Unknown]: up

What is the two-letter country code for this unit?

[Unknown]: in

Is CN=dainik Jagran, OU=it, O=jpl, L=kanpur city, ST=up, C=in correct?

[no]: yes

Enter key password for <myapp>

(RETURN if same as Keystore password):

Re-enter new password:

Enter the password and after

give all the parameters as above mentioned.



A Keystore file named .keystore_myapp will be created on the below directory

E:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin>


Then we will sign the jacob.jar using jarsigner

To sign the jacob.jar use below command on command prompt as administrator.

Location jarsigner.exe: E:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin>

In the bin folder, you will able to see jarsigner.exe

Syntax for sign jacob.jar

jarsigner -keystore .keystore_myapp -storepass mypassword $ORACLE_HOME/forms/java/anyjarfile.jar myapp


The command to sign jacob.jar

E:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\bin>jarsigner.exe -keystore .

keysotre_myapp -storepass weblogic123 E:\Oracle\Middleware\Oracle_Home\forms\java\jacob.jar myapp

It will show the below messages after running above command.


jar signed.

Warning:

The signer certificate will expire within six months.

No -tsa or -tsacert is provided and this jar is not timestamped. Without a times

tamp, users may not be able to validate this jar after the signer certificate's

expiration date (2018-12-06) or after any future revocation date.

After signing the jacob.jar we have to change some lines on configuration files.



Add below bold lines in the default.env file in Class_path the location for default.env is

E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

CLASSPATH=E:\Oracle\Middleware\Oracle_Home\jlib\frmbipc.jar;E:\Oracle\Middleware\Oracle_Home\forms\j2ee\frmsrv.jar;E:\Oracle\Middleware\Oracle_Home\forms\provision\frmconfig.jar;E:\Oracle\Middleware\Oracle_Home\jlib\ldapjclnt11.jar;E:\Oracle\Middleware\Oracle_Home\jlib\debugger.jar;E:\Oracle\Middleware\Oracle_Home\oracle_common\jlib\ewt3.jar;E:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.bali.share\share.jar;E:\Oracle\Middleware\Oracle_Home\jlib\utj.jar;E:\Oracle\Middleware\Oracle_Home\jlib\zrclient.jar;E:\Oracle\Middleware\Oracle_Home\reports\jlib\rwrun.jar;E:\Oracle\Middleware\Oracle_Home\forms\java\frmwebutil.jar;E:\Oracle\Middleware\Oracle_Home\forms\java\frmall.jar;E:\Oracle\Middleware\Oracle_Home\forms\java\jacob.jar;E:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\jre\lib\rt.jar;



Then Change in formsweb.cfg to use webutil with client_ole2 or ole2.

The location of formsweb.cfg


E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config


In Oracle 12c Forms And Reports Application Configuration Steps, we have seen the named parameters we have used to configure the Application


Add- WebUtilArchive=frmwebutil.jar,jacob.jar in named configuration.





Now Restart the WLS_FORMS and run the application with ole2 functionality on forms.


After Doing All These Changes When You Will Run You Application It May Give Some Error Of Java Security.


To Resolve This Issue

Go on control Panel

click on java icon

click on security tab if the java console.

click on Edit site list.

Add the URL of your application on the client system.

Apply the changes.

And then run the application and enjoy the webutil with client_ole2 on your forms.





If any error occurs while configuring the webutil with or without ole send me your queries on

Abhishekjha1991@hotmail.com

Abhishekjha225@gmail.com

WhatsApp-9899406098

7 views

8076381647

©2019 by Oracle12cDeepStudy. Proudly created with Wix.com