add

About Me

My photo
Oracle Apps - Techno Functional consultant

Tuesday, June 21

Oracle Forms Process

1)We Will download the TEMPLETE.fmb from AU_TOP\Resource Folder
Application Utilities

2)Open with Forms6i builder and delete the existing Block Canvas Window
3)Create New Block , Canvas , Window attach oracle apps Property classes

4)Develop the form as per client requirement

Note:We will change the Property called "First Navigaction Data Block" as Datablock Name
in the Module Properties.

II)Customize folloiwng two triggers1) Pre-Form -New Window Name
2) WHEN-NEW-FORM-INSTANCE -New form Name
3) APP_Custom package -New Window Name

5)Save the form we will get (.fmb)
6)compile the form we will get(.fmx)
(File => Administration => Compile File)

7)Move the .fmb into au_top\11.5.0\Forms\US\ .fmb
8)Move the .fmx into CuS_top\11.5.0\Forms\US\ .fmx

9)Goto Applicaton Developer and create Form

10)create Function attach form to the function

11)Create Menu attach function menu

12)Attach Menu to the responsibility , Responsibility will be attached to the user
so that user can open the form and enter/Query the Data.

---------------------------------------------------------------------------

1)Form Createion :
Application Developer=> Application=>Form
Form Name : .fmx name
Application Name : Application name where .fmx is located
User Form Name : We can give any form Name

2)Function Creation: For single form we can create Multiple Functions and we can pass
the Parameters.
Function Name : Enter any uniquie Name
User Function Name: Enter any uniquie Name
Goto Properties tab select Form type = FORM
Goto the form tab attach the Form what ever we have created.
Save and Copy the User function name attach to the Menu.

3)open the Menu
Enter menu name : Any valid Name
User Menu Name : Any valid Name
Enter the Seqno : Unique Number
Prompt : Any Text
Function : Attach the User Function NAme whatever we have create

4)Copy the User menu name and attach to the Responsibility in system administrator.

TEMPLETE.fmb : It is pre-defined .fmb contains the existing functionality which will
suport for all the Menu,Toolbar, and Other Oracle Applciations features.
that is the Reason we have to start form development with TEMPLETE.fmb

No comments: