Oracle EBS DBA常用SQL - 安裝/補丁

Oracle EBS DBA常用SQL - 安裝/補丁

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%';