Steps to Develop Oracle Apps Custom Form
Form Name : XX_Sample.fmb
Deployed Application : Order Management
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
> Press Ctrl + F11
> This things will come in the form
Responsibility Name
Application: Order Management (will come automatically )
>Take the Menu name
d) Attaching the function to a Submenu of the above Main menu
> System Administrator —->Application —> Menu
> Press F11
>User Menu Name
> 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
No comments:
Post a Comment