重新编译单个FORM

1、重新编译单个FORM（Oracle EBS R12.1.1）潍柴动力扬柴-贾渊1、 查找FORM名a) 使用Help-About Oracle Application查询选择对应的窗体，点击帮助菜单：注意：我们看到的文件名有时候却不一定是form真正执行的fmx文件。因为该文件名是Help根据当前form在设计时候为form取的名称。例如在设计form的时候为form取名为a，而真正保存编译的时候我们把文件编译为b.fmx,当我们在浏览这个form的时候，查看到的form名称会显示a.fmx,而不是b.fmx。b) 使用帮助-诊断查询帮助->诊断->属性->项目输入安装时的a

2、pps口令，显示form如下：2、 编译FORMfrmcmp_batch module=/d01/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US/INVTTMTX.fmb userid=APPS/apps output_file=/d01/oracle/PROD/apps/apps_st/appl/inv/12.0.0/forms/US/INVTTMTX.fmx module_type=form compile_all=special也可以写成：frmcmp_batch module=$AU_TOP/12.0.0/forms/US/INVTTM

3、TX.fmb userid=APPS/apps output_file=$INV_TOP/12.0.0/forms/US/INVTTMTX.fmx module_type=form compile_all=special注：module是源文件；outfile是编译后的文件编译结果如下：oracleebs1 scripts$ frmcmp_batch module=/d01/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US/INVTTMTX.fmb userid=APPS/apps output_file=/d01/oracle/PROD/app

4、s/apps_st/appl/inv/12.0.0/forms/US/INVTTMTX.fmx module_type=form compile_all=specialForms 10.1 (Form Compiler) Version .0 (Production)Forms 10.1 (Form Compiler): Release - ProductionCopyright (c) 1982, 2005, Oracle. All rights reserved.Oracle Database 11g Enterprise Edition Release .

5、0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsPL/SQL Version .0 (Production)Oracle Procedure Builder V.0 - ProductionOracle Virtual Graphics System Version .0 (Production)Oracle Multimedia Version .2 (Production)Orac

6、le Tools Integration Version .2 (Production)Oracle Tools Common Area Version .2Oracle CORE .0 ProductionFRM-18108: Failed to load the following objects.Source Module:INVSTAND Source Object: INV_MVT_RECORD_GROUPSSource Module:INVSTAND Source Object: INV_ALERTSSource Module:INV

7、STAND Source Object: INV_PARAMSSource Module:INVTTESR Source Object: SERIAL_ENTRYSource Module:APPSTAND Source Object: STANDARD_FOLDERSource Module:INVSTAND Source Object: INV_STANDARD_PCSource Module:APPSTAND Source Object: STANDARD_PC_AND_VASource Module:APPSTAND Source Object: STANDARD_TOOLBARSou

8、rce Module:INVTTELT.fmb Source Object: INV_LOT_ENTRYSource Module:APPSTAND Source Object: STANDARD_CALENDARCompiling package specification APP_CUSTOM. No compilation errors.Compiling package specification FH_HEADER. No compilation errors.Compiling package specification TRX. No compilation errors.Com

9、piling package specification HEADER. No compilation errors.Compiling package specification DETAIL_LAYOUT. No compilation errors.Compiling package specification LOT_ENTRY_CUSTOM. No compilation errors.Compiling package specification SERIAL_ENTRY_CUSTOM. No compilation errors.Compiling package specifi

10、cation INTERORG_FH. No compilation errors.Compiling package specification RMA_RECEIPT_FH. No compilation errors.Compiling package specification RMA_LAYOUT. No compilation errors.Compiling package specification RMA_RETURN_FH. No compilation errors.Compiling package specification FORM_UPDATE. No compi

11、lation errors.Compiling package specification INTERORG_LAYOUT. No compilation errors.Compiling package specification INV_STORE_FIELDS. No compilation errors.Compiling package specification INV_STORE_FIELDS_EXT. No compilation errors.Compiling package specification TRX_CUSTOM. No compilation errors.C

12、ompiling package specification INTERORG_XFER. No compilation errors.Compiling package specification APP_CUSTOM. No compilation errors.Compiling package body APP_CUSTOM. No compilation errors.Compiling package specification FH_HEADER. No compilation errors.Compiling package body FH_HEADER.Compilation

13、 error on package body FH_HEADER:PL/SQL ERROR 49 at line 101, column 25bad bind variable 'PARAMETER.ORG_ID'PL/SQL ERROR 49 at line 101, column 25bad bind variable 'PARAMETER.ORG_ID'PL/SQL ERROR 49 at line 320, column 31bad bind variable '_id'PL/SQL ERROR 49 at li

14、ne 320, column 31bad bind variable '_id'Compiling package body TRX.Compilation error on package body TRX:PL/SQL ERROR 49 at line 114, column 30bad bind variable 'parameter.chart_of_accounts_id'PL/SQL ERROR 49 at line 114, column 30bad bind variable 'parameter.chart_o

15、f_accounts_id'PL/SQL ERROR 49 at line 147, column 30bad bind variable 'parameter.chart_of_accounts_id'PL/SQL ERROR 49 at line 166, column 30bad bind variable '_id'PL/SQL ERROR 49 at line 166, column 30bad bind variable '_id'PL/SQL ERROR 49 at lin

16、e 317, column 32bad bind variable 'PARAMETER.ORG_ID'PL/SQL ERROR 49 at line 317, column 32bad bind variable 'PARAMETER.ORG_ID'Compiling package specification TRX. No compilation errors.Compiling package specification HEADER. No compilation errors.Compiling package body HEADER.Compila

17、tion error on package body HEADER:PL/SQL ERROR 49 at line 118, column 45bad bind variable '_code'PL/SQL ERROR 49 at line 118, column 45bad bind variable '_code'Compiling package specification DETAIL_LAYOUT. No compilation errors.Compiling package body DETAIL

18、_LAYOUT.Compilation error on package body DETAIL_LAYOUT:PL/SQL ERROR 49 at line 188, column 26bad bind variable '_code'PL/SQL ERROR 49 at line 188, column 26bad bind variable '_code'PL/SQL ERROR 49 at line 282, column 26bad bind variable '_c

19、ode'PL/SQL ERROR 49 at line 382, column 26bad bind variable '_code'PL/SQL ERROR 49 at line 488, column 26bad bind variable '_code'Compiling package specification LOT_ENTRY_CUSTOM. No compilation errors.Compiling package body LOT_ENTRY_CUSTOM. No compilat

20、ion errors.Compiling package specification SERIAL_ENTRY_CUSTOM. No compilation errors.Compiling package body SERIAL_ENTRY_CUSTOM. No compilation errors.Compiling package specification INTERORG_FH. No compilation errors.Compiling package body INTERORG_FH.Compilation error on package body INTERORG_FH:

21、PL/SQL ERROR 49 at line 77, column 23bad bind variable 'PARAMETER.CHART_OF_ACCOUNTS_ID'PL/SQL ERROR 49 at line 77, column 23bad bind variable 'PARAMETER.CHART_OF_ACCOUNTS_ID'Compiling package specification RMA_RECEIPT_FH. No compilation errors.Compiling package body RMA_RECEIPT_FH.Co

22、mpilation error on package body RMA_RECEIPT_FH:PL/SQL ERROR 49 at line 54, column 31bad bind variable '_id'PL/SQL ERROR 49 at line 54, column 31bad bind variable '_id'Compiling package specification RMA_LAYOUT. No compilation errors.Compiling package body RM

23、A_LAYOUT.Compilation error on package body RMA_LAYOUT:PL/SQL ERROR 49 at line 91, column 26bad bind variable '_code'PL/SQL ERROR 49 at line 91, column 26bad bind variable '_code'PL/SQL ERROR 49 at line 180, column 26bad bind variable '_code&

24、#39;Compiling package specification RMA_RETURN_FH. No compilation errors.Compiling package body RMA_RETURN_FH. No compilation errors.Compiling package specification FORM_UPDATE. No compilation errors.Compiling package body FORM_UPDATE. No compilation errors.Compiling package specification INTERORG_LAYOUT. No compilation errors.Compiling package body INTERORG_LAYOUT.Compilation error on package bo