Posted by
ErmanArslansOracleBlog on
Nov 11, 2022; 8:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Is-patch-applied-tp11216p11223.html
AD_BUGS -> all bug numbers fixed on the system
AD_APPLIED_PATCHES -> all patches (including the patch numbers)which were applied to the system.
1)What is the output of the following;
select ad_patch.is_patch_applied('R12',-1,30628681) from dual;
expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted)
2)Check it with the methods given in the following document and send me your findings;
How To Check If a Certain Patch Was Applied to Oracle E-Business Suite Instance (11i or R12) ? (Doc ID 443761.1)
For instance the following one ->
sqlplus apps/<APPS PASSWORD>
SQL> SELECT DISTINCT RPAD(a.bug_number,
11)|| RPAD(e.patch_name,
11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4) BUG_APPLIED
FROM
ad_bugs a,
ad_patch_run_bugs b,
ad_patch_runs c,
ad_patch_drivers d ,
ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND
b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND
d.applied_patch_id = e.applied_patch_id AND
a.bug_number in ('<XXXXXX>','<YYYYYY>')
ORDER BY 1 DESC;