How to develop a new form for Oracle Applications--OVERVIEW

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 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 D:\DevSuiteHome_1\forms

LIST OF .PLL
APPCORE.PLL
APPCORE2.PLL
APPDAYPK.PLL
APPFLDR.PLL
CUSTOM.PLL
FNDMOAC.PLL
FNDSQF.PLL
FV.PLL
GHR.PLL
GLOBE.PLL
GMS.PLL
HRKPI.PLL
JA.PLL
JE.PLL
JL.PLL
OPM.PLL
PQH_GEN.PLL
PSA.PLL
PSAC.PLL
PSB.PLL
VERT.PLL
VERT1.PLL
VERT2.PLL
VERT3.PLL
VERT4.PLL 

Step 2:  Design the form in oracle form builder & Change the form name and Title

a) Remove the Defaults
                        >Open Oracle Forms Builder
                        >Open the form TEMPLATE.fmb
                        >Rename the form
                        >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
c) Create a new Canvas
d) Create a new Data block with items  from a table.

e) Create a frame in the Canvas and attached the items
f) Modify the PRE-FORM Trigger
                        >Go to triggers—PREFORM
                        >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: Lokanadham Thandlam $’);
   app_standard.event(‘PRE-FORM’);
    app_window.set_window_position(‘NEW_WINDOW′, ‘FIRST_WINDOW’);

g) 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: Change First Navigation Block Name

We shall change the First Navigation Block name for the form so that the first block it picks up will be the data block we have created

Click on Form name

View the properties

As you can see the First Navigation Data Block is set to BLOCKNAME by default. Change this to the data block we have created, i.e.XX_SUPPLIER_BLACKLIST.

Step 4: Set the correct subclass information

Set the subclass information for all the form objects, like data block, canvas, window, items, etc. It will be set like the following,

We shall set the subclass for the data block we have created,

Open the properties of the block

Click on Subclass and the subclass popup window will open. Set the correct class name to it.

Click on OK.

Step 5: DEPLOY THE FORM IN THE SERVER

                         > Upload your .fmb file into au top

Step 6: Open Putty,  go to Custom patch and create the .fmx file in the server

>Type the code

frmcmp_batch module=XX_NEW_FORM.fmb userid=APPS/maxmaniapps output_file='/u04/maxprod/apps/apps_st/appl/xxms/12.0.0/forms/US/XX_NEW_FORM.fmx' module_type=form compile_all=special

Step 7: REGISTARING THE FORM IN ORACLE APPS

a) Registering the FORM in Oracle Apps
                        > Go to Application Developer  —> Application —> Form
                        > Give the details:
                        > Save

b) Registaring the FORM to a form function
                        > System Administrator —->Application —-> Function
                        > Give the details:
                        > 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:

                        > Press Ctrl + F11
                        >Take the Menu name   —>

                     
d) Attaching the function to a Submenu of the above Main menu
                        > System Administrator —->Application —> Menu
                        > Press F11
                        > Menu:  

                        > Press Ctrl+F11
                        > Promt:
                        > Submenu:
                     

                        >System Administrator —->Application —> Menu
                        > Press F11
                        > Menu:
                        > Press Ctrl+F11
                        > Create a new
                        > Promt:   (It will display in the navigator)
                        >Function:  Attach the function to the submenu
                        > 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 8: VIEWING THE FORM IN ORACLE APPLICATION:

                        >Go to Oracle apps front end.
                        >Login with username and password
                        >Go to Responsibility —>Open the Supplier Form