Script to check what ATG/Workflow related patches are installed in e-business suite

This script will help you to check what ATG/Workflow related patches are installed in 11i and R12
SELECT BUG_NUMBER,
LAST_UPDATE_DATE,
DECODE (
bug_number,
2728236,
'OWF.G INCLUDED IN 11.5.9',
3031977,
'POST OWF.G ROLLUP 1 - 11.5.9.1',
3061871,
'POST OWF.G ROLLUP 2 - 11.5.9.2',
3124460,
'POST OWF.G ROLLUP 3 - 11.5.9.3',
3126422,
'11.5.9 Oracle E-Business Suite Consolidated Update 1',
3171663,
'11.5.9 Oracle E-Business Suite Consolidated Update 2',
3316333,
'POST OWF.G ROLLUP 4 - 11.5.9.4.1',
3314376,
'POST OWF.G ROLLUP 5 - 11.5.9.5',
3409889,
'POST OWF.G ROLLUP 5 Consolidated Fixes For OWF.G RUP 5',
3492743,
'POST OWF.G ROLLUP 6 - 11.5.9.6',
3868138,
'POST OWF.G ROLLUP 7 - 11.5.9.7',
3262919,
'FMWK.H',
3262159,
'FND.H INCLUDE OWF.H',
3258819,
'OWF.H INCLUDED IN 11.5.10',
3438354,
'11i.ATG_PF.H INCLUDE OWF.H',
3140000,
'ORACLE APPLICATIONS RELEASE 11.5.10 MAINTENANCE PACK',
3240000,
'11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 1',
3460000,
'11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2',
3480000,
'ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK',
4017300,
'ATG_PF:11.5.10 Consolidated Update (CU1) for ATG Product Family',
4125550,
'ATG_PF:11.5.10 Consolidated Update (CU2) for ATG Product Family',
5121512,
'AOL USER RESPONSIBILITY SECURITY FIXES VERSION 1',
6008417,
'AOL USER RESPONSIBILITY SECURITY FIXES 2b',
6047864,
'REHOST JOC FIXES (BASED ON JOC 10.1.2.2) FOR APPS 11i',
4334965,
'11i.ATG_PF.H RUP3',
4676589,
'11i.ATG_PF.H.RUP4',
5473858,
'11i.ATG_PF.H.RUP5',
5903765,
'11i.ATG_PF.H.RUP6',
6241631,
'11i.ATG_PF.H.RUP7',
4440000,
'Oracle Applications Release 12 Maintenance Pack',
5082400,
'12.0.1 Release Update Pack (RUP1)',
5484000,
'12.0.2 Release Update Pack (RUP2)',
6141000,
'12.0.3 Release Update Pack (RUP3)',
6435000,
'12.0.4 RELEASE UPDATE PACK (RUP4)',
5907545,
'R12.ATG_PF.A.DELTA.1',
5917344,
'R12.ATG_PF.A.DELTA.2',
6077669,
'R12.ATG_PF.A.DELTA.3',
6272680,
'R12.ATG_PF.A.DELTA.4',
7237006,
'R12.ATG_PF.A.DELTA.6',
6728000,
'12.0.6 RELEASE UPDATE PACK (RUP6)',
7303030,
'12.1.1 Maintenance Pack',
7651091,
'Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)',
7303033,
'Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)',
bug_number
)
bug,
ARU_RELEASE_NAME
FROM AD_BUGS b
WHERE b.BUG_NUMBER IN
('2728236',
'3031977',
'3061871',
'3124460',
'3126422',
'3171663',
'3316333',
'3314376',
'3409889',
'3492743',
'3262159',
'3262919',
'3868138',
'3258819',
'3438354',
'3240000',
'3460000',
'3140000',
'3480000',
'4017300',
'4125550',
'6047864',
'6008417',
'5121512',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631',
'4440000',
'5082400',
'5484000',
'6141000',
'6435000',
'5907545',
'5917344',
'6077669',
'6272680',
'7237006',
'6728000',
'7303030',
'7651091',
'7303033')
ORDER BY BUG_NUMBER, LAST_UPDATE_DATE, ARU_RELEASE_NAME;

Cheers!

Related Posts by Categories