Create custom form and integrate with EBS R12

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.