Sunday 15 September 2013

How to compile forms/Library in R12?


frmcmp stands for form compile.

For help use below command.

[applvision@apps comn]$ frmcmp_batch help=y
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release  - Production

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE     10.1.0.5.0      Production

Usage: frmcmp Module=<formname> Userid=<userid/password> [Parameters].
Optional parameters are (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.
[applvision@apps comn]$



Compiling form (INVDVFDH.fmb)
scenario:
1) Login to application server as applmgr uer.

2)Navigate to the path $AU_TOP/forms/US
[applvision@apps US]$  cd /apps/vision/apps/apps_st/appl/au/12.0.0/forms/US
[applvision@apps US]$ pwd
/apps/vision/apps/apps_st/appl/au/12.0.0/forms/US
[applvision@apps US]$


3)Moved the attached fmb(INVDVFDH.fmb) in binary mode to $AU_TOP/forms/US and compile it.

[applvision@apps US]$ frmcmp_batch userid=apps/apps module=INVDVFDH.fmb output_file=INVDVFDH.fmx module_type=form batch=no compile_all=yes
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release  - Production

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
     With the Partitioning, OLAP, Data Mining and Real Application Testing options
PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE     10.1.0.5.0      Production
Compiling package specification APP_CUSTOM...
   No compilation errors.

Compiling package specification DH_ITEMS...
   No compilation errors.

Compiling package specification CONTROL...
   No compilation errors.

Compiling package specification D_HISTORIES...
   No compilation errors.

Compiling package specification INVDVFDH...
   No compilation errors.

Compiling package specification DH_ITEM_FIND2...
   No compilation errors.

Compiling package specification APP_CUSTOM...
   No compilation errors.

Compiling package body APP_CUSTOM...
   No compilation errors.

Compiling package specification DH_ITEMS...
   No compilation errors.

Compiling package body DH_ITEMS...
   No compilation errors.

Compiling package specification CONTROL...
   No compilation errors.

Compiling package body CONTROL...
   No compilation errors.

Compiling package specification D_HISTORIES...
   No compilation errors.

Compiling package body D_HISTORIES...
   No compilation errors.

Compiling package specification INVDVFDH...
   No compilation errors.

Compiling package body INVDVFDH...
   No compilation errors.

Compiling package specification DH_ITEM_FIND2...
   No compilation errors.

Compiling package body DH_ITEM_FIND2...
   No compilation errors.

Compiling KEY-F9 trigger on form...
   No compilation errors.

Compiling KEY-F0 trigger on form...
   No compilation errors.

Compiling KEY-F1 trigger on form...
   No compilation errors.

Compiling KEY-F2 trigger on form...
   No compilation errors.

Compiling KEY-F3 trigger on form...
   No compilation errors.

Compiling KEY-F4 trigger on form...
   No compilation errors.

Compiling KEY-F5 trigger on form...
   No compilation errors.

Compiling KEY-F6 trigger on form...
   No compilation errors.

Compiling KEY-F7 trigger on form...
   No compilation errors.

Compiling KEY-F8 trigger on form...
   No compilation errors.

Compiling PRE-POPUP-MENU trigger on form...
   No compilation errors.

Compiling MENU_TO_APPCORE trigger on form...
   No compilation errors.

Compiling WHEN-FORM-NAVIGATE trigger on form...
   No compilation errors.

Compiling STANDARD_ATTACHMENTS trigger on form...
   No compilation errors.

Compiling ZOOM trigger on form...
   No compilation errors.

Compiling CLOSE_THIS_WINDOW trigger on form...
   No compilation errors.

Compiling LASTRECORD trigger on form...
   No compilation errors.

Compiling EXPORT trigger on form...
   No compilation errors.

Compiling APPCORE_TO_CALENDAR trigger on form...
   No compilation errors.

Compiling MULTI_RETURN_ACTION trigger on form...
   No compilation errors.

Compiling ACCEPT trigger on form...
   No compilation errors.

Compiling CLOSE_WINDOW trigger on form...
   No compilation errors.

Compiling KEY-CLRFRM trigger on form...
   No compilation errors.

Compiling KEY-COMMIT trigger on form...
   No compilation errors.

Compiling KEY-DUPREC trigger on form...
   No compilation errors.

Compiling KEY-EDIT trigger on form...
   No compilation errors.

Compiling KEY-EXIT trigger on form...
   No compilation errors.

Compiling KEY-HELP trigger on form...
   No compilation errors.

Compiling KEY-LISTVAL trigger on form...
   No compilation errors.

Compiling KEY-MENU trigger on form...
   No compilation errors.

Compiling ON-ERROR trigger on form...
   No compilation errors.

Compiling PRE-FORM trigger on form...
   No compilation errors.

Compiling PRE-INSERT trigger on form...
   No compilation errors.

Compiling PRE-QUERY trigger on form...
   No compilation errors.

Compiling PRE-UPDATE trigger on form...
   No compilation errors.

Compiling POST-FORM trigger on form...
   No compilation errors.

Compiling POST-QUERY trigger on form...
   No compilation errors.

Compiling QUERY_FIND trigger on form...
   No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-NEW-FORM-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on form...
   No compilation errors.

Compiling WHEN-VALIDATE-RECORD trigger on form...
   No compilation errors.

Compiling WHEN-WINDOW-CLOSED trigger on form...
   No compilation errors.

Compiling WHEN-TAB-PAGE-CHANGED trigger on form...
   No compilation errors.

Compiling WHEN-RADIO-CHANGED trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-OTHERS trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-NEXT-ITEM trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-PREV-ITEM trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-ENTER trigger on CALENDAR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CALENDAR data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on CALENDAR data block...
   No compilation errors.

Compiling WHEN-MOUSE-CLICK trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-DOWN trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-UP trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-NXTREC trigger on CALENDAR data block...
   No compilation errors.

Compiling KEY-PRVREC trigger on CALENDAR data block...
   No compilation errors.

Compiling WHEN-MOUSE-DOUBLECLICK trigger on CALENDAR data block...
   No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on TIMEZONE_NAME item in CALENDAR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on SHOW_TIMEZONES_DATETIME item in CALENDAR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block...
   No compilation errors.

Compiling PRE-QUERY trigger on DH_ITEMS data block...
   No compilation errors.

Compiling POST-QUERY trigger on DH_ITEMS data block...
   No compilation errors.

Compiling KEY-NXTBLK trigger on DH_ITEMS data block...
   No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on DH_ITEMS data block...
   No compilation errors.

Compiling WHEN-CLEAR-BLOCK trigger on DH_ITEMS data block...
   No compilation errors.

Compiling KEY-CLRREC trigger on DH_ITEMS data block...
   No compilation errors.

Compiling KEY-F2 trigger on DH_ITEMS data block...
   No compilation errors.

Compiling KEY-F3 trigger on DH_ITEMS data block...
   No compilation errors.

Compiling KEY-CREREC trigger on DH_ITEMS data block...
   No compilation errors.

Compiling PRE-BLOCK trigger on DH_ITEMS data block...
   No compilation errors.

Compiling POST-BLOCK trigger on DH_ITEMS data block...
   No compilation errors.

Compiling SELECT_ALL trigger on DH_ITEMS data block...
   No compilation errors.

Compiling DESELECT_ALL trigger on DH_ITEMS data block...
   No compilation errors.

Compiling WHEN-MOUSE-CLICK trigger on DH_ITEMS data block...
   No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on DH_ITEMS data block...
   No compilation errors.

Compiling KEY-DELREC trigger on DH_ITEMS data block...
   No compilation errors.

Compiling QUERY_FIND trigger on DH_ITEMS data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in DH_ITEMS data block...
   No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on DH_ITEM_FIND data block...
   No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on CATEGORY_SET_NAME item in DH_ITEM_FIND data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on FIND item in DH_ITEM_FIND data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on RESET item in DH_ITEM_FIND data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on D_HISTORIES data block...
   No compilation errors.

Compiling POST-QUERY trigger on D_HISTORIES data block...
   No compilation errors.

Compiling WHEN-MOUSE-CLICK trigger on DRILLDOWN_RECORD_INDICATOR item in D_HISTORIES data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on ITEM_NUMBER item in D_HISTORIES data block...
   No compilation errors.

Compiling KEY-LISTVAL trigger on PERIOD_START_DATE item in D_HISTORIES data block...
   No compilation errors.

Compiling KEY-LISTVAL trigger on PERIOD_START_DATE_MIRROR item in D_HISTORIES data block...
   No compilation errors.

Compiling KEY-NXTBLK trigger on CONTROL data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on DETAIL item in CONTROL data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on SORT_OPTS item in CONTROL data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on HISTORY item in CONTROL data block...
   No compilation errors.

Compiling KEY-LISTVAL trigger on START_DATE item in CONTROL data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on START_DATE item in CONTROL data block...
   No compilation errors.

Compiling KEY-LISTVAL trigger on END_DATE item in CONTROL data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on END_DATE item in CONTROL data block...
   No compilation errors.

Compiling KEY-EXIT trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-DOWN trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-CREREC trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-COMMIT trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-CLRREC trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-CLRBLK trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-NXTREC trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-CLRFRM trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-UP trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling KEY-PRVREC trigger on PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJECT_TYPE item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJ1 item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJ2 item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJ4 item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on OBJ3 item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on PROP item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on UPDATE_PROPERTIES item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on REFRESH item in PROGRESS_INDICATOR data block...
   No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_PROPERTIES item in PROGRESS_INDICATOR data block...
   No compilation errors.


Created form file INVDVFDH.fmx
[applvision@apps US]$



5) Transfer the .fmx file to the respective Top.

[applvision@apps US]$ ls -tlrh INVDVFDH.fmx
-rw-r--r-- 1 applvision applmgr 325K Sep 15 13:13 INVDVFDH.fmx
[applvision@apps US]$ cp -r INVDVFDH.fmx $INV_TOP/forms/US/
[applvision@apps US]$




Compiling libarary
==============

[applvision@apps resource]$ frmcmp_batch userid=apps/apps module=$AU_TOP/resource/RCVRCERH.pll output_file=$AU_TOP/resource/RCVRCERH.plx module_type=library batch=no compile_all=special.
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release  - Production

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
     With the Partitioning, OLAP, Data Mining and Real Application Testing options
PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE     10.1.0.5.0      Production
Compiling library RCVRCERH...
  Invalidating Package Spec RCV_HEADER_TH......
  Invalidating Package Spec RCV_HEADER_EH......
  Invalidating Package Spec RCV_HEADER......
  Invalidating Package Body RCV_HEADER_TH......
  Invalidating Package Body RCV_HEADER_EH......
  Invalidating Package Body RCV_HEADER......
  Invalidating Procedure Body FDRCSID......
  Compiling Package Spec RCV_HEADER_TH......
  Compiling Package Spec RCV_HEADER_EH......
  Compiling Package Spec RCV_HEADER......
  Compiling Package Body RCV_HEADER_TH......
  Compiling Package Body RCV_HEADER_EH......
  Compiling Package Body RCV_HEADER......
  Compiling Procedure Body FDRCSID......
 Done.
[applvision@apps resource]$




How to find the forms version?

[applvision@apps comn]$ $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
[applvision@apps comn]$


1 comment:

  1. Hi Wasiq, I was trying to do the compilation in latest VISION installation, looks like the ENV file not loaded, could you pls help me with that?
    Regards,

    binukmathew@gmail.com

    ReplyDelete