Wednesday, January 5, 2011

Running Custom Form in Oracle Applications (R12)

Here are the step by step information , how you can use your custom form in Oracle Applications. I created this form in the PO module, you can choose as you desire.
1- Create Form
Create your form using Oracle Form Builder like below.


Compile this form on the same location using CTL+T from the form builder or as below.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\oracle\PROD\apps\apps_st\appl>echo %PO_TOP%
C:\oracle\PROD\apps\apps_st\appl\po\12.0.0
C:\oracle\PROD\apps\apps_st\appl>cd %PO_TOP%\forms\US
C:\oracle\PROD\apps\apps_st\appl\po\12.0.0\forms\US>C:\oracle\PROD\apps\tech_st\10.1.2\BIN\frmcmp.exe module=POAPPTEST.fmb
 userid=APPS/APPS output_file=POAPPTEST.fmx module_type=form compile_all=special

C:\oracle\PROD\apps\apps_st\appl\po\12.0.0\forms\US>frmcmp

2- Create Application and Menu
For details go to this post Users, Data Groups and Menus
3- Register the Form 
Use application > Form from System Administrator responsibility, enter appropriate data like below

4- Register the Forms Function
Use application > Function from System Administrator responsibility, enter appropriate data like below.
You need to use different tab pages



5-   Add Menu Item
Now add a menu item so that this forms function becomes available to specific responsibility.

6- Test your newly created form
Log in with the user  who has the responsibility for your newly created form (see step 5)

Observe new Item under responsibility, Click on it
Congratulations, your new form is running under R12 environment


No comments:

Post a Comment