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 oracle forms development environment on your desktop.

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

Introduction

Oracle Apps is a 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 the same standards so that it does not look alien when registered with Oracle Apps.

Let’s see how to do that.

Pre-Requisite

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

Software/Tools

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

Download and Install Oracle Developer Suite 10g (10.1.2.0.2)

Oracle forms 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

It is a wizard-driven installation. Just click on the downloaded setup.exe file. It starts oracle universal installer which does a quick pre-requisite check and starts the installation. Refer to this step by step installation guide.

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 using any FTP client like WinSCP or Filezilla. Copy all these files to your development environment forms path shown above paragraph.

PLLs are basically common PL/SQL libraries which provide common functionality flexfield utilities, currency, etc. PLL files for your reference in Oracle Apps R12.

PLL NameDescription
1APPCORE.pllApplication Standards, toolbar
2VERT.pllSpecific industry features
3GLOBE.pllGlobal or regional features
4JA.pllAsia/Pacific features
5JE.pllEurope/Middle East/Africa features
6JL.pllLatin America Code
7CUSTOM.pllCustomizations of standard forms
8FNDSQF.pllFlexfields, Profiles, Currency, Concurrent Request Submission, Record History, Message Dictionary
9APPDAYPK.pllCalendar
10APPFLDR.pllPackages for Folder Blocks
11FV.pllFederal Financials
12HRKPI.pllHuman Resources Knowledge Provider
13GHR.pllGlobal Human Resources
14GMS.pllEncumbrances
15IGILUTIL.pllInternational Public Sector
16IGILUTIL2.plInternational Public Secto
17PSAC.pllPublic Sector Applications
18PQH_GEN.pllPublic Sector Human Resources
19PSA.pllPublic Sector Applications
20PSB.pll Public Sector Budgeting
21OPM.pll Process Manufacturing
22APPCORE2.pllApplication standards (for CUSTOM.pll)
23VERT1.pll
24VERT2.pll
25VERT3.pll
26VERT4.pll
27VERT5.pll
28IGI_CBC.pll
29IGI_CC.pll
30IGI_CIS.pll
31IGI_DOS.pll
32IGI_EXP.pll
33IGI_IAC.pll
34IGI_MHC.pll
35IGI_SIA.pll
36IGI_STP.pll
37FNDMOAC

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.

Share This: