Saturday, August 16, 2008

Check if a patch has been applied to Oracle Apps

select patch_level from fnd_product_installations where patch_level like '%FND%';
select patch_name from ad_applied_patches where patch_name in('5137963','4968815','4898130');
select bug_number from ad_bugs where bug_number in('5137963','4968815','4898130');