oracle ebs dba常用sql - 安装/补丁
检查应用补丁有没有安装:
select bug_number,last_update_date from ad_bugs where bug_number='&bug_num';
检查安装了哪些语言:
select nls_language,language_code,installed_flag from fnd_languages where installed_flag in ('i','b');
检查应用有没有安装:
select substr (fat.application_name
,1
,30)
module
,fat.application_id
,substr (fa.application_short_name
,1
,7)
sn
,decode (fpi.status
,'i', 'installed'
,'s', 'shared'
,'n', 'not installed'
,'unknown')
status
from fnd_application_tl fat
,fnd_product_installations fpi
,fnd_application fa
where fat.application_id = fpi.application_id
and fat.application_id = fa.application_id
and fa.application_short_name like '%&short_name%';
，