12.2 E-Business Suite Applications DBA Patch Application SQL to Check Current Levels Related To The Technology Stack (AD / TXK / ATG_PF) Products (Doc ID 2414925.1)

GOAL

E-Business Suite 12.2 Applications DBA, Patch Application related issues

There are many situation in which we need to confirm the patch level for AD/TXK/ATG_PF before applying other patches.

This note provides a SQL script to find out which patch level for each of these AD/TXK/ATG_PF that have applied in an E-Business Suite environment.
 

SOLUTION

Use below SQL script to check the current patch level related to the ATG (AD/TXK/ATG_PF) Product area of E-Business Suite 12.2.4 and later:

sqlplus <apps_user>/<apps password>
select bug_number, decode(bug_number,17919161, 'R12.2.4',
19676458, 'R12.2.5',
21900901, 'R12.2.6',
24690690, 'R12.2.7',
17909318, 'R12.ATG_PF.C.Delta.4',
19245366, 'R12.ATG_PF.C.Delta.5',
21900895, 'R12.ATG_PF.C.Delta.6',
24690680, 'R12.ATG_PF.C.Delta.7',
17766337, 'R12.AD.C.DELTA.4',
18283295, 'R12.AD.C.DELTA.5',
19197270, 'R12.AD.C.DELTA.6',
20745242, 'R12.AD.C.DELTA.7',
21841299, 'R12.AD.C.DELTA.8',
25178222, 'R12.AD.C.DELTA.9',
25820806, 'R12.AD.C.DELTA.10',
17893964, 'R12.TXK.C.DELTA.4',
18288881, 'R12.TXK.C.DELTA.5',
19330775, 'R12.TXK.C.DELTA.6',
20784380, 'R12.TXK.C.DELTA.7',
21830810, 'R12.TXK.C.DELTA.8',
25180736, 'R12.TXK.C.DELTA.9',
25828573, 'R12.TXK.C.DELTA.10',
bug_number) ARU_RELEASE_NAME
from AD_BUGS b
where b.BUG_NUMBER in ('17919161','19676458','21900901','24690690','17909318','19245366','21900895','24690680',
'17766337','18283295','19197270','20745242','21841299','25178222','25820806','17893964','18288881','19330775',
'20784380','21830810','25180736','25828573')
order by ARU_RELEASE_NAME, BUG_NUMBER;