一.编译FORM

1.将脚本写成shell脚本

cd $AU_TOP/forms/ZHS

export FORMS_PATH=.:$FORMS_PATH:$AU_TOP/forms/ZHS

frmcmp_batch $CUX_TOP/forms/programs/$1.fmb apps/apps output_file=$CUX_TOP/forms/ZHS/$1.fmx

cp $CUX_TOP/forms/ZHS/$1.fmx $CUX_TOP/forms/US/$1.fmx

用时直接切换到目录调用

/u01/UAT/apps/apps_st/appl/cux/12.0.0/forms/programs

compile.sh form名

例如

[appluat@ebsapp ZHS]$ compile.sh CUXAPREBATE   

FORM后面不用加fmb；如果没有权限先赋权限

chmod 777 compile.sh

2.直接用命令编译

frmcmp_batch userid=apps/apps module=$HPOS_TOP/forms/ZHS/HPOSPOREQ.fmb output_file=$HPOS_TOP/forms/ZHS/HPOSPOREQ.fmx module_type=form

3.修改系统标准FORM后编译标准form

先切换到目录$AU_TOP

例如

/u01/UAT/apps/apps_st/appl/au/12.0.0/forms/ZHS

编译：注意用时修改模块路径

frmcmp_batch userid=apps/apps module=$AU_TOP/forms/ZHS/APXRMTCH.fmb output_file=/u01/UAT/apps/apps_st/appl/ap/12.0.0/forms/ZHS/APXRMTCH.fmx module_type=form

二.编译PLL

1.编译CUSTOM.PLL

切换到：$AU_TOP/resource

--R11i

f60gen module_type=LIBRARY module=CUSTOM userid=apps/apps

--R12

frmcmp_batch CUSTOM apps/apps module_type=LIBRARY compile_all=YES

2.编译其他PLL

切换到：$AU_TOP/resource

frmcmp_batch CUXAPXINWKB apps/apps module_type=LIBRARY compile_all=YES

--查看最近编译的命令

ls -lt|head

三.编译无效PACKAGE

1.查找无效包

SELECT 'ALTER PACKAGE '||do.owner||'.'||do.object_name|| ' COMPILE  BODY ;'

FROM dba_objects do WHERE do.object_name LIKE '%' AND do.status='INVALID' AND do.object_type='PACKAGE BODY';

2.编译PACKAGE

ALTER PACKAGE APPS.HSS_API COMPILE  PACKAGE ;

3.编译PACKAGE SPECIFICATION

ALTER PACKAGE APPS.HSS_API COMPILE  SPECIFICATION ;

4.编译PACKAGE BODY

ALTER PACKAGE APPS.HSS_API COMPILE  BODY ;

四.编译无效视图

1.查找无效视图

SELECT 'ALTER VIEW '||do.owner||'.'||do.object_name|| ' COMPILE;'

FROM dba_objects do WHERE do.object_name LIKE '%' AND do.status='INVALID' AND do.object_type='VIEW';

2。编译视图

ALTER VIEW APPS.FA_ASSET_HISTORY_V COMPILE;