How to check if a patch is applied in Oracle E Business Suite.

How to check if a patch is applied in Oracle E Business Suite.

For R12.2.X eBS version use the below query/script to get the patch information:

SELECT AD_PATCH.IS_PATCH_APPLIED('$release’,'$appltop_id','$patch_no','$language') patch_info
FROM dual;

Below example for single app tier installations:-

SELECT ad_patch.is_patch_applied ('R12', -1,8246403) patch_info
FROM dual;

Expected results as follows:
EXPLICIT = Applied
NOT APPLIED = Not applied Or Aborted.

For 11i or R12.1.X eBS version use the below query/script to get the patch information:-

SELECT *
  FROM ad_bugs
 WHERE bug_number = '<patch_number>'; --8246403

SELECT *
  FROM ad_applied_patches
 WHERE patch_name= '<patch_number>'; --8246403

SELECT aap.applied_patch_id,
       aap.patch_name,
       aap.patch_type,
       apd.driver_file_name,
       apd.orig_patch_name,
       apd.creation_date,
       apd.platform,
       apd.source_code,
       apd.creation_date,
       apd.file_size,
       apd.merged_driver_flag,
       apd.merge_date
  FROM AD_APPLIED_PATCHES aap
      ,AD_PATCH_DRIVERS apd
 WHERE aap.APPLIED_PATCH_ID = apd.APPLIED_PATCH_ID
   AND aap.PATCH_NAME = '<patch_number>'; --8246403