Steps to Develop Oracle Apps Custom Form

Form Name                  :  XX_Sample.fmb

Deployed Application  :  Order Management

Responsibility              :  N01 OM Access

STEP 1: COPYING FILES FROM THE SERVER

a) Copy TEMPLATE.fmb file from $AU_TOP/forms/US folder to a local directory.      Also download APPSTAND.fmb file and place it in your form directory (for me its  D:\DevSuiteHome_1\forms).

b) Copy All PL/SQL Libraries from $AU_TOP/resource/US folder (one time only).  Download all the .pll and .plx files to your form directory (for me its    D:\DevSuiteHome_1\forms).

STEP 2: DESIGN THE FORM IN ORACLE FORMS BUILDER

a) Remove the Defaults

              >Open Oracle Forms Builder

              >Open the form TEMPLATE.fmb

              >Rename the form (ex XX_SAMPLE)

               >Delete the followings from object navigator.

                      >Go to Data Blocks and delete BLOCKNAME, DETAILBLOCK

                      >Go to Windows and delete BLOCKNAME
                      >Go to Canvases and delete BLOCKNAME

b) Create a new Window and rename it (ex XX_SAMPLE_WIN). Open the property  palate, assign Subclass Information as Window.

To open the property palate select the object and press F4.

NOTE: Assign ‘Subclass Information’ for each and every object you create.

c) Create a new Content Canvas and rename it (ex XX_SAMPLE_CAN). Provide ‘Subclass Information’ as Canvas and attach it to the new Window (XX_SAMPLE) via Property Palate.

Subclass Information for Content Canvas ->  CANVAS

Subclass Information for Stacked Canvas ->  CANVAS_STACKED

Subclass Information for Tab Canvas        ->  TAB_CANVAS

d) Create a new Data block using Data Block Wizard and name it (ex XX_DEPT_BLK). Provide ‘Subclass Information’ as Block. Also provide Subclass Information for all block items (i.e. for  DEPTNO,DNAME,LOC).

e) Modify the PRE-FORM Trigger

  >Go to triggers --> PRE-FORM

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

                      

  >Modified Code:

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

  FND_STANDARD.FORM_INFO(‘$Revision: 1.0 $’, ‘XXARCUST_1’,’CUST_FORM’,

  ’$Date: 2010/01/06 16:25  $’, ‘$Author: Laxya $’);

   app_standard.event(‘PRE-FORM’);

    app_window.set_window_position(‘XX_SAMPLE_WIN′, ‘FIRST_WINDOW’);

               > Compile the code and Save it.

f) Modification for Program unit

             > Go to APP_CUSTOM*(Package Body)

             >Type your First window name in place of <your first window>

             > Compile the code

STEP 3: DEPLOY THE FORM IN THE SERVER

                         > Upload your .fmb file to the server.

STEP 4: CREATE THE .fmx FILE IN THE SERVER IN DESIRED TOP

>Compile command in UNIX R12

#For R12
$ORACLE_HOME/bin/frmcmp_batch module=$HOME/laxya/XX_SAMPLE_EMP.fmb userid=<username>/<password>  output_file=/$ONT_TOP/forms/US/XX_SAMPLE_EMP.fmx module_type=form  compile_all=special

#For R11i
$ORACLE_HOME/bin/f60gen module=$HOME/laxya/XX_SAMPLE_EMP.fmb userid=<username>/<password>  output_file=$ONT_TOP/forms/US/XX_SAMPLE_EMP.fmx module_type=form  compile_all=special

STEP 5: REGISTERING THE FORM IN ORACLE APPS

a) Registering the FORM in Oracle Apps

> Go to Application Developer  —> Application —> Form

                        > Give the details:

                         FORM                  : XX_SAMPLE(name of the custom form) 

                         APPLICATION   : Order Management

                         User Form Name : XX_SAMPLE FORM

                         Description          : Sample form

                        > save

b) Registering the FORM to a form function

                        > System Administrator —->Application —-> Function

                        > Give the details:

                         Form                          : XX_SAMPLE

                         Function                    : XX_SAMPLE

                         APPLICATION         : Order Management

                         Properties —> Type  : Form

                         User Function Name : XX_SAMPLE Function

                        > save

c) Finding the menu to which the above form function is to be attached. Again the menu is attached to a responsibility. So we have go in the reverse order to find the menu name.

      > System Administrator —->Security —-> Responsibility —->Define

      > Press F11

      > Responsibility Name: N01%OM%Acc% (searching for N01 OM Access )

      > Press Ctrl + F11

     > This things will come in the form

                Responsibility Name: N01 OM Access

                Application: Order Management (will come automatically )

     >Take the Menu name   —> ONT_SUPER_USER - India

                      

d) Attaching the function to a Submenu of the above Main menu

                        > System Administrator —->Application —> Menu

                        > Press F11

                        >User Menu Name : ONT_SUPER_USER - India

                         > Press Ctrl+F11

                        > Create a new

                        > Prompt : Sample Form (It will display in the navigator)

                        >Function: XX_SAMPLE (Attach the function to the submenu XX Custom)

                        > save

                        >One request has been submitted to recompile your menus in the database

e) Viewing the request submitted in the background to recompile the menus to attach the function

                        > Go to View——–>Requests———>Find

                        >The status should be :Compiled  Normal

STEP 6: VIEWING THE FORM IN ORACLE APPLICATION

                        >Go to Oracle apps front end.

                        >Login with username and password

                        >Go to N01 OM Access —> XX Custom —> Sample Form

ENJOY LEARNING!