Oracle EBS打Patch通用步骤

Oracle EBS打Patch通用步骤 

①查看已打的Patch信息
检查已安装模块版本： 
SELECT app.application_short_name, app.application_name, pi.patch_level 
FROM fnd_product_installations pi, fnd_application_vl app 
WHERE app.application_id = pi.application_id ;

检查已安装Patch： 
SELECT * FROM ad_applied_patches WHERE patch_name = ' 8819747 '; 

查看多语言补丁，Oracle Patch 版本的查询 PL/SQL: 
SELECT dd.patch_name, pp.creation_date, pp.driver_file_name, lang.language 
FROM ad_patch_drivers pp, ad_applied_patches dd, ad_patch_driver_langs lang 
WHERE pp.applied_patch_id = dd.applied_patch_id AND lang.patch_driver_id = pp.patch_driver_id 
ORDER BY pp.creation_date ;

要查看中英文补丁是否都打上了，可以利用以下查询： 
select a.patch_driver_id,a.applied_patch_id,b.language 
from applsys.ad_patch_drivers a, applsys.ad_patch_driver_langs b 
where a.driver_file_name like '%