《重新编译单个form》由会员分享,可在线阅读,更多相关《重新编译单个form(12页珍藏版)》请在金锄头文库上搜索。
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) 使用帮助-诊断查询帮助-诊
2、断-属性-项目输入安装时的 apps 口令,显示 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.
3、0.0/forms/US/INVTTMTX.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
4、=/d01/oracle/PROD/apps/apps_st/appl/inv/12.0.0/forms/US/INVTTMTX.fmx module_type=form compile_all=specialForms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)Forms 10.1 (Form Compiler): Release - ProductionCopyright (c) 1982, 2005, Oracle. All rights reserved.Oracle Database 11g Enterprise Edit
5、ion Release 11.1.0.7.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsPL/SQL Version 10.1.0.5.0 (Production)Oracle Procedure Builder V10.1.2.3.0 - ProductionOracle Virtual Graphics System Version 10.1.2.0.0 (Production)Oracle Multimedia Version 10.1.2.
6、0.2 (Production)Oracle Tools Integration Version 10.1.2.0.2 (Production)Oracle Tools Common Area Version 10.1.2.0.2Oracle CORE 10.1.0.5.0 ProductionFRM-18108: Failed to load the following objects.Source Module:INVSTANDSource Object: INV_MVT_RECORD_GROUPSSource Module:INVSTANDSource Object: INV_ALERT
7、SSource Module:INVSTANDSource Object: INV_PARAMSSource Module:INVTTESRSource Object: SERIAL_ENTRYSource Module:APPSTANDSource Object: STANDARD_FOLDERSource Module:INVSTANDSource Object: INV_STANDARD_PCSource Module:APPSTANDSource Object: STANDARD_PC_AND_VASource Module:APPSTANDSource Object: STANDAR
8、D_TOOLBARSource Module:INVTTELT.fmbSource Object: INV_LOT_ENTRYSource Module:APPSTANDSource Object: STANDARD_CALENDARCompiling package specification APP_CUSTOM. No compilation errors.Compiling package specification FH_HEADER. No compilation errors.Compiling package specification TRX. No compilation
9、errors.Compiling 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 packa
10、ge specification 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
11、. No compilation 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 compilatio
12、n errors.Compiling 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.Co
13、mpilation error on package body FH_HEADER:PL/SQL ERROR 49 at line 101, column 25bad bind variable PARAMETER.ORG_IDPL/SQL ERROR 49 at line 101, column 25bad bind variable PARAMETER.ORG_IDPL/SQL ERROR 49 at line 320, column 31bad bind variable parameter.org_idPL/SQL ERROR 49 at line 320, column 31bad
14、bind variable parameter.org_idCompiling package body TRX.Compilation error on package body TRX:PL/SQL ERROR 49 at line 114, column 30bad bind variable parameter.chart_of_accounts_idPL/SQL ERROR 49 at line 114, column 30bad bind variable parameter.chart_of_accounts_idPL/SQL ERROR 49 at line 147, colu
15、mn 30bad bind variable parameter.chart_of_accounts_idPL/SQL ERROR 49 at line 166, column 30bad bind variable parameter.org_idPL/SQL ERROR 49 at line 166, column 30bad bind variable parameter.org_idPL/SQL ERROR 49 at line 317, column 32bad bind variable PARAMETER.ORG_IDPL/SQL ERROR 49 at line 317, co
16、lumn 32bad bind variable PARAMETER.ORG_IDCompiling package specification TRX. No compilation errors.Compiling package specification HEADER. No compilation errors.Compiling package body HEADER.Compilation error on package body HEADER:PL/SQL ERROR 49 at line 118, column 45bad bind variable parameter.org_codePL/SQL ERROR 49 at line 118, column 45bad bind variable param