ORACLE APP的Patch Level 及 Package的版本檢查

除了查file的版本外,上PATCH前還常要確認Patch level,還有Package的版本
用APPS進DB去檢查下列的資料,來幫助你update SR
查目前AP的Patch level

select * from FND_PRODUCT_INSTALLATIONS
where patch_level like '%AP%' --跟SR叫你指定的Patch Level 比較


開SR請ORACLE Support幫忙查問題時,常常會遇到要檢查Package 版本的問題

SELECT name ||' '|| text
FROM dba_source
WHERE line = 2
AND type LIKE 'PACKAGE%'
AND owner = 'APPS'
AND NAME LIKE 'FND%'
ORDER BY name, type;