Tuesday, June 28, 2016

E-Business Suite R12 CPU Version

Hi All,

Here is script to find out , latest cpu that has been applied to R 12.1.

select b.bug_number BUG, b.LAST_UPDATE_DATE LDATE, decode(bug_number,
13322561, 'cpu_jan12',
13621942, 'cpu_apr12',
13979377, 'cpu_jul12',
14321237, 'cpu_oct12',
14782696, 'cpu_jan13',
16196190, 'cpu_apr13',
16772121, 'cpu_jul13',
17203944, 'cpu_oct13',
17631895, 'cpu_jan14',
17631895, 'cpu_apr14',
18122013, 'cpu_jul14',
19258579, 'cpu_oct14',
19873049, 'cpu_jan15',
20406628, 'cpu_apr15',
20953340, 'cpu_jul15',
21507207, 'cpu_oct15',
22133441, 'cpu_jan16',
22614470, 'cpu_apr16'
) PATCH
from APPS.AD_BUGS b
where b.BUG_NUMBER in ('13322561','13621942','13979377','14321237','14782696','16196190','16772121','17203944','17631895','17631895','18122013','19258579','19873049','20406628','20953340','21507207','22133441',
'22614470') order by 2;

Hope this helps you.

Thanks,
Uday