Use the below query to identify which patches you
already applied to keep your patch wizard updated. Based on your Oracle EBS Version use the
respective query to identify your patch wizard status.
--Check for the Latest 11i Patch Wizard Patches Applied
Select Bugs.Bug_Number as PATCH,
Decode(Bugs.Bug_Number,
10405353, '10405353 for Release 11i (included in RECOMMENDED patch 14350791)',
15998913, '15998913 for Release 11i (included in RECOMMENDED patch 14350791)',
10123716, '10123716 for Release 11i (included in RECOMMENDED patch 14350791)',
14350791, '14350791 for the latest RECOMMENDED version of Patch Wizard in Oracle E-Business Suite (Release 11i)') as "11i Patch Wizard Patches",
decode(Ad_Patch.Is_Patch_Applied('11i',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From
(select '10405353' as bug_number From Dual
UNION ALL
select '15998913' as bug_number from Dual
UNION ALL
select '10123716' as bug_number From Dual
UNION ALL
select '14350791' as bug_number From Dual) Bugs;
--Check for the Latest R12.0 Patch Wizard Patches Applied
Select Bugs.Bug_Number as PATCH,
Decode(Bugs.Bug_Number,
10629916, '10629916 for Release 12.0.x is superseded in 15998913',
15998913, '15998913 for Release 12.0.x is superseded by 16541210',
16541210, '16541210:R12.AD.A for the latest RECOMMENDED version of Patch Wizard in Oracle E-Business Suite (Release 12.0)') as "R12.0 Patch Wizard Patches",
decode(Ad_Patch.Is_Patch_Applied('11i',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From
(select '10629916' as bug_number From Dual
UNION ALL
select '15998913' as bug_number from Dual
UNION ALL
select '16541210' as bug_number From Dual) Bugs;
--Check for the Latest R12.1 Patch Wizard Patches Applied
Select Bugs.Bug_Number as PATCH,
Decode(Bugs.Bug_Number,
12729041, '12729041 for Release 12.1.x is recommended by Development.',
11710489, '11710489 for Release 12.1.x is superseded by 14061105',
14061105, '14061105 for Release 12.1.x is superseded by 16248018',
16248018, '16248018 for Release 12.1.x is superseded by 16357991',
16357991, '16357991 for Release 12.1.x is superseded by 11071638',
11071638, '11071638 for Release 12.1.x is superseded by 16992893',
16992893, '16992893 for Release 12.1.x is superseded by 17244500',
17244500, '17244500 for Release 12.1.x is superseded by 14504286',
14504286, '14504286 for Release 12.1.x is superseded by 17270136',
17270136, '17270136 for Release 12.1.x is replaced by 18598941',
18598941, '18598941-R12.ADO.B.delta.5 is superseded by R12.ADO.B.delta.6 (19277598)',
17842189, '17842189:R12.ADO.B 1OFF:12.1.3 - Recommended to apply on top of 18598941 (Release 12.1)',
19278051, '19278051:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B.delta.6 (19277598)',
19277598, '19277598:R12.ADO.B.delta.6 for Release 12.1.x is replaced by R12.ADO.B (19491900)',
19491900, '19491900:R12.ADO.B for Release 12.1.x is replaced by R12.ADO.B (19663882)',
19663882, '19663882:R12.ADO.B for Release 12.1.x is replaced by R12.ADO.B (17701355)',
17701355, '17701355:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B (20448886)',
20448886, '20448886:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B.Delta.7 (20390398)',
20390398, '20390398:R12.ADO.B.Delta.7 is superseded by R12.ADO.B.Delta.8 (21285343)',
20121898, 'Patch:20121898:R12.ADO.B 1OFF:20390398:R12.ADO.B.Delta.7, Adds VIEW ALL option for Files and Menus',
21285343, 'Patch:21285343:R12.ADO.B.delta.8 (Patch 9703082 prereqs ADO delta 7 which is superceded by 21285343:R12.ADO.B.delta.8',
9703082, 'Patch:9703082:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B (22490144)',
22490144, 'Patch:22490144:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B (23618634)',
23618634, 'Patch 23618634:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B (22902616)',
22902616, 'Patch 22902616:R12:ADO.B for Release 12.1.x is superseded by R12.ADO.B (23150570)',
23150570, 'Patch 23150570:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B (24505803)',
24505803, 'Patch 24505803:R12.ADO.B PATCH WIZARD RECOMMENDS AD/TXK DELTA BUNDLE PATCHES AFTER APPLYING AD/TXK DELTA8',
20689262, 'Patch 20689262:R12.ADO.B for Release 12.1.x is superseded by R12.ADO.B (28064828)',
28064828, 'Patch 28064828:R12.ADO.B for Release 12.2.x is superseded by R12.ADO.B (28389569)',
28389569, '28389569:R12.ADO.B Patch Wizard latest recommended Patch for 12.1') as "R12.1 Patch Wizard Patches",
decode(Ad_Patch.Is_Patch_Applied('R12',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From
(select '12729041' as bug_number From Dual
UNION ALL
select '11710489' as bug_number From Dual
UNION ALL
select '14061105' as bug_number From Dual
UNION ALL
select '16248018' as bug_number From Dual
UNION ALL
select '16357991' as bug_number From Dual
UNION ALL
select '11071638' as bug_number From Dual
UNION ALL
select '16992893' as bug_number From Dual
UNION ALL
select '17244500' as bug_number From Dual
UNION ALL
select '14504286' as bug_number From Dual
UNION ALL
select '17270136' as bug_number From Dual
UNION ALL
select '18598941' as bug_number From Dual
UNION ALL
select '17842189' as bug_number From Dual
UNION ALL
select '19278051' as bug_number From Dual
UNION ALL
select '19277598' as bug_number From Dual
UNION ALL
select '19491900' as bug_number From Dual
UNION ALL
select '19663882' as bug_number From Dual
UNION ALL
select '17701355' as bug_number From Dual
UNION ALL
select '20448886' as bug_number From Dual
UNION ALL
select '20390398' as bug_number From Dual
UNION ALL
select '20121898' as bug_number From Dual
UNION ALL
select '21285343' as bug_number From Dual
UNION ALL
select '9703082' as bug_number From Dual
UNION ALL
select '22490144' as bug_number From Dual
UNION ALL
select '23618634' as bug_number From Dual
UNION ALL
select '22902616' as bug_number From Dual
UNION ALL
select '23150570' as bug_number From Dual
UNION ALL
select '24505803' as bug_number From Dual
UNION ALL
select '20689262' as bug_number From Dual
UNION ALL
select '28064828' as bug_number From Dual
UNION ALL
select '28389569' as bug_number From Dual) Bugs;
--Check for the Latest R12.2 Patch Wizard Patches Applied
Select Bugs.Bug_Number as PATCH,
Decode(Bugs.Bug_Number,
18184883, '18184883:R12.ADO.C for Release 12.2.x is replaced by 18427809',
18427809, '18427809:R12.ADO.C for Release 12.2.x is superseded by 18978837',
18978837, '18978837:R12.ADO.C for Release 12.2.x is superseded by 19412224',
19412224, '19412224:R12.ADO.C for Release 12.2.x is superseded by 19871279',
19871279, '19871279:R12.ADO.C for Release 12.2.x is superseded by 20231593',
20231593, '20231593:R12.ADO.C for Release 12.2.x is superseded by 20448886',
20448886, '20448886:R12.ADO.C for Release 12.2.x is superseded by 19663882',
19663882, '19663882:R12.ADO.C for Release 12.2.x is superseded by 21184697',
21184697, '21184697:R12.ADO.C for Release 12.2.x is superseded by 21806033',
21806033, '21806033:R12.ADO.C for Release 12.2.x is superseded by 22490144',
9703082, '9703082:R12.ADO.C for Release 12.2.x is superseded by 22490144',
22490144, '22490144:R12.ADO.C for Release 12.2.x is superseded by 23150570',
23150570, '23150570:R12.ADO.C for Release 12.2.x is superseded by 24505803',
24505803, '24505803:R12.ADO.C for Release 12.2.x is superseded by 25470620',
20689262, '20689262:R12.ADO.C for Release 12.2.x is superseded by 26359440',
26359440, '26359440:R12.ADO.C for Release 12.2.x is superseded by 28064828',
28064828, '28064828:R12.ADO.C for Release 12.2.x is superseded by 28389569',
28389569, '28389569:R12.ADO.C for the latest version of Patch Wizard in Oracle E-Business Suite (Release 12.2)') as "R12.2 Patch Wizard Patches",
decode(Ad_Patch.Is_Patch_Applied('R12',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From
(select '18184883' as bug_number From Dual
UNION ALL
select '18427809' as bug_number from Dual
UNION ALL
select '18978837' as bug_number From Dual
UNION ALL
select '19412224' as bug_number From Dual
UNION ALL
select '19871279' as bug_number From Dual
Union All
select '20231593' as bug_number From Dual
UNION ALL
select '20448886' as bug_number From Dual
Union All
select '19663882' as bug_number From Dual
Union All
select '21184697' as bug_number From Dual
Union All
select '21806033' As Bug_Number From Dual
Union All
select '9703082' As Bug_Number From Dual
Union All
select '22490144' As Bug_Number From Dual
Union All
select '23150570' As Bug_Number From Dual
UNION ALL
select '24505803' as bug_number From Dual
Union All
select '20689262' As Bug_Number From Dual
Union All
select '26359440' As Bug_Number From Dual
Union All
select '28064828' As Bug_Number From Dual
Union All
select '28389569' As Bug_Number From Dual) Bugs;
Ref : Patch Wizard FAQ (Doc ID 976688.2)
****************************நன்றி****************************
No comments:
Post a Comment