OracleApps02: Create Simple D2K Form

Create table XX_EVO_EMPBIODATA (sequence_id number,name varchar2(22),Degree_name varchar2(22),

percentage varchar2(22),

grade varchar2(22),

department_name varchar2(33),

year_of_passing date,

created_by number,

last_updated_by number,

last_update_login number,

creation_date date,

last_update_date date);

Create sequence XX_EVO_EMPBIODATA_SEQ start with 100 increment by 1;

After this click on template then automatically open the form builder

Click on save. And give a name (ex:- XX_EVO_EMPBIODATA)

F4 on Template

Name :- XX_EVO_EMPBIODATA

Subclass information :- Module

After this

==================Data Block===============================

Click on Data Blocks

Then click on (+) operator Then Build a new data block manually

F4 on recently created block ex(Block1)

Change the name

Name :- XX_EVO_EMPBIODATA_DB

Subclass information :- TEXT_ITEM

Then save it

Again that data block right click then choose (ex XX_EVO_EMPBIODATA_DB)

Data block wizard

Table or view

Specify our Table Name (XX_EVO_EMPBIODATA )

Refresh

Finish

=======================Canvas==================================

Then go to canvas

Click on + operator

Then F4 on that canvas (ex :- canvas2)

Name :- XX_EVO_EMPBIODATA_CN

Subclass information :- Canvas

Again right click on that canvas (ex :- XX_EVO_EMPBIODATA_CN)

Choose

Layout wizard

Move the column which we want to display on form

Degree_name ,

Percentage,

grade,

department_name ,

year_of_passing

Width 1.5 to all column

Tabular

Frame title :- XX_EVO_EMPBIODATA

Record display 5 (Display Only 5 Row on Form)

Display scroll bar checked (Scroll Ball Display on Form)

Finish

Manage the layout

=====================Window==============================

The go to window

Click on (+) operator

F4 on that window name ex(WINDOW2)

Change name

Name :- XX_EVO_EMPBIODATA_WN

Subclass information:- Window

======================================End the Development======================

===================Start Settings or Coding======================================

Then go to Main Trigger

Click on

Pre_form

In that

The block name change

Give our widow name

Example:-

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('XX_EVO_EMPBIODATA_WN', 'FIRST_WINDOW');

Again go to our canvas click F4 on that

In the field of

Window :=XX_EVO_EMPBIODATA_WN

Again go to out of template F4 on that

In the Console Window field :-

Console window :- XX_EVO_EMPBIODATA_WN

First navigation data block := XX_EVO_EMPBIODATA_DB

After this Go to

Program unit

Choose app_custom (package_body) (double click on this)

package body app_custom is

procedure close_window(wnd in varchar2) is

This procedure is called whenever the user closes a window, as

a result of the WHEN-WINDOW-CLOSED trigger firing. You are responsible

for supplying unqiue code that addresses the needs of each window, such as

deferring master-detail relations, or closing related windows.

Other windows that will be referenced into your form rely on the default

code at the beginning and end of this procedure - under no circumstances

should you modify that code.

begin

THE FOLLOWING CODE MUST NOT BE MODIFIED. It prevents windows from closing

while in enter-query mode.

if (name_in('system.mode') = 'ENTER-QUERY') then

app_exception.disabled;

return;

end if;

YOU MUST MODIFY THE FOLLOWING CODE to account for specific behaviors of your

form, including:

1. identifying the 'first window' of the form and treating

a close window on that window like a close form.

2. deferring master-detail relations for detail blocks that

exist in other windows.

3. closing other related windows.

The default code at the end of this procedure actually closes the window.

If you do that yourself in this code, issue a 'return;' at the end of

your logic for your specific windows.

if (wnd = 'XX_EVO_EMPBIODATA_WN') then

app_window.close_first_window;

elsif (wnd = '<another window>') then

--defer relations

--close related windows

null;

elsif (wnd = '<yet another window>') then

--defer relations

--close related windows

null;

end if;

THE FOLLOWING CODE MUST NOT BE MODIFIED. It ensures the cursor is not in

the window that will be closed (by moving it to the previous block if

needed), and actually closes the specified window.

if (wnd = get_view_property(get_item_property(:SYSTEM.CURSOR_ITEM,

ITEM_CANVAS), WINDOW_NAME)) then

do_key('PREVIOUS_BLOCK');

end if;

hide_window(wnd);

end close_window;

procedure open_window(wnd in varchar2) is

This procedure should be called from any code that could result

in a non-modal window being opened.

begin

YOU MUST MODIFY THE FOLLOWING CODE to account for specific behaviors of your

form, including:

1. Positioning the window to be opened

2. Resetting master-detail relations for blocks in the window

3. navigation to a block in that window

if (wnd = 'XX_EVO_EMPBIODATA_WN') then

--position the window

--reset master-detail relations

--navigate to a block in the window

null;

elsif (wnd = '<another window>') then

--position the window

--reset master-detail relations

--navigate to a block in the window

null;

elsif (wnd = '<yet another window>') then

--position the window

--reset master-detail relations

--navigate to a block in the window

null;

end if;

end open_window;

end app_custom;

====================Assign .FMB Form to Request Group================================

Then go to our front end

Application developer

Application

Form

Form:- XX_EVO_EMPBIODATA

APPLICATION:= Inventory

User form name := user biodata

Save and close

Then go to function

Function :- EMPLOYEE DADA

Use function name:= EMPLOYEE DADA

Then go to properties

Type := Form

Form := User biodata

Save and close

Then click on Menu

F11

Inventory menu name like

(INV_NAVIGATE)

Ctrl+ F11

New

Seq:-377 (any number)

Prompt :- user data

Fuction :- EMPLOYEE DADA

Save it

Then go to inventory responsibility and check the Form name is display or not.But the form is not open

Because of .fmx file is not generate

For that Go to WinSEP

Move the .fmb file to $AU top

The file is XX_EVO_EMPBIODATA.fmb

After Moving the .FMB File

Open Putty

With the help of cd command go to $AU top

And Run this program

frmcmp_batch XX_EVO_EMPBIODATA.fmb userid=apps/apps output_file=/u02/appltst/TEST_APPS/fs1/EBSapps/appl/inv/12.0.0/forms/US/XX_EVO_EMPBIODATA.fmx

Now Check the Form is open or not.

Note:- If you want to change in FMB you can change it but make sure the .FMB is Move on $AU Top or latest .FMX has generated but before generate the .FMX Make sure the Form is Closed.