Is patch applied

[big]

Hi,
On R12.2.9 DB 18C on AIX
I ran:
time adop phase=apply patches=30628681 hotpatch=yes abandon=yes
In log I have:
view adop_20221108_155909.log
[STATEMENT] [END   2022/11/08 17:23:17] adzdoptl.pl run
[STATEMENT] adop phase=apply - Completed Successfully
But when query database:

SQL> select APPLIED_PATCH_ID ,PATCH_NAME ,CREATION_DATE from ad_applied_patches where PATCH_NAME in ('330628681')order by CREATION_DATE desc;

no rows selected

SQL> select ad_patch.is_patch_applied('R12',-1, 330628681 ) from dual;

AD_PATCH.IS_PATCH_APPLIED('R12',-1,330628681)
--------------------------------------------------------------------------------
NOT_APPLIED

Is patche 30628681 really applied or not?

When I run adop -status, I see apply phase is acative.

Thanks and regards.

[ErmanArslansOracleBlog]

What about AD_BUGS? Do you see that patch there?

[big]

H Erman,
Yes it is ther:
SQL> select bug_number,bug_id,CREATION_DATE, LAST_UPDATE_DATE from ad_bugs where bug_number='30628681';

BUG_NUMBER                         BUG_ID CREATION_DATE      LAST_UPDATE_DATE
------------------------------ ---------- ------------------ ------------------
30628681                           915935 08-NOV-22          08-NOV-22

Thanks and regards.

[ErmanArslansOracleBlog]

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;

[ErmanArslansOracleBlog]

Also check it with;

SELECT DISTINCT
  e.patch_name Patch_NO,
  d.patch_abstract Patch,
  e.CREATION_DATE Applied_Date
FROM
  ad_patch_drivers d ,
  ad_applied_patches e
WHERE
  d.applied_patch_id = e.applied_patch_id and d.patch_abstract like '%AD%'
ORDER BY e.CREATION_DATE desc;

[big]

Hi,
Thank you.
Sorry for dely.

I will come to you soon.
Regards.

[big]

Hi,
Here they are:
select ad_patch.is_patch_applied('R12',-1,30628681) from dual;
--------------------
EXPLICIT

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  ('30628681')
ORDER BY 1 DESC;
BUG_APPLIED                          
--------------------------------------
30628681   30628681   08-NOV-22   Y
SELECT DISTINCT
  e.patch_name Patch_NO,
  d.patch_abstract Patch
 -- e.CREATION_DATE Applied_Date
FROM
  ad_patch_drivers d ,
  ad_applied_patches e
WHERE
  d.applied_patch_id = e.applied_patch_id and d.patch_abstract like '%AD%'
  and e.patch_name='30628681';
Patch_NO       Patch
---------------------------------------
30628681        R12.AD.C.DELTA.12

It is actually applied.
Thanks and regards.