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
>>
Next
Next
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
Next
Next
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
Next
Frame title :- XX_EVO_EMPBIODATA
Record display 5 (Display Only 5 Row on Form)
Display scroll bar checked (Scroll Ball Display on Form)
Next
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
Search
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.