Registration of a Custom Form in Oracle Applications(11i and R12)

Summary of Steps to Register a form
1. If it is a new form start from TEMPLATE.fmb with the Required .pll files and build
the form TESTFORM.fmb
2. FTP the form TESTFORM.fmb to $AU_TOP/forms/US
3. For 11i , use f60gen and for R12 use frmcmp_batch to create TESTFORM.fmx in
$CUSTOM_TOP/forms/US
4. In Oracle Applications, Navigate to Application Developer Responsibility->
Application-> Form
5. In Oracle Applications, Navigate to Application Developer Responsibility->
Application -> Function and associate the form with the function.
6. In Oracle Applications, Navigate to Application Developer Responsibility->
Application->Menu and associate the function with menu.
7. In Oracle Applications, Navigate to System Administrator Responsibility ->
Responsibility-> Define and associate the menu with the Responsibility.
8. In Oracle Applications, Navigate to System Administrator Responsibility ->
Security ->User-> Define and associate the Responsibility with the User.
Detailed Step by Step Form Registration Task
Requirements:
1. Oracle Applications (11i or R12) Access
2. Oracle Forms Builder(6i or 10g)
3. WinSCP Tool
§ WinSCP is an open source free SFTP client and FTP client for Windows. Legacy SCP
protocol is also supported. Its main function is safe copying of files between a local and a
remote computer.

Step1:- Login into Oracle Application Using the default Username and Password like
operations/welcome
- Go to the form which you want to customize.
- After that form opened, Select View->about Oracle Application
- Now the Window appearing with all details about oracle application from there
note the current opening form’s path.
Note:
Normally, Form (.fmb) files are placed Under $AU_TOP/forms/US directory.
 

Step2:- Open the winSCP tool, The Following window is opening,

- In Remote system window, open the form’s (.fmb) current folder
(appltop/au/forms/us)
- Locate the .fmb file of form will be customize.
- Then select that file and drag it in local file system wherever you want (System’s
Mentioned FORMS_PATH).
- Now the Form is Copying.
- After Copied, Try to open in the Oracle Form Builder.(Note: Now the Form was
not opening. Because Oracle Form Builder needs the library (.pll) file to opening the
form.
 

Step 3:- All Library Files are placed in the Resource folder of the Form’s Current Folder.
($AU_TOP/resource/US)
- From there copy the required .pll files into local system where the form located
generally to FORMS_PATH (Local System’s (example: PC ) Mentioned
FORMS_PATH).

- For TEMPLATE.fmx form following .pll are required,
1. APPSTAND.fmb
2. FNDSQF.pll
3. APPCORE.pll
4. APPCORE2.pll
5. AADAYPK.pll
6. APPFLDR.pll
7. VERT.pll
8. GLOBE.pll
9. PSAC.pll
10. PQH_GEN.pll
11. GHR.pll
12. JA.pll
13. JR.pll

Step 4:
- Now you open that form into your Oracle Form Builder.
- Do your own customization. And save it
- Once the customization was done.
 

Step 5:- Open the winSCP.

- And Enter the Username & Password, then click the Login button.
- Then the following window is opening,

- Then Move (copy) the customized form (TEXTFORM.fmb) from local system to
Remote system (path like $AU_TOP/forms/US).
 

Step: 6
- Now open the Terminal window to creating the customized form’s executable
(TEXTFORM.fmx).
Opening Terminal:
- In winSCP tool, Open Terminal icon was available. To click that Icon Now the
Terminal window is opening.

- Or In winSCP tool, select menu Commands–> Open Terminal
- After clicking Open Terminal, It appearing a window with title console.
- Enter the Following command to creating .fmx file under Custom_top (Before that
identify the path of form’s executable file (.fmx))
For Oracle Applications 11i
- f60gen module=$AU_TOP/forms/US/TEXTFORM.fmb
output_file=$CUSTOM_TOP/forms/US/TEXTFORM.fmx userid=apps/****
 

For Oracle Applications R12- frmcmp_batch module=$AU_TOP/forms/US/ TEXTFORM.fmb
userid=APPS/***** output_file=$ CUSTOM_TOP /forms/US/ TEXTFORM.fmx
module_type=form batch=yes compile_all=special
- click the Execute button, Now that Command creating (or replacing) the .fmx file into
represented path.
 

Registering the Customized Forms into Oracle ApplicationDocument Summary This document describes the process of registering new forms in
oracle applications.
 

Registering a FormNavigation – Application Developer -> Application->Form

Click on Form and you will see following screen.

Fields
Form : Enter the file name of your form (the name of the .fmx file) without extension.
Your form filename must be all uppercase, and its .fmx file must be located in your
application directory structure.
Application : Enter the name of the application which will own this form.
User Form Name : This is the form name you see when selecting a form using the
Functions window.
Description : Enter a suitable description for your form.
Register Form Functions
Navigation – Application Developer -> Application->Function

Click on Function and you will see following screen

Click on the form tab and you will see following screen

Fields
Function : Enter a unique function name for your function. This function name can be
used while calling this program programmatically. This name is not visible to the user
through other forms.
Form : Select the form name which you have registered.
Application : Select the application name for your form.
Parameters : Enter the parameters that you want to pass to your form function. E.g. Query_only.
 

Creating Menu of Functions
Navigation – Application Developer -> Application->Menu

Click on Menu and you will see following screen

Fields
Menu : Enter the descriptive name for the menu. This name is not visible to the user.
User Menu Name : The user menu name is used when a responsibility calls a menu.
Menu Type : The options in menu type include:
• Standard – for menus that would be used in the Navigator form
• Tab – for menus used in self-service applications tabs
• Security – for menus that are used to aggregate functions for data security or
specific function security purposes, but would not be used in the Navigator form
Seq : Enter a sequence number.
Prompt : Enter the prompt that the users will see for the menu.
Submenu : If you want another menu to be called from this menu, then enter this menu
name in this field.

Function : Enter the form function name in this field.
Description : Enter a suitable description for the menu.
Grant :The Grant check box should usually be checked. Checking this box indicates that
this function is automatically enabled for the user. If this is not checked then the function
must be enabled using additional data security rules.
View Tree :Click on View Tree Button and you will see following screen with the full
hierarchy of the menu.
 

Creating ResponsibilitiesNavigation – System Administrator -> Security->Responsibility->Define

Click on Define button and you will see following screen in front of you.