Oracle E-Business Suite: Oracle Application Kurulumu ile ilgili Bilgiler SQL - Application Info SQL

Oracle E-Business Suite Kurulumu ile ilgili bilgileri gösteren script:

 prompt --> Determining information about this Product Group  
   
 select product_group_id, product_group_name, release_name,   
   product_group_type, argument1  
  from fnd_product_groups;  
   
 prompt --> Multi-Org installed?  
 select multi_org_flag from fnd_product_groups;  
   
 prompt --> Uygulamada birden çok dil yüklü mü?  
 select multi_lingual_flag from fnd_product_groups;  
   
 prompt --> Lisanslanmış Ürünler  
   
 select decode(a.APPLICATION_short_name,  
   'SQLAP','AP','SQLGL','GL','OFA','FA',  
   a.APPLICATION_short_name) apps,  
   o.ORACLE_username, fpi.status, fpi.install_group_num,  
   fpi.product_version, fpi.sizing_factor,   
   fpi.tablespace, fpi.index_tablespace, fpi.temporary_tablespace  
 from fnd_oracle_userid o, fnd_application a, fnd_product_installations fpi  
 where fpi.application_id = a.application_id(+)  
  and fpi.oracle_id = o.oracle_id(+)  
 order by 1,2  
 /  
   
 prompt --> Kayıtlı Uygulamalar
   
 select application_id, application_short_name,  
    basepath  
 from fnd_application  
 order by application_id  
 /  
   
 prompt --> Kayıtlı Oracle Schema'larını Bulmak için  
   
 select oracle_id, oracle_username, install_group_num, read_only_flag  
 from fnd_oracle_userid  
 order by 1  
 /  
   
 prompt --> Kurulu olan dilleri bulmak için  
   
 select decode(installed_flag,'I','Installed','B','Base','Unknown')   
   installed_flag,  
   language_code, nls_language from fnd_languages  
 where installed_flag in ('I','B')  
 order by installed_flag  
 /  

Aşağıdaki raporda kurulu uygulamaların düzenli bir şekilde gösterilmesi amacıyla yaratılmıştır.

SELECT report_headings.report_date,  
     report_headings.sid_name,  
     fa.application_id appn_id,  
     decode(fa.application_short_name,  
        'SQLAP', 'AP', 'SQLGL', 'GL', fa.application_short_name ) appn_short_name,  
     substr(fat.application_name,1,50)||  
        decode(sign(length(fat.application_name) - 50), 1, '...') Application,  
     fa.basepath Base_path,  
     fl.meaning install_status,  
     nvl(fpi.product_version, 'Not Available') product_version,  
     nvl(fpi.patch_level, 'Not Available') patch_level,  
     to_char(fa.last_update_date, 'DD-Mon-YY (Dy) HH24:MI') last_update_date,  
     nvl(fu.user_name, '* Install *') Updated_by  
  FROM applsys.fnd_application fa,  
     applsys.fnd_application_tl fat,  
     applsys.fnd_user fu,  
     applsys.fnd_product_installations fpi,  
     apps.fnd_lookups fl,  
     ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date,  
         vd.name sid_name  
       FROM v$database vd ) report_headings   
  WHERE fa.application_id = fat.application_id  
   and fat.language(+) = userenv('LANG')  
   and fa.application_id = fpi.application_id  
   and fpi.last_updated_by = fu.user_id(+)  
   and fpi.status = fl.lookup_code  
   and fl.lookup_type = 'FND_PRODUCT_STATUS'  
 UNION ALL  
 SELECT report_headings.report_date,  
     report_headings.sid_name,  
     fa.application_id,  
     fa.application_short_name,  
     substr(fat.application_name,1,50)||  
        decode(sign(length(fat.application_name) - 50), 1, '...'),  
     fa.basepath,  
    'Not Available',  
    'Not Available',   
    'Not Available',  
     to_char(fa.last_update_date, 'DD-Mon-YY (Dy) HH24:MI'),  
     nvl(fu.user_name, '* Install *')   
  FROM applsys.fnd_application fa,  
     applsys.fnd_application_tl fat,  
     applsys.fnd_user fu,  
        ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date,  
          vd.name sid_name  
       FROM v$database vd ) report_headings   
  WHERE fa.application_id = fat.application_id  
   and fat.language(+) = userenv('LANG')  
   and fa.last_updated_by = fu.user_id(+)  
   and fa.application_id not in   
     ( SELECT fpi.application_id  
       FROM applsys.fnd_product_installations fpi )  
  ORDER by 5 

Referanslar:

1-http://www.piper-rx.com/pages/reports_free/fadm001_10.trd