Oracle Forms : How to compile on Unix in 11i and R12

Login to Application Server on Unix Box for Compiling Forms

R11i

f60gen module=CUSTOM.pll userid=apps/(appspwd) module_type=LIBRARY batch=NO compile_all=special output_file=$AU_TOP/resource/CUSTOM.plx

f60gen module=XXPOCF.fmb userid=apps/(appspwd) module_type=form batch=no compile_all=special output_file=$XXPO_TOP/forms/US/XXPOCF.fmx

R12

$ORACLE_HOME/bin/frmcmp_batch module_type=LIBRARY module=$AU_TOP/resource/CUSTOM.pll userid=apps/(appspwd)output_file=$AU_TOP/resource/CUSTOM.plx compile_all=special

$ORACLE_HOME/bin/frmcmp_batch module=$XXFND_TOP/forms/US/XXFND_FHLOG.fmb userid=apps/(appspwd) output_file=$XXFND_TOP/forms/US/XXFND_FHLOG.fmx module_type=form compile_all=special

--------------------------------------------------------------------------------------------------------------------

Monday, March 5, 2012

FRMCMP for FMB and PLL compilation

 frmcmp Module=<pll name> Userid=<userid/password> [Parameters].

 Optional parameters with default values given:

Module_Type=FORM            Module type (FORM, MENU, LIBRARY). Statistics=NO                          Show statistics. Logon=YES                               Logon to database. Batch=NO                                Don't display messages on the screen. Output_File=<file>                Write output to file. Script=NO                                Write script file. Parse=NO                                Parse script file. Upgrade=NO                          Upgrade module to current version. Upgrade_Roles=NO              Upgrade SQL*Menu 5.0 role information. Version=45                             Version to upgrade (23, 30, 40, 45, or menu 50). Crt_File=<crt file>                 CRT file for version 2.x form upgrade. Build=Yes                               Build a runform/runmenu file when upgrading. Add_Triggers=NO                Add KEY-UP/DOWN triggers during upgrade. Nofail=NO                             Add NOFAIL keyword to trigger steps. Debug=NO                            Build/Run with debug information. Compile_All=NO                  Compile all PL/SQL code. Strip_Source=NO                 Strip pl/sql source code from library. Window_State=Normal     Root window state: (Normal, Maximize, Minimize.) Help=NO                                Show this help information. Options_Screen=NO           Display Options window (on bitmap only). Widen_Fields=NO               Add one character to display width. Print_Version=NO              Print version used to save module. Forms_Doc=NO                   Print Forms Doc report.

Example:

If we want to compile PLL the the syntax is:

frmcmp module=<path of pll file> userid=apps/<pwd> output_file=<path for generating plx> module_type=LIBRARY batch=yes compile_all=special 

or

frmcmp_batch module=CUSTOM.pll userid=apps/appspass output_file=CUSTOM.plx module_type=LIBRARY compile_all=special 

**************************************************************************************************

If we want compile forms FMB then:

In R12

frmcmp  module=$AU_TOP/forms/US/CUSTOM_OE.fmb userid=apps/appspassword output_file=$PRODUCT_TOP/forms/USCUSTOM_OE.fmx module_type=form compile_all=yes

or

frmcmp_batch  module=$AU_TOP/forms/US/CUSTOM_OE.fmb userid=apps/appspassword output_file=$PRODUCT_TOP/forms/USCUSTOM_OE.fmx module_type=form compile_all=yes

In 11i

f60gen module=$AU_TOP/forms/US/CUSTOM_OE.fmb  userid=apps/appspassword output_file=$PRODUCT_TOP/forms/USCUSTOM_OE.fmx module_type=form compile_all=yes