In Order to Create Custom Form n integrate it with EBS
• First Create the form on Form builder Run it on local machine.
• Then copy APPSTAND.fmb, TEMPLATE.fmb
From $AU_TOP /form/US
And Copy ALL .plls from $AU_TOP /Resource
In same directory on local machine then
• Set form path i.e. (the directory of these forms and .plls) in registory
Go in RUN => Regedit => HKEY_LOCAL_MACHINE => SOFTWARE=>ORACLE =>
FORM_PATH
E:\DevSuiteHome_2\cgenf61\admin;E:\DevSuiteHome_2\forms;C:\Documents and Settings\aff-
functional\Desktop\EBS_FORM_integration
(Path can be changed but does not contain spaces, can be set as environment variable also)
• Then Open Template.fmb and APPSTAND.fmb in Oracle Form Builder compile then must
compile successfully.
• Create Canvas and a window give reference of window in canvas properties
window in canvas properties and canvas in window properties.
• Set module level properties i.e. change name, first Navigation Block.
• Make sure that all fields, canvases, window , all other objects should inherit the respective
property classes.
• Now put the .fmb files in $AU_TOP then
• Make a compile.sh file with this code
• put The file in /home/oracle/developer/Scripts
• connect to APPS Server by using putty
set form path
. /u01/oracle/PROD/apps/EBSapps.env run
export:
export FORMS_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
• Then go the path of . compile.sh
frmcmp_batch userid=apps/apps_password module=/u01/oracle/TEST/apps/fs2/EBSapps/appl/ap/12.0.0/forms/US/XX_CUSTOM_FORM.fmb
output_file=/u01/oracle/TEST/apps/fs2/EBSapps/appl/ap/12.0.0/forms/US/XX_CUSTOM_FORM.fmx
module_type=form batch=no compile_all=special
For eg: /home/oracle/developer/Scripts
Execute compile.sh
This should return no compilation Error.
And with file creation message message for Eg:
Created form file /d01/oracle/TEST/apps/apps_st/appl/au/12.0.0/forms/US/
XX_CUSTOM_FORM.fmx
• Copy File from path and put it in directory where u want to see the Form
• Now login to Application
• Switch Responsibility Of Oracle application Developer
Register form with Module
Assign form form to Function
Assign Function to menu of Specific Responsibility.(Do this from System administrator also)
• Switch to Responsibility where u register the form.
