Search 800 + Posts

Dec 14, 2012

Query to Check if a particular e E-Business Suite Module Installed in your Instance or Not



Query to Check if a particular e E-Business Suite Module Installed in your Instance or Not 

SELECT substr(a.application_name,1,30) MODULE,
a.application_id, substr(c.application_short_name,1,7) SN,
DECODE(b.status,'I','Installed','S','Shared','N','NOT Installed','UNKNOWN') STATUS
FROM fnd_application_tl a, fnd_product_installations b, fnd_application c
WHERE a.application_id = b.application_id
AND a.application_id = c.application_id
AND c.application_short_name like '%ONT%';

Query to Check  Ebusiness Suite version , latest patch Set , Boxname for a particulra_module
SELECT i.instance_name, i.host_name, f.release_name release,
fpi.patch_level, fpi.status, i.version db_version
FROM v$instance i, fnd_product_groups f,
applsys.fnd_product_installations fpi
WHERE UPPER(SUBSTR(i.instance_name,1,4)) =
UPPER(SUBSTR(f.applications_system_name,1,4))
AND fpi.patch_level LIKE '%ONT%';







No comments:

Post a Comment