Iconic Buttons On Oracle Application Server

1. On Single OC4J PC (Stand Alone)

Design time Configuration

To display the icons in your Forms builder, modify your windows registry

HKEY_LOCAL_MACHINE\Software\Oracle\<Forms10 g_Home>\UI_ICON by entering the path of your GIF/JPG files for e.g. C:\MY_APP\ICONS. And create ui_icon_extension and give it value GIF

Extracting Icons From frmall.jar

1.  Search the frmall.jar file

2.  Right click on the file choose option Extract Files and define the folder where you want to extracts the icons.

Runtime Configuration

1) Creating Jar file

      i) Once you are ready with your GIF files or JPG files, create a folder called ICONS. You can create this folder anywhere. For e.g.   you can create ICONS folder on a C drive under root directory or as    a sub-folder under any folder.

      ii) Assuming you have created ICONS folder as a root folder on C drive, now copy all your GIF files in this folder.

      iii) Go to the DOS prompt and enter cd\

iv) Set the Path on Command Prompt,

 C:\>path=d:\devsuitehome_1\jdk\bin

       v) At C:\ prompt enter the following command to create Java

      Archive File (JAR) called my_icons Jar -cvf my_icons.jar icons

      C:\>jar -cvf icons.jar C:\Source6i_Form\icons

      vi) Copy this file in <Forms10g_Home>\Forms\Java folder with Icons folder. Please remember that having the name of the folder holding GIF/JPG files as ICONS is very important. Because if the folder name is something else, icons will not be displayed in your form at run time. This reason is not mentioned anywhere in Oracle's documentation. I learnt about this through metalink  (Service Request no. 6602276.993) after struggling for more than one day to display the icons.

2) Modify REGISTRY.DAT file

      i) Open this file located in

      <Forms10g_Home>\forms\java\oracle\forms\reg istry folder.

      ii) Append the existing parameter default.icons.iconpath as       follows:

      DEFAULT.ICONS.ICONPATH=ICONS/

iii) If you are going to use GIF files as image files for icons, then leave the existing parameter default.icons.iconextension=gif as it is. If you want to use JPG files instead of GIF files, replace GIF with JPG or JPG with GIF, Default value of this parameter is GIF, so do not change if your icons extension are gif.     Parameter values are as shown below:

      DEFAULT.ICONS.ICONEXTENSION=GIF

3) Modify FORMSWEB.CFG file,This file exists under <Forms10g_Home>\Forms\Server folder. Append the following existing parameters:

      i) imagebase=codebase

      ii) archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob            .jar,my_icons.jar

4) Modiyf Default.Env file, this file exists under <Forms10g_Home>\Forms\Server. Append the following Parameter

CLASSPATH=D:\DevSuiteHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;D:\DevSuiteHome_1\jlib\repository.jar;D:\DevSuiteHome_1\jlib\ldapjclnt10.jar;D:\DevSuiteHome_1\jlib\debugger.jar;D:\DevSuiteHome_1\jlib\ewt3.jar;D:\DevSuiteHome_1\jlib\share.jar;D:\DevSuiteHome_1\jlib\utj.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\frmwebutil.jar;D:\DevSuiteHome_1\forms\java\icons.jar

2. On Application Server. 

Step 1

---

1.  Create one folder on E:\PQGTL

2.  Copy all object libraries and Plsql Libraries in.

3.  Create new folder name EXECUTABLE contain all fmx and rep files

4.  Create new folder name Forms10g contain FMB and RDF Files

Step 2

1.  Creating Jar file

   i) Once you are ready with your GIF files or JPG files, create a folder called ICONS. You can create this folder anywhere. For e.g.      you can create ICONS folder on a C drive under root directory or as       a sub-folder under any folder.

      ii) Assuming you have created ICONS folder as a root folder on C drive, now copy all your GIF files in this folder.

      iii) Go to the DOS prompt and enter cd\

iv) Set the Path on Command Prompt,

 e:\>path= E:\oracle\FRHome_1\jdk\bin

v) At C:\ prompt enter the following command to create Java

Archive File (JAR) called my_icons Jar -cvf my_icons.jar icons

      e:\>jar -cvf icons.jar E:\PQGTL\icons

2.  Now copy the icons.jar and icon folder on E:\oracle\FRHome_1\forms\java

3.  Apply the following changes in E:\oracle\FRHome_1\forms\java\oracle\forms\registry\registry.dat

Open in notepad

Add following Parameters

default.icons.iconpath=icons/

default.icons.iconextension=gif

4.  Apply the following changes in formsweb.cfg located in E:\oracle\FRHome_1\forms\server

# Forms runtime argument: which form module to run

#form=test.fmx

form=login_win.fmx

# Forms runtime argument: database connection details

userid=pqgtl/pqgtl@tims

# Forms runtime argument: whether to run in debug mode

debug=no

# Forms runtime argument: host for debugging

host=http://pq-hrsvr:18100

# HTML page title

pageTitle=Pak Qatar General & Family Takaful Limited.

# Forms applet parameter

#imageBase=DocumentBase

imageBase=codeBase

# Forms applet parameter

width=1200

# Forms applet parameter

height=800

# Forms applet parameter

separateFrame=true

# Forms applet parameter

splashScreen=false

# Forms applet archive setting for JInitiator

archive_jini=frmall_jinit.jar,frmall.jar,icons.jar

5.  Apply the following changes in Default.env file, its also find on same location of formsweb.cfg

#

FORMS_PATH=E:\oracle\FRHome_1\forms;E:\PQGTL;E:\PQGTL\Executable\; E:\PQGTL\Reports;

#

CLASSPATH=E:\oracle\FRHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;E:\oracle\FRHome_1\jlib\repository.jar;E:\oracle\FRHome_1\jlib\ldapjclnt10.jar;E:\oracle\FRHome_1\jlib\debugger.jar;E:\oracle\FRHome_1\jlib\ewt3.jar;E:\oracle\FRHome_1\jlib\share.jar;E:\oracle\FRHome_1\jlib\utj.jar;E:\oracle\FRHome_1\jlib\zrclient.jar;E:\oracle\FRHome_1\reports\jlib\rwrun.jar;E:\oracle\FRHome_1\forms\java\frmwebutil.jar;E:\oracle\FRHome_1\forms\java\icons.jar

6.  Press Start à Run à Type REGEDIT

HKEY LOCAL MACHINEàSOFTWAREàORACLEàKEY_FRHOME1

DOUBLE CLICK THE FORMS_PATH And add the following values in existing values

E:\oracle\FRHome_1\forms; E:\PQGTL;E:\PQGTL\Executable;

7.  Add the following value in REPORTS_PATH with existing values of same screen

E:\PQGTL\Reports;

8.  Find the TNSNAMES.ORA file, and add the particular data links.

TIMS =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.80)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = pqgtl)

    )

  )

9.  Configuring The Report Server

            i.     In Formsweb.cfg File, change the following parameter if its value is TRUE.

# application-specific section to enable Single Sign-On for that application.

ssoMode=false

          ii.     Remove the following parameter value in rep_app_server.conf file located in E:\oracle\FRHome_1\Reports\conf folder.

 <!--security id="rwSec" class="oracle.reports.server.RWSecurity">

      <property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>

      <property name="oidEntity" value="%REPORTS_OID_ENTITY%"/>

   </security-->

        iii.     Change the Paramater in rwservelet.properties, file in wordpad. This file located in  E:\oracle\FRHome_1\Reports\conf folder. Palce # Sign on

            #SINGLESIGNON=YES