Oracle Basics for Custom Form Development
The below are the steps to follow to develop a basic Custom form
in EBS.
Download the Resource folder from the server and place in local
directory.
Right Click on form builder--> Select properties -->
In Start field : <resource folder path>
Creating Table:
Create table with who columns, flex field columns and Database
Columns.
Registering Table and Columns:
When table contains flexfield columns or alert columns the table
and columns need to be registered in the application.
Creating Main Form:
1. Download TEMPLATE.fmb and APPSTAND.fmb from server and
place the files in resource folder.
2. Now open TEMPLATE.fmb in form builder and rename the file.
3. Remove the Defaults
>Open Oracle Forms Builder
>Open the form TEMPLATE.fmb
>Rename the form (ex XX_abcd1)
>Delete the followings from object nevigator.
>Go to Data Blocks and delete BLOCKNAME, DETAILBLOCK
>Go to Windows and delete BLOCKNAME
>Go to Canvases and delete BLOCKNAME
4. Create new window,canvas and data block.
5. Modify the PRE-FORM Trigger
>Go to triggers—PREFORM
>Original Code:
FND_STANDARD.FORM_INFO(‘$Revision: 120.0 $’, ‘Template Form’, ‘FND’,
‘$Date: 2005/05/06 23:25 $’, ‘$Author: appldev $’);
app_standard.event(‘PRE-FORM’);
app_window.set_window_position(‘BLOCKNAME’, ‘MAIN_WINDOW’);
>Modified Code:
FND_STANDARD.FORM_INFO('$Revision: 1.0 $', 'XXCUST_10418','CUST_FORM_10418',
'$Date: 2017/03/23 11:00 $', '$Author: Danish
Halim $');
app_standard.event('PRE-FORM');
app_window.set_window_position('CUSTOMERS', 'MAIN_WINDOW');
> Compile the code
6. Modification for Program unit
> Go to APP_CUSTOM*(Package Body)
>Type your First window name in place of <your first window>
> Compile the code
7. If any Item in the Datablock is of Date type and you
want to attach a standard calender to it, do the following
> Go to Text Item> Property palate > Subclass Information >
Property Class
> Give property class name as TEXT_ITEM_DATE
> Attach LOV as ENABLE_LIST_LAMP
> Create KEY-LISTVAL item level trigger & add following code into it
calendar.show;
and compile the trigger.
Compiling & Registering Form :
1. Deploy .fmb file in the server in AU_TOP/version/forms/US
2. Compile the fmb file in putty using below steps
A) cd appl_top
B) find *.env
C) . ./<First environment
variable ex: APPSUAT_ebs12training.env>
D) cd au_top/version/forms/US
E) frmcmp_batch userid=apps/apps
module=<form name>.fmb output_file=CUST_TOP/version/forms/US/<form
name>.fmx module_type=form batch=no compile_all=special
F) Now register form under
Application Developer -> Application -> Form
G) Register Function System
Administrator —>Application —> Function
H) Register Menu and
Responsibility.
Assigning WHO Columns :
1. Apply the CREATION_OR_LAST_UPDATE_DATE property class to
the form fields CREATION_DATE and LAST_UPDATE_DATE. This property classes sets
the correct attribute values like data type and width.
2. Create PRE_INSERT AND PRE_UPDATE triggers under datablock
with
fnd_standard.set_who();
Creating QUERY_FND form:
1. Drag QUERY_FIND Object Group from APPSTAND.fmb to Our Form
Object Group. Here we get window,canvas,datablock will come
automatically with the name QUERY_FIND.
2. Apply subclass information to QUERY_FND Window,Canvas as
well as Block. And drag these to first position.
3. In QUERY_FIND data block we get 3 buttons(Clear,New,Find)
with 3 Triggers.
4. Give Block name as <main forms data block name>
in WHEN-BUTTON-PRESSED trigger of New and Find Button. Compile and close.
5. Open the QUERY_FND canvas and create test items.
6. Next drag the QUERY_FIND trigger from APPSTAND.fmb and
Place it in Main forms data block level trigger.
--APP_STANDARD.EVENT('QUERY_FIND');
APP_FIND.QUERY_FIND(<results block window>, <Find
window>, <Find window block>);
Ex:
APP_FIND.QUERY_FIND('CUSTOMERS','QUERY_FIND','QUERY_FIND');
7. Create pre_query trigger in main forms block
IF :parameter.G_query_find = 'TRUE' THEN
COPY (<find Window field>,<results field>);
Ex: COPY(:QUERY_FIND.customer_id, 'customers.customer_id');
:parameter.G_query_find := 'FALSE';
END IF;
8. In the form module give the first navigation block as
QUERY_FIND. In the QUERY_FIND datablock give next navigation block as MAIN
DATA BLOCK.
9. Save and move to server.
