Common SQL statements of OracleEBSDBA

Common SQL statements of OracleEBSDBA

Oracle EBS DBAs commonly used SQL-install/patch check whether the application patch is installed: select bug_number, last_update_date from ad_bugs where bug_numbe

Common Oracle ebs dba SQL-installation/patch

Check whether the application patch is installed:
Select bug_number, last_update_date from ad_bugs where bug_number = '& bug_num ';

Check which languages are installed:
Select nls_language, language_code, installed_flag from fnd_ages where installed_flag in ('I', 'B ');

Check whether the application is installed:
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 % ';

,