Custom Forms Development in the AppsHosting Hosted Oracle 11i Environment

Note: To create custom forms, a dedicated Oracle 11i instance is required.

To perform custom forms development using the TEMPLATE.fmb on a client workstation (i.e. your PC), you must properly set up the environment as follows:

1. Copy over TEMPLATE.fmb and APPSTAND.fmb in BINARY format from $AU_TOP/forms/US directory on the AppsHosting server to the development machine (i.e. your PC) using WinSCP.
   
   
2. Copy over all pll files from $AU_TOP/resource in BINARY format from the AppsHosting server to the development machine using WinSCP.
   
   
3. Ensure that the FORMS60_PATH environment variable includes the directory where the above forms and libraries are located on the development machine.
   
   
4. To change the environment variable FORMS60_PATH for the development machine, open the registry (Click Start, Run, regedt32 <enter) and navigate to:
   
   HKEY_LOCAL_MACHINE / SOFTWARE / Oracle
   
   Modify this environment variable to reflect the FORMS60_PATH.
   
   
5. Re-boot the machine to pick up the changes to the registry.
   
   
6. Open up the TEMPLATE.fmb using Forms Builder on the development machine.

If you have any problems or questions, please contact AppsHosting Support.