EBS开发常用编译命令

时间：2021-08-27 13:42:56

一.编译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;

















































相关文章