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
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
> 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
> Upload your .fmb file into au top
Step 6: Open Putty, go to Custom path and create the .fmx file in the server
frmcmp_batch module=XX_NEW_FORM.fmb userid=APPS/xxxmaniapps output_file='/u04/xxxprod/apps/apps_st/appl/xxms/12.0.0/forms/US/XX_NEW_FORM.fmx' module_type=form compile_all=special
Step 7: REGISTERING 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:
> System Administrator —->Security —-> Responsibility —->Define
> Press F11
> Responsibility Name:
> Press Ctrl + F11
>Take the Menu name —>
>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
> 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
> 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
