Oracle Customized form integration with Oracle EBS:
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
frmcmp_batch module=/d01/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US/
RCL_INDIVIDUAL_SHIFT_CHANGE.fmb userid=apps/apps
RCL_INDIVIDUAL_SHIFT_CHANGE.fmx module_type=form compile_all=special
output_file=/d01/oracle/PROD/apps/apps_st/appl/PO/12.0.0/forms/US/
• put The file in /home/oracle/developer/Scripts
• connect to APPS Server by using putty
set form path
FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US
export FORMS_PATH
• Then go the path of . compile.sh
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/PROD/apps/apps_st/appl/au/12.0.0/forms/US/
RCL_INDIVIDUAL_SHIFT_CHANGE.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.
If Cant see the form login again
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
frmcmp_batch module=/d01/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US/
RCL_INDIVIDUAL_SHIFT_CHANGE.fmb userid=apps/apps
RCL_INDIVIDUAL_SHIFT_CHANGE.fmx module_type=form compile_all=special
output_file=/d01/oracle/PROD/apps/apps_st/appl/PO/12.0.0/forms/US/
• put The file in /home/oracle/developer/Scripts
• connect to APPS Server by using putty
set form path
FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US
export FORMS_PATH
• Then go the path of . compile.sh
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/PROD/apps/apps_st/appl/au/12.0.0/forms/US/
RCL_INDIVIDUAL_SHIFT_CHANGE.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.
If Cant see the form login again
Comments
Post a Comment