Customized Form Development

Oracle E-Business Suite

A. F. FERGUSON & CO.

CHARTERED ACCOUNTANTS
 Customized Form Development Oracle E-Business Suite

Contents
Prerequisites.................................................................................................................................6
Base Directory..........................................................................................................................6
Environment Variable.............................................................................................................6
Creation of New Form................................................................................................................7
Standard Template..................................................................................................................7
Open Standard Template....................................................................................................7
Change Module Name........................................................................................................7
Remove standard Objects...................................................................................................8
Data Block.........................................................................................................................8
Canvas...............................................................................................................................8
Windows...........................................................................................................................8
Create or Change Objects........................................................................................................9
Create Window....................................................................................................................9
Create Canvas.....................................................................................................................10
Change Trigger...................................................................................................................11
Change Program Units......................................................................................................12
Create Data Block...............................................................................................................12
Master Detail Relationship...................................................................................................18
Create Master Data Block..................................................................................................18
Create Details Data Block.................................................................................................23
Other Objects..............................................................................................................................29
Working with List of Value (LOV)......................................................................................29
Apply Calendar LOV on Date type Text Field...............................................................29
Apply LOV on Text Item..................................................................................................30
Create Record Group.....................................................................................................30
Create LOV.....................................................................................................................32
Working with Text Item........................................................................................................34
Making Text Item Mandatory..........................................................................................35
Working with Display Item..................................................................................................35

A. F. Ferguson & Co. Page 2 of 58

 Customized Form Development Oracle E-Business Suite

Making Text Item to Display Item...................................................................................35

Buttons....................................................................................................................................36
Create Button......................................................................................................................36
Triggers...................................................................................................................................37
Form level...........................................................................................................................37
Block Level..........................................................................................................................37
Item Level...........................................................................................................................37
Program Units........................................................................................................................38
Control Objects.......................................................................................................................38
Control Block......................................................................................................................38
Control Items......................................................................................................................38
Alter Existing of Form...............................................................................................................39
Add New Field.......................................................................................................................39
Alter Existing Field................................................................................................................41
Remove Existing Field...........................................................................................................41
Tracing Data Changes...............................................................................................................42
Record History (WHO) Columns........................................................................................42
How to Populate WHO Columns........................................................................................42
How to Develop Query Find Form.........................................................................................43
Submit Request from Oracle Form..........................................................................................50
Custom Form Integration/Deployment..................................................................................51
Transfer Form to Server........................................................................................................51
Form Compilation..................................................................................................................51
Create Objects on Oracle Application Server.....................................................................52
Create Form........................................................................................................................52
Create Form Function........................................................................................................52
Form Attachment to Menu...................................................................................................54
Item Property Setting Commands.................................................................................................57
ENTERABLE...............................................................................................................................57
DISPLAYED:...............................................................................................................................57
ENABLED:..................................................................................................................................57

A. F. Ferguson & Co. Page 3 of 58

Customized Form Development Oracle E-Business Suite

REQUIRED:................................................................................................................................58

A. F. Ferguson & Co. Page 4 of 58

Customized Form Development Oracle E-Business Suite

Customized Form Development

Oracle E-Business Suite

A. F. Ferguson & Co. Page 5 of 58

 Customized Form Development Oracle E-Business Suite

Prerequisites
Base Directory
Create folder as given below

 D:\AU

In AU folder creates following folder

 12.0.0

Now create three more folders in 12.0.0 folder

 D:\AU\12.0.0\forms
 D:\AU\12.0.0\resources
 D:\AU\12.0.0\plsql

Copy following files from Oracle Application server to local machine:

 Copy TEMPLATE.fmb, APPSTAND.fmb files from $AU_TOP/forms to D:\AU\

forms folder, using WINSCP
 All .pll files from $AU_TOP/Resource to D:\AU\resource folder using WINSCP

Environment Variable
Set environment variable FORMS_PATH as given below

 Start Menu => Control Panel => System

 Click on the Advanced tab.
 Click on the Environment Variables button towards the bottom.
 Add the FORMS_PATH variable to the list of System Variables. 
 Click on the New button and enter the variable name and variable value.
 Variable Name = FORMS_PATH
 Variable Value = D:\au\12.0.0\forms\US;D:\au\12.0.0\resource;D:\au\
12.0.0\plsql

A. F. Ferguson & Co. Page 6 of 58

 Customized Form Development Oracle E-Business Suite

Creation of New Form

Standard Template
Following steps are used to build custom form using standard template.

Open Standard Template

Open Template.fmb from application server. Form path is given below

D:\AU\forms\template.fmp

‘Save as’ template form with another name i.e. “IIL_LM_PAYMENT_MASTER.fmb”,

give the MODULE name as “IIL_LM_PAYMENT_MASTER”.

Change Module Name

Change MODULE name ‘TEMPLATE’ to ‘IIL_LM_PAYMENT_MASTER’
Chose MODULE name which is appropriate for your form function. As we are
deveolping Loan Payment form so here MODULE name is IIL_LM_PAYMENT_MASTER.
Double click MODULE icon

Change Name as IIL_LM_PAYMENT_MASTER

A. F. Ferguson & Co. Page 7 of 58

 Customized Form Development Oracle E-Business Suite

Remove standard Objects

Delete following standard objects

 Data Block
 Canvas
 Windows

Data Block
Remove Following two Data Blocks

 BLOCKNAME
 DETAILBLOCK

Canvas
Delete following Canvas

 BLOCKNAME

Windows
Delete following Window

 BLOCKNAME

A. F. Ferguson & Co. Page 8 of 58

 Customized Form Development Oracle E-Business Suite

Create or Change Objects

Create following objects

 Windows
 Canvas
 Change Trigger
 Change Program Units
 Data Blocks

Create Window
 Click Window
 Press (create button) from left side Button Pallette

 Double Click Window icon

 Set following properties

A. F. Ferguson & Co. Page 9 of 58

 Customized Form Development Oracle E-Business Suite

 Name: PAYMENT_WIN
 Subclass Information: WINDOW
 Title: Payment Form
 Maximize Allowed: No
 Minimize Allowed: No

Create Canvas
 Click Canvases
 Press (create button) from left side Button Pallette

Click new created canvas and press F4 to trigger properties form

 Set following properties

 Name: PAYMENT_CAN
 Subclass Information: CANVAS
 Window: PAYMENT_WIN
 Width/Height: As per form size requirement
 Canvas Type: Content

A. F. Ferguson & Co. Page 10 of 58

 Customized Form Development Oracle E-Business Suite

 Now go back to Windows (PAYMENT_WIN)

 Double click (PAYMENT_WIN) to open up its properties
 Set following Property
 Primary Canvas: PAYMENT_CAN

Change Trigger
Change following form level trigger

 PRE-FORM

Open PRE-FORM trigger

Give window name in PRE-FORM trigger, as given in following screenshot.

A. F. Ferguson & Co. Page 11 of 58

Customized Form Development Oracle E-Business Suite

Change Program Units

Double click APP_CUSTOM body Program Unit to open.

Give Window Name in APP_CUSTOM body Program Unit (in place of window name)

Create Data Block

 Click Data Blocks
 Press (create button) from left side Button Pallette

A. F. Ferguson & Co. Page 12 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 13 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 14 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 15 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 16 of 58

Customized Form Development Oracle E-Business Suite

 Click on Data Block Frame and press F4 to get properties

1. Set following property

 Update Layout: Manually

A. F. Ferguson & Co. Page 17 of 58

 Customized Form Development Oracle E-Business Suite

Arrange Fields as per your requirment

Master Detail Relationship

Create two data blocks one as Master and other as Details. In this example we are
creating following two data blocks.

 Master
 Details

Note: user can change the names of data blocks as per development requirements

Create Master Data Block

 Click Data Blocks
 Press (create button) from left side Button Pallette

A. F. Ferguson & Co. Page 18 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 19 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 20 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 21 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 22 of 58

Customized Form Development Oracle E-Business Suite

Create Details Data Block

 Click Data Blocks
 Press (create button) from left side Button Pallette

A. F. Ferguson & Co. Page 23 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 24 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 25 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 26 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 27 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 28 of 58

 Customized Form Development Oracle E-Business Suite

Other Objects
Working with List of Value (LOV)
LOVs are used when the user must select from a list of valid values in a text field.

Apply Calendar LOV on Date type Text Field

In this example we are applying calendar on “Loan Date” field

1. Perform the following steps:

Data Blocks > MASTER > LOAN_DATE > Triggers >
Select KEY-LISTVAL trigger and press OK button
As given in the screenshot

After pressing OK button, new window will appear to enter your trigger
command/query. Type following command, compile your trigger, save it and
then exit, as given in screenshot.
 calendar.show;

2. Double click on “LOAN_DATE”

OR
Select “LOAN_DATE” and press F4, to get property window

A. F. Ferguson & Co. Page 29 of 58

 Customized Form Development Oracle E-Business Suite

 Set following properties:

 List of Values: ENABLE_LIST_LAMP
 Validate from List: No
 Initial Value: $$DATE$$
 Justification: Start

During data entry when you click “LOAN DATE” calendar will appear, as
shown below:

Apply LOV on Text Item

Create following objects in order to build LOV
 Record Group
 LOV

Create Record Group

1. Perform the following steps:
 Record Groups >

A. F. Ferguson & Co. Page 30 of 58

Customized Form Development Oracle E-Business Suite

After pressing button, record group query window will appear.

Write query for LOV and press OK button, as given in the following
screenshot.

By doing so, Record Group (RG) will be created with default name.
Click on newely created RG and press F4 to get its properties, as
shown in the following screenshot.

Set following properties:

 Name: FACILITY_RG

Important:
o You can change the record group query after creating RG by clicking
“Record Qroup Query” property from RG properties window, as
mentioned in above screenshot.

A. F. Ferguson & Co. Page 31 of 58

Customized Form Development Oracle E-Business Suite

o Columns name in RG query must match with the “Cloumn Names” in

“LOV Column Maping” window. As shown in the following screenshot.
This will be cover in “Create LOV” step.

Create LOV
Perform the folloing steps:
 LOV >

After pressing button, window will appear, select option “Build a new
LOV manually” and then press OK button, as mentioned in the following
screenshot.

After completion of step-1 above, you can see new LOV object in LOV
list, as given in following screenshot.

Double click this new created LOV to open its properies window

A. F. Ferguson & Co. Page 32 of 58

Customized Form Development Oracle E-Business Suite

Set following properties:

 Name: FACILITY_LOV
 Subcalss Information: LOV
 List Type: Record Group
 Record Group: FACILITY_RG
 Width: 2
 Height: 5

In step 7 of above screenshot we provide “Column Names”, which is given

in the “FACILITY_RG” record group’s query.

Important:
Each column name listed under “Column Names” in “LOV Column
Mapping” window must match with columns in the record group
query.

In step 8 we provide “Return Item”, which is the actual Text Item Field
available in our “MASTER” block. After maping “Return Item”, data will
be populated in the Return Item Field (i.e “MASTER.FACILITY” in our
case) when you select data from LOV at runtime.

Step 9 shows “Column Title” along with “Display Width” (2 in our case).
Simillarly, step 5 shows the LOV window “Width” and “Height”, as
mentioned in following screenshot.

A. F. Ferguson & Co. Page 33 of 58

 Customized Form Development Oracle E-Business Suite

Double click on “FACILITY” Text Field

OR
Select “FACILITY” and press F4, to get property window

 set following properties:

 list of Values: FACILITY_LOV
 validate fom List: Yes

Note:
Property “Validate from List” allows a user to type a partial value into the
field, and it will auto-reduce against the list of valid values.

Working with Text Item

Text Items are used to enter/display data in oracle form.

A. F. Ferguson & Co. Page 34 of 58

 Customized Form Development Oracle E-Business Suite

Making Text Item Mandatory

In this example we will make text item “BANK_NAME” field mandatory, by
performing the following steps:

Double click “BANK_NAME” field

OR
Select “BANK_NAME” field and press F4, to get property window
Set following properties
 Required: Yes

Now, this text item will be editable and required with yellow background, which
can be observed during data entry.

Working with Display Item

Only use display items for fields that never require the user to interact with them in any
way, including scrolling or querying

Making Text Item to Display Item

To make any field Not Enterable or Display item perform the following steps:

Double click “BANK_ACCOUNT_NUM” field

OR
Select “BANK_ACCOUNT_NUM” field and press F4, to get property window

A. F. Ferguson & Co. Page 35 of 58

 Customized Form Development Oracle E-Business Suite

Set following properties

 Item Type: Display Item
 Subclass Information: DISPLAY_ITEM

Now, this field will not be editable with Grey background, which can be
observed during data entry.

Buttons
Used to initiate an action, such as a product-specific function, or block-to-block navigation.

Create Button
To create button perform the following steps, as mentioned in the screenshot.

Click on newly created text item and press F4 or double click it to get its properties

Set following properties:

 Name: OK_PB
 Item Type: Push Button
 Subclass Information: BUTTON
 Label: OK

A. F. Ferguson & Co. Page 36 of 58

Customized Form Development Oracle E-Business Suite

 Access Key: O
 Canvas: <canvas name>

Triggers
Form level
 WHEN-NEW-FORM-INSTANCE
 WHEN-WINDOW-CLOSED
 PRE-FORM
 WHEN-TAB-PAGE-CHANGED
KEY-COMMIT

Block Level
 WHEN-NEW-BLOCK-INSTANCE
 WHEN-NEW-RECORD-INSTANCE
 WHEN-VALIDATE-RECORD
 WHEN-VALIDATE-BLOCK
 WHEN-BUTTON-PRESS
 WHEN-CHECKBOX-CHANGED
 KEY-COMMIT
 PRE-INSERT
 PRE-UPDATE
 QUERY-FIND
 PRE-QUERY

Item Level
 WHEN-VALIDATE-ITEM
 WHEN-NEW-ITEM-INSTANCE
 KEY-NEXT-ITEM

A. F. Ferguson & Co. Page 37 of 58

 Customized Form Development Oracle E-Business Suite

 WHEN-BUTTON-PRESSED
Program Units
The New Program Unit dialog allows you to specify a name and type of program unit to create.
The following Types are Exist.

 Function
 Procedure
 Package Body
 Package Specification

Control Objects
Control Block
A control block is not associated with the database, and the items in a control block do not relate
to table columns within a database.

To make a data block to control block set following property

 Query Data Source Name: null

Control Items
Items that does not have a relationship to a database table or items that do not correspond to
columns in a database table. Examples of control items are buttons, text items, check boxes, etc.

To make any item to control item set following properties

 Database Item: No
 Column Name: Null

A. F. Ferguson & Co. Page 38 of 58

 Customized Form Development Oracle E-Business Suite

Alter Existing of Form

Form can be altered in many ways. You may either add/delete any object or change
existing object.

We will perform following tasks to alter custom/standard form.

 Add new field

 Alter existing field
 Remove existing field

Add New Field

To add new field in existing form, perform the following steps:

1. Go to the block where you want to add new field.

2. Double click Blockname or Click BlockName and press F4 to get its property
window.

3. Copy table name from “Query data Source Name”

4. Add new field in the table (i.e DESCRIPTION), using toad/sql developer.
To add DESCRIPTION field run the following command:

ALTER TABLE IIL_LM_LOAN_DETAILS

ADD (DESCRIPTION VARCHAR2(150));

5. Once field is created in table, add field in form as given in the following
screenshot.

6. Click on newly created text item and press F4 or double click it to get its
properties

A. F. Ferguson & Co. Page 39 of 58

Customized Form Development Oracle E-Business Suite

7. Set the following properties

Note: In this example we are creating “Description” field

 Name: DESCRIPTION
 Subclass Information: TEXT_ITEM
 Data Type: Char
 Maximum Length: 150
 Database Item: Yes
 Column Name: DESCRIPTION
 Canvas: LOAN_CAN
 Width: 1.5
 Height: 0.25
 Prompt: Description
 Prompt Justification: Start
 Prompt Attachment Edge: Star
 Prompt Allignment: Start

Note: when you add field in multiline datablock, prompt allignment properties
should be as follows

 Prompt: Description
 Prompt Justification: Center
 Prompt Attachment Edge: Top
 Prompt Allignment: Center
8. Close properties window, press F2 to get your required canvas. In canvas view,
you will find newly created field (i.e. DESCRIPTION) at the top left corner of
view window.

A. F. Ferguson & Co. Page 40 of 58

 Customized Form Development Oracle E-Business Suite

9. Click and drag this field on appropriate location, as given in the screenshot.

Alter Existing Field

Existing filed can be alter by changing its properties or attaching or removing LOV/
Triggers.

Remove Existing Field

You can remove existing filed by removing its canvas and diconnect it from table
column. set following properties:

 Database Item: No
 Column Name: Null
 Canvas: Null
 Required: No

A. F. Ferguson & Co. Page 41 of 58

 Customized Form Development Oracle E-Business Suite

Tracing Data Changes

WHO columns enable Oracle Record History feature to record history information about
who created or updated rows in oracle E-Business tables. Oracle E-Business Suite
upgrade technology relies on Record History (WHO) information to detect and preserve
customizations.

Record History (WHO) Columns

Following table lists the standard columns, used for Record History (WHO)

Column Name Type Null? Description Value

TO_NUMBER (FND_
Keeps track of which user created
CREATED_BY Number Not Null PROFILE. VALUE
each row
('USER_ID'))
Stores the date on which each row
CREATION_ DATE Date Not Null SYSDATE
was created
TO_NUMBER (FND_
Keeps track of who last updated
LAST_ UPDATED_BY Number Not Null PROFILE. VALUE
each row
('USER_ID'))
Stores the date on which each row
LAST_UPDATE_ DATE Date Not Null SYSDATE
was last updated
Provides access to information
TO_NUMBER (FND_
about the operating system login
LAST_UPDATE_ LOGIN Number PROFILE. VALUE
of the user who last updated each
('LOGIN_ ID'))
row

Any table that may be updated by a concurrent program also needs additional columns

Column Name Type Null? Description

Keeps track of the concurrent request during which this row

REQUEST_ID Number
was created or updated
PROGRAM_ With PROGRAM_ID, keeps track of which concurrent
Number
APPLICATION_ ID program created or updated each row
With PROGRAM_ APPLICATION_ID, keeps track of which
PROGRAM_ID Number
concurrent program created or updated each row
PROGRAM_ Stores the date on which the concurrent program created or
Date
UPDATE_DATE updated the row

How to Populate WHO Columns

Following procedure automatically assigns the values of the WHO columns in Pre-Insert
and Pre-Update triggers.

 FND_STANDARD.SET_WHO

A. F. Ferguson & Co. Page 42 of 58

 Customized Form Development Oracle E-Business Suite

How to Develop Query Find Form

Copy Object Group from Standard Form 

Drag QUERY_FIND Object Group from APPSTAND.fmb form to your Custom Form’s
Object Group. After doing so, we automatically get Window, Canvas, Data Block objects
with the name QUERY_FIND.

A. F. Ferguson & Co. Page 43 of 58

 Customized Form Development Oracle E-Business Suite

Once you drag and drop the QUERY_FIND Object, it will ask for Copy or Sub-Class.
Select Copy option.

Set Subclass Information

Apply subclass information to Window, Canvas as well as Block. And drag these to first
position   as shown in below.

A. F. Ferguson & Co. Page 44 of 58

 Customized Form Development Oracle E-Business Suite

Alter Query Find Data Block Items

In QUERY_FIND data block we get 3 buttons(Clear,New,Find) with 3 Triggers.

Give target Block name (the header block which you want to find) in WHEN-BUTTON-
PRESSED trigger of New and Find Button. Compile and close.

A. F. Ferguson & Co. Page 45 of 58

Customized Form Development Oracle E-Business Suite

Create Control Item

Create Control item (i.e. DEPTNO) in the QUERY_FIND Block, apply subclass

information as TEXT_ITEM and attach that item to the QUERY_FIND canvas.

Copy Query Find Standard Trigger

Drag the QUERY_FIND trigger from standard form (APPSTAND.fmb) and place it in
block level trigger of your target header block (i.e. DEPT).

A. F. Ferguson & Co. Page 46 of 58

 Customized Form Development Oracle E-Business Suite

Syntax:

APP_FIND.QUERY_FIND(<results block window>,  <Find window>,  <Find window block>);

Example:

APP_FIND.QUERY_FIND(‘DEPT_WINDOW’, ‘QUERY_FIND’,’QUERY_FIND’);

Set Block Level Trigger

Next Create PRE-QUERY trigger in the block level (i.e. DEPT block)

A. F. Ferguson & Co. Page 47 of 58

 Customized Form Development Oracle E-Business Suite

Syntax:

IF :parameter.G_query_find = TRUE THEN

COPY (<find Window field>,<results field>);

:parameter.G_query_find := FALSE;

END IF;

Example:

IF :parameter.G_query_find = ‘TRUE’ THEN

COPY(:QUERY_FIND.DEPTNO, ‘DEPT.DEPTNO’);

:parameter.G_query_find := ‘FALSE';
END IF;

Change Next Navigation Properties

Form Level

In the form module (i.e. XXMZ_Query_Find form) give the first navigation block as
QUERY_FIND.

A. F. Ferguson & Co. Page 48 of 58

 Customized Form Development Oracle E-Business Suite

Block Level

In the QUERY_FIND Data Block give next navigation block as your target block (i.e.
DEPT block).

Finally, save and move your form to Oracle Application.

A. F. Ferguson & Co. Page 49 of 58

 Customized Form Development Oracle E-Business Suite

Submit Request from Oracle Form

Request can be submitted from Oracle Form using following APIs.

Set Layout for XML Reports before calling FND_REQUEST.SUBMIT_REQUEST

RET_BOOLEAN := FND_REQUEST.ADD_LAYOUT
(
TEMPLATE_APPL_NAME => <APPLICATION_SHORT_NAME>, -- AR,ONT
TEMPLATE_CODE => '<TEMPLATE-CODE>',
TEMPLATE_LANGUAGE => 'EN',
TEMPLATE_TERRITORY => 'US',
OUTPUT_FORMAT => 'PDF'
);

To submit any Request use following API

RET_BOOLEAN := FND_REQUEST.SUBMIT_REQUEST
(
APPLICATION => 'APPLICATION-SHORT-NAME',
PROGRAM => 'PROGRAM-SHORT-NAME',
DESCRIPTION => 'PROGRAM-DESCRIPTION',
START_TIME => SYSDATE,
SUB_REQUEST => FALSE,
ARGUMENT1 => <PARAMETER1>,
ARGUMENT2 => <PARAMETER2>,
ARGUMENT3 => <PARAMETER3>,
ARGUMENT99 => <PARAMETER99>,
CHR(0)
);

Note: you can use up to 99 parameters

To Transfer Request’s Output use following API

RET_BOOLEAN := FND_DELIVERY.ADD_FTP
(
SERVER => <TARGET-SERVER-IP> -- DB NODE IP
USERNAME => 'ORACLE',
PASSWORD => '<PASSWD>',
REMOTE_DIR => '<PATH>' --/ORADB01/ATTACHMENTS_APPS1',
PORT => NULL,
SECURE => TRUE,
LANG => NULL
);

A. F. Ferguson & Co. Page 50 of 58

 Customized Form Development Oracle E-Business Suite

Custom Form Integration/Deployment

If a customized form has been developed using oracle form builder then the form can be
integrated with oracle applications. Oracle strongly recommends that pick a template
of .fmb file from AU_TOP.

Example:
“/d01/oracle/apps/apps_st/appl/au/12.0.0/forms/US/TEMPLATE.fmb”, copy this
TEMPLATE.fmb to your personal folder start development on it.

The following steps highlight how to integrate a form with oracle applications:

Transfer Form to Server

Copy developed Form’s “fmb” file from local machine to the oracle Application Server’s
AU_TOP. This is where the “.fmb” files are stored.

AU_TOP Path: …/oracle/apps/apps_st/appl/au/12.0.0/forms/US

Example: /d01/oracle/apps/apps_st/appl/au/12.0.0/forms/US

Form Compilation
1. Source the Application Environment:

Set the application environment variable with the following command.

A. F. Ferguson & Co. Page 51 of 58

 Customized Form Development Oracle E-Business Suite

 . /d01/oracle/apps/apps_st/appl/APPSTEST_testapps.env
2. Compile the Form:

Execute the following command, replacing with your form name instead of the example
given below:

frmcmp_batch userid= apps/apps

module= /d01/oracle/apps/apps_st/appl/au/12.0.0/forms/US/AP_PAYMENT
.fmb output_file= /d01/oracle/apps/apps_st/appl/ap/12.0.0/forms/US/AP_PAYMENT.fmx
module_type=form batch=no compile_all=special

Create Objects on Oracle Application Server

Create Form
Login to Oracle Applications with the “Application Developer” responsibility.

Navigate to Application-> Form. The following screen will pop up:

Form : Name of the fmx file name.

Application : Name of the production where you want to configure the form.
User Form Name : Specify the name of the form that you like to be displayed for the
form.

Create Form Function

Navigate to Application-> Function. The following screen will pop up:

A. F. Ferguson & Co. Page 52 of 58

 Customized Form Development Oracle E-Business Suite

Step 1: On Description Tab

Function : Name of the fmx file name.

User Function Name : Name of the fmx file name.

Step 2: On Properties Tab

Type : Select “Form” from List of values

Step 3: On Form Tab

A. F. Ferguson & Co. Page 53 of 58

 Customized Form Development Oracle E-Business Suite

Form : In the form select “User Form Name” from List of values which you have
defined in point # 5.

Note: The rest of the fields are default populated. All other information is entered by
default. Save your work. Once this is saved, the form is fully registered with oracle
applications. It can be assigned to any menu as a function.

Form Attachment to Menu

1. Finding Menu Name:

Switch Responsibility to the System Administrator.

Navigate to Security > Responsibility > Define.

Find responsibility where you want to configure your customized form and just copy
the Menu and close this window.

A. F. Ferguson & Co. Page 54 of 58

 Customized Form Development Oracle E-Business Suite

2. Assigning Form to Menu:

In System Administrator responsibility, Navigate to Application > Menu.

Find out menu which you have copied from the prior screen i.e.: AP_NAVIGATE_GUI2

Create a new line at the end and enter:

Seq : Assign Sequence Number.
Prompt : Enter the name of form which will be shown to end user.
Function : Select the name of the function which you defined in the step 1 of point #
6.

A. F. Ferguson & Co. Page 55 of 58

Customized Form Development Oracle E-Business Suite

A. F. Ferguson & Co. Page 56 of 58

 Customized Form Development Oracle E-Business Suite

Item Property Setting Commands

ENTERABLE
APP_ITEM_PROPERTY.SET_PROPERTY(ITEMID, ENTERABLE,PROPERTY_ON);

Equivalent To:
SET_ITEM_INSTANCE_PROPERTY(ITEMID, CURRENT_RECORD,INSERT_ALLOWED,
PROPERTY_ON);
SET_ITEM_INSTANCE_PROPERTY(ITEMID, CURRENT_RECORD,UPDATEABLE, PROPERTY_ON);
SET_ITEM_INSTANCE_PROPERTY(ITEMID, CURRENT_RECORD,NAVIGABLE, PROPERTY_ON);

Also Equivalent To
SET_ITEM_PROPERTY(ITEMID, INSERT_ALLOWED, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, UPDATEABLE, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, NAVIGABLE, PROPERTY_ON);

DISPLAYED:
APP_ITEM_PROPERTY.SET_PROPERTY(ITEMID, DISPLAYED,PROPERTY_ON);

Equivalent To:
SET_ITEM_PROPERTY(ITEMID, DISPLAYED, PROPERTY_ON);

If the item is not a Display Item then also set:

SET_ITEM_PROPERTY(ITEMID, ENABLED, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, NAVIGABLE, PROPERTY_ON);

If the item is neither a Display Item nor a Button:

SET_ITEM_PROPERTY(ITEMID, QUERYABLE, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, INSERT_ALLOWED, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, UPDATEABLE, PROPERTY_ON);

ENABLED:
APP_ITEM_PROPERTY.SET_PROPERTY(ITEMID, ENABLED,PROPERTY_ON);

Is equivalent to (for a Text Item or a List Item):

SET_ITEM_PROPERTY(ITEMID, INSERT_ALLOWED, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, UPDATEABLE, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, NAVIGABLE, PROPERTY_ON);

It is equivalent to (for a Button):

SET_ITEM_PROPERTY(ITEMID, ENABLED, PROPERTY_ON);

It is equivalent to (if item is not a Text Item, List, or Button):

A. F. Ferguson & Co. Page 57 of 58

 Customized Form Development Oracle E-Business Suite

SET_ITEM_PROPERTY(ITEMID, ENABLED, PROPERTY_ON);

SET_ITEM_PROPERTY(ITEMID, INSERT_ALLOWED, PROPERTY_ON);
SET_ITEM_PROPERTY(ITEMID, UPDATEABLE, PROPERTY_ON);

REQUIRED:
APP_ITEM_PROPERTY.SET_PROPERTY(ITEMID, REQUIRED,PROPERTY_ON);

Is Equivalent To:
SET_ITEM_PROPERTY(ITEMID, REQUIRED, PROPERTY_ON);

A. F. Ferguson & Co. Page 58 of 58