Custom Form Development – Steps to follow

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.

 

Ad_dd is the API used to register table and columns.

 

Ex:

EXEC ad_dd.register_table (‘<Application short name>’, ‘<Table name>’, ‘<Transaction Table-T>’);

exec ad_dd.register_table (‘SQLAP’, ‘DOY_TB_CUSTOMERS_DEFN_10418’, ‘T’);

 

EXEC AD_DD.REGISTER_COLUMN (‘<Application short name>’, ‘<Table name>’,'<Column name>’, <Sequence number of column>,’<Data type>’, <Column Width>,'<Nullable>’, ‘<Translatable>’);

 

EXEC AD_DD.REGISTER_COLUMN (‘SQLAP’,’DOY_TB_CUSTOMERS_DEFN_10418′, ‘CUSTOMER_ID’, 1,’NUMBER’,38, ‘Y’, ‘N’);

Note: Column width or Number -38 and for Date-9 if not specified.

 

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: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’, ‘FIRST_WINDOW’);>Modified Code:

   FND_STANDARD.FORM_INFO(‘$Revision: 1.0 $’, ‘XXCUST_10418′,’CUST_FORM_10418’, ‘$Date: 2017/03/23 11:00  $’, ‘$Author: Gayathri $’);

app_standard.event(‘PRE-FORM’);

app_window.set_window_position(‘CUSTOMERS’, ‘FIRST_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 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
3. cd appl_top
4. find *.env
5. . ./<First environment variable ex: APPSUAT_ebs12training.env>
6. cd au_top/version/forms/US
7. 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
8. Now register form under Application Developer -> Application -> Form
9. Register Function System Administrator —>Application —> Function
10. 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_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.

 

Zooming Functionality:

1. Open the form you want to personalize and go to

Help -> Diagnostics -> Custom Code -> Personalize

2. Add a record as seq 10

Description = Creating a menu

Level = Function

Trigger Event = WHEN-NEW-FORM-INSTANCE

This will set a trigger to fire every time we enters into form.

On actions tab insert the values as

Type = Menu

Description = Creating a menu

Menu entry = Menu 1

Menu label = <New menu name>

 

Create a new record as seq 20

Description = Copy values and Call new form

Level = Function

Trigger event = MENU1

On Actions tab select

Seq = 1

Type = Property

Description = Copy value for item

Object Type = Global variable

Target object = <Your target Field name>

Property name = Value

Value = =:<Main Form Block Name>.<Field Name>

 

Seq = 10

Type = Buitlin

Description = Call Form

Builtin type = Launch Function

Function code = <Select Function code of the second form to be opened>       Function name =<Select Function name of the next form to be opened>

 

3. Now open the main form select a record and go to Tools -> ‘Your next form’

Now go to Help -> Diagnostics -> Custom Code -> Personalize

 

4. Create a record for Seq =10

Description = Moving values from global variable

Level = Function

Trigger event = WHEN-NEW-FORM-INSTANCE

Move to actions tab

Insert values as

Seq = 10

Type = Property

Description = Transferring values from global variable

Object type = item

Target object = <Child form block>.<Field name>

Property name = Value

Value = =:global.<Field name specified at target field in step 2 Actions tab seq 1>

Create a new record as

Seq = 11

Type = Builtin

Description = Move to next block

Builtin type = DO_KEY

Argument = Next_Block

Create a new record

Seq = 12

Type = Builtin

Description = Move to next fielf

Builtin type = DO_KEY

Argument = Next_Item