Setting up custom form development environment in Oracle Apps

Want to create a custom form in Oracle Apps? Don’t know where and how to start? Before designing, you need to setup forms development environment on your desktop.

In this article, I will cover how to set up forms development environment.


This tutorial assumes basic working knowledge of Oracle Forms Builder, FTP process and Windows Operating System.


  • Oracle Developer Suite 10G (
  • Oracle E-Business Suite ( Apps 11i or R12)
  • WinSCP/FileZilla


Oracle Apps in Complete ERP suite with business applications like Distribution, Finance, Order Management, Purchasing and many others. Oracle forms developer is a major GUI tool to develop the user interface. Though Oracle is moving to OAF, ADF and other technologies like the cloud but still, form builder is used for development.

You may have observed that look and feel across all forms is consistent across Oracle Apps. Your custom form should also follow same standards so that it does not look alien when registered with Oracle Apps.

Step 1: Download Oracle Developer Suite 10g (

Oracle form builder is part of Oracle Developer Suite 10G. It is available as a download on Oracle site. Open this link to download it. It is available for Windows, Linux, Mac operating system.

Select respective depending on operating system and install it.

Oracle Developer Suite 10G Download

Step 2: Setup forms development environment

Oracle Apps provides starting point as TEMPLATE.fmb and APPSTAND.fmb module.

APPSTAND.fmb:- It contains a collection of standard objects like triggers, canvas, windows, blocks, LOV. All these objects have the fixed property defined like width, height and color wherever applicable. This is basically a template of all object type. All other form inherited these objects from APPSTAND.fmb to have common characteristic and behavior.

TEMPLATE.fmb:- It is a starting point for any custom form development. It is a child of APPSTAND.fmb i.e, it inherits all properties from APPSTAND.fmb. You need to create a copy of this form to start new development.

This inheritance is important here, if while developing any custom form if it breaks your form behavior would change. Each child form checks these dependencies in $AU_TOP/forms/US and $AU_TOP/resource/US. There is an equivalent path in windows env forms_path. All parent objects should be there in form_path.

How to check forms_path on Windows?

Navigate to run and type regedit.

run regedit

It opens registry editor as shown above. You can search the registry to get forms path. Click on edit and find button and search for FORMS_PATH as shown below.

Note: Please do not change any value. It may stop working on windows.

registry find

It finds the variable. Just double-click on it to see the values. You can see my forms path.

registry forms path


All dependent objects should be under this path C:\DevSuiteHome_1\forms.

Copy TEMPLATE.fmb and APPSTAND.fmb

Download TEMPLATE.fmb, APPSTAND.fmb from $AU_TOP/forms/US path and PLL mentioned below from $AU_TOP/resource path. Copy all these files to your development environment forms path shown above paragraph.

PLL files for your reference in Oracle Apps R12.

PLL Name Description
1 APPCORE.pll Application Standards, toolbar
2 VERT.pll Specific industry features
3 GLOBE.pll Global or regional features
4 JA.pll Asia/Pacific features
5 JE.pll Europe/Middle East/Africa features
6 JL.pll Latin America Code
7 CUSTOM.pll Customizations of standard forms
8 FNDSQF.pll Flexfields, Profiles, Currency, Concurrent Request Submission, Record History, Message Dictionary
9 APPDAYPK.pll Calendar
10 APPFLDR.pll Packages for Folder Blocks
11 FV.pll Federal Financials
12 HRKPI.pll Human Resources Knowledge Provider
13 GHR.pll Global Human Resources
14 GMS.pll Encumbrances
15 IGILUTIL.pll International Public Sector
16 International Public Secto
17 PSAC.pll Public Sector Applications
18 PQH_GEN.pll Public Sector Human Resources
19 PSA.pll Public Sector Applications
20 PSB.pll  Public Sector Budgeting
21 OPM.pll  Process Manufacturing
22 APPCORE2.pll Application standards (for CUSTOM.pll)
23 VERT1.pll
24 VERT2.pll
25 VERT3.pll
26 VERT4.pll
27 VERT5.pll
28 IGI_CBC.pll
29 IGI_CC.pll
30 IGI_CIS.pll
31 IGI_DOS.pll
32 IGI_EXP.pll
33 IGI_IAC.pll
34 IGI_MHC.pll
35 IGI_SIA.pll
36 IGI_STP.pll

Attach PLL to Template.fmb

Open form builder and open TEMPLATE.fmb file and attach each library. You will get an error like missing libraries. Click each library and attach to the forms builder one by one. There are minimum 36 libraries you need to attach.

Related Post