Installing Forms Builder and Reports Builder on Developer Clients

Oct 8, 2012

If you have installed a developer client for WebLogic and you want to configure Forms Builder and/or Reports Builder; however, you forgot to select “Developer Tools” during initial configuration, there are different methods you can attempt to get the Forms and Reports builders set up. One method is to re-configure the Forms and Reports domain from scratch. If you do not want to re-configure the domain, you can also do the following:

FORMS BUILDER:

  1. Go to your Registry Editor (regedit). NOTE: Please make a backup of the registry before continuing. Edit at your own risk!
  2. In HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OH######## (the first subkey in the ORACLE key), create a new string called “FORMS_BUILDER_CLASSPATH”.
  3. Modify the new key and enter the following: “C:\Oracle\Middleware\as_1\jlib\frmbld.jar;C:\Oracle\Middleware\as_1\jlib\importer.jar;C:\Oracle\Middleware\as_1\jlib\debugger.jar;C:\Oracle\Middleware\as_1\jlib\utj.jar;C:\Oracle\Middleware\as_1\jlib\ewt3.jar;C:\Oracle\Middleware\as_1\jlib\share.jar;C:\Oracle\Middleware\as_1\jlib\dfc.jar;C:\Oracle\Middleware\as_1\jlib\ohj.jar;C:\Oracle\Middleware\as_1\jlib\help-share.jar;C:\Oracle\Middleware\as_1\jlib\oracle_ice.jar;C:\Oracle\Middleware\as_1\jlib\jewt4.jar;C:\Oracle\Middleware\as_1\forms\java\frmwebutil.jar;C:\Oracle\Middleware\as_1\forms\java\frmall.jar” (NOTE: Change “as_1” to the name of your ORACLE_HOME folder. NOTE: If your Middleware home is in another hard disk such as D:\, make sure to edit the above classpath entry as well. Example: If you have “Oracle_FRHome1” as your Oracle Home directory, change “as_1” to “Oracle_FRHome1” in the above classpath entry.)
  4. You should now be able to open up Forms Builder in %ORACLE_HOME%\bin\frmbld.exe. NOTE: You may create a desktop shortcut for easy access.

REPORTS BUILDER:

  1. Download rwbuilder.bat onto the computer who needs the batch script to run Reports Builder. You may need to borrow the script from another developer client. NOTE: If you are using a 64-bit developer PC, make sure to use a rwbuilder.bat that is from another 64-bit machine!
  2. Place rwbuilder.bat in “%ORACLE_INSTANCE%\config\reports\bin”.
  3. Edit the batch file and change any occurrence of “as_1” or “asinst_1” to the name of your ORACLE_HOME and ORACLE_INSTANCE respectively.
  4. You should now be able to open up Reports Builder in %ORACLE_INSTANCE%\config\reports\bin. NOTE: You may create a desktop shortcut for easy access.

NOTE: Please refer to the Oracle Support Certification Matrix regarding supported systems for Oracle Forms and Reports as well as Forms Builder & Reports Builder.