How to determine which patches have been applied

原文:http://oraqa.com/2006/12/27/how-to-determine-which-patches-have-been-applied/

There are two tables that contain information about patches applied to your Oracle E-Business Suite applications:

• AD_APPLIED_PATCHEScontains the list of patches that weredirectly applied.
• AD_BUGScontains the list of all the patches that were directly applied or were contained in the patches that were directly applied.

For example, if you are trying to find out if a certain pre-requisite patch has been applied, query AD_BUGS. If you are trying to find out patches applied in a date range, query AD_APPLIED_PATCHES.

SELECT *
  FROM ad_bugs
 WHERE bug_number = 'patch_number';

SELECT *
  FROM ad_applied_patches
 WHERE patch_name = 'patch_number';

Replacepatch_numberwith the number of the patch you want to check.