We can find the various patch levels using the table ad_trackable_entities in Oracle Apps R12.2. In this post, we will see How to find ad and txk patch levels, how to check the delta level in r12, how to check fwk in r12.2
Here is the definition of the Table ad_trackable_entities
How to find ad and txk patch level/how to check delta level in r12
This can be found by connecting the Oracle database using the “apps” user and then running the below query
set lines 1000 col NAME for a40 col CODELEVEL for a20 col ABBREVIATION for a10 select name, abbreviation ,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk') order by abbreviation;
If it is C.10 then it is Delta Level 10, if it is C.11, then it is Delta Level 11, and so on
How to check fwk in r12.2
The query would be
select abbreviation ,codelevel from ad_trackable_entities where abbreviation in( 'fwk') order by abbreviation;
or, you can use the below query also
SELECT codelevel, decode((codelevel), 'C.10', '12.2.11 Framework Code Stack', 'C.9', '12.2.10 Framework Code Stack', 'C.8', '12.2.9 Framework Code Stack', 'C.7', '12.2.7/12.2.8 Framework Code Stack', 'C.6', '12.2.6 Framework Code Stack', 'C.5', '12.2.5 Framework Code Stack', 'C.4', '12.2.4 Framework Code Stack', 'B.5', '12.1.3 Framework Code Stack', 'B.4', '11.5.10 Framework Code Stack') stack FROM AD_TRACKABLE_ENTITIES WHERE abbreviation='fwk';
We can use the below query to determine the bundle patch that applies to the Framework Code Level Stack
set pagesize 50
set linesize 88
col INSTANCE for a16
col RELEASE for a10
col PATCH for a10
col BUG_NUMBER for a8 head "Framework Patches"
col APPLIED for a12
SELECT
(SELECT instance_name FROM v$instance) INSTANCE,
(SELECT release_name from fnd_product_groups) RELEASE,
Bugs.Bug_Number as PATCH,
Decode(Bugs.Bug_Number,
'33203715', 'FWK RELEASE 12.2.11 (C.10) Consolidated Patch',
'31947046', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 1',
'32130969', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 2',
'32642176', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 3',
'32996407', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 4',
'33193360', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 5',
'33502107', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 6',
'33584098', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 7',
'33803987', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 8',
'30098489', 'FWK RELEASE 12.2.9 (C.8) Consolidated Patch',
'30908501', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 1',
'30980514', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 2',
'31189388', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 3',
'31466879', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 4',
'31829822', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 5',
'31943873', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 6',
'32130874', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 7',
'32308701', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 8',
'32642088', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 9',
'32856251', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 10',
'33144986', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 11',
'28830603', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 1',
'28963259', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 2',
'29232729', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 3',
'29679229', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 4',
'29880879', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 5',
'30139276', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 6',
'30369165', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 7',
'30720143', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 8',
'31154508', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 9',
'31445005', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 10',
'31667105', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 11',
'31883479', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 12',
'32418566', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 13',
'32842344', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 14',
'33137827', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 15',
'24301236', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 1',
'25805360', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 2',
'25958203', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 3',
'26127158', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 4',
'26382210', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 5',
'26543378', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 6',
'26792877', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 7',
'26953578', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 8',
'27113797', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 9',
'27308923', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 10',
'27529582', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 11',
'27675364', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 12',
'27948803', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 13',
'28183913', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 14',
'28442391', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 15',
'28649181', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 16',
'28805689', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 17',
'28970079', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 18',
'29438310', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 19',
'29679234', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 20',
'30095623', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 21',
'30339377', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 22',
'30543303', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 23',
'30901459', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 24',
'31625670', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 25',
'31831920', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 26',
'32241515', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 27',
'33194232', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 28',
'33650713', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 29',
'22745072', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 2',
'22892644', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 3',
'23179558', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 4',
'23597151', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 5',
'24329530', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 6',
'24561446', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 7',
'24813943', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 8',
'25124879', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 9',
'25264693', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 10',
'25633876', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 11',
'25805309', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 12',
'25964634', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 13',
'26244104', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 14',
'26440798', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 15',
'26648248', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 16',
'26823961', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 17',
'27014320', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 18',
'27256875', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 19',
'27476539', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 20',
'28183924', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 21',
'29582468', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 22',
'30552929', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 23',
'31571414', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 24',
'32451763', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 25',
'21420257', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 1 --(Obsoleted)',
'21420272', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 2 --(Obsoleted)',
'21564727', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 3 --(Obsoleted)',
'21760224', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 4',
'21981732', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 5 --(Obsoleted)',
'22263785', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 6 --(Obsoleted)',
'22544086', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 7',
'22730127', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 8',
'22892369', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 9',
'23119976', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 10',
'23329010', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 11',
'24007747', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 12',
'24618945', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 13',
'24911652', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 14',
'25145239', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 15',
'25582065', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 16',
'26026963', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 17',
'26924548', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 18',
'27252629', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 19',
'28034418', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 20',
'28948407', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 21',
'30309169', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 22',
'31874491', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 23',
'11894708', 'OA FRAMEWORK 12.1.3.1',
'15880118', 'OA FRAMEWORK 12.1.3.2',
'18936791', 'FWK RELEASE B.DELTA.4',
'22284589', 'FWK RELEASE B.DELTA.5',
'23200210', 'R12.FWK.B 121RUP5+ ONE-OFF',
'26731171', 'R12.FWK.B 121RUP5+ ONE-OFF') as "Framework Patches",
decode(Ad_Patch.Is_Patch_Applied('R12',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From (select '33203715' as bug_number, 'C.10' as fwk_version from Dual
UNION ALL
select '31947046' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '32130969' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '32642176' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '32996407' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '33193360' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '33502107' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '33584098' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '33803987' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '30098489' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '30908501' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '30980514' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31189388' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31466879' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31829822' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31943873' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32130874' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32308701' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32642088' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32856251' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '33144986' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '28830603' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '28963259' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '29232729' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '29679229' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '29880879' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '30139276' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '30369165' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '30720143' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31154508' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31445005' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31667105' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31883479' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '32418566' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '32842344' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '33137827' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
--C6
select '24301236' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '25805360' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '25958203' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26127158' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26382210' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26543378' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26792877' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26953578' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27113797' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27308923' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27529582' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27675364' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27948803' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28183913' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28442391' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28805689' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28649181' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28805689' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28970079' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '29438310' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '29679234' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30095623' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30339377' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30543303' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30901459' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '31625670' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '31831920' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '32241515' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '33194232' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '33650713' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
--C5
select '22745072' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '22892644' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '23179558' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '23597151' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '24329530' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '24561446' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '27256875' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '24813943' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25124879' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25264693' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25633876' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25805309' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25964634' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26244104' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26440798' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26648248' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26823961' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '27014320' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '27476539' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '28183924' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '29582468' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '30552929' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '31571414' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '32451763' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
--C4
select '21420257' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21420272' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21564727' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21760224' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21981732' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22263785' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22544086' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22730127' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22892369' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '23119976' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '23329010' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '24007747' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '24618945' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '24911652' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '25145239' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '25582065' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '26026963' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '26924548' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '27252629' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '28034418' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '28948407' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '30309169' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '31874491' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
--B5
select '22284589' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '18936791' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '15880118' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '11894708' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '23200210' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '26731171' as bug_number, 'B.5' as fwk_version from Dual) Bugs
where fwk_version= ( SELECT codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation='fwk')
order by 3;
How to check the ATG patch level in r12.2
We can use the below query
set lines 1000 col NAME for a40 col CODELEVEL for a20 col ABBREVIATION for a10 select abbreviation ,codelevel from ad_trackable_entities where abbreviation in( 'atg_pf') order by abbreviation;
We together find all the patch levels with the single query also as
set lines 1000 col NAME for a40 col CODELEVEL for a20 col ABBREVIATION for a10 select abbreviation ,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk','fnd','fwk','atg_pf') order by abbreviation;
How to find Product Family Patches/Patchsets Installed in R12.2
Suppose we want to find for HR, then the query would be
set lines 1000 col NAME for a40 col CODELEVEL for a20 col ABBREVIATION for a10 select abbreviation ,codelevel from ad_trackable_entities where abbreviation in( 'hr_pf') order by abbreviation;
Similarly, we can find out for others as required
I hope this will solve a lot of the queries and will help in day-to-day administration.
Please do provide feedback
Related Articles
check Patch application in R12.1 /R12.2 : How to check Patch application in Oracle E-Business Suite instance R12/R12.2
ADOP failures in R12.2: Troubleshooting ADOP failures in R12.2. Useful tips and resolutions
Admin scripts in R12.2: Admin scripts in R12.2 E-business Suite, weblogic,10.1.2 forms
Workflow Background Process: Check out how to submit workflow background process from the backend, How to run Workflow Background Process using SQLPLUS and Unix