Saturday, November 06, 2010

ATG Rollup Patch Level in R12

Use the following query to find the ATG rollup Patch level in your application.

column BUG format a8;
column PATCH format a60;
set linesize 100;
set pagesize 200;
select b.bug_number BUG, b.LAST_UPDATE_DATE LDATE, decode(bug_number,
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)'
) PATCH
from AD_BUGS b
where b.BUG_NUMBER in ('4440000','5082400','5484000','6141000','6435000',
'5907545','5917344','6077669','6272680','7237006','6728000')
order by patch; 


Regards,
Sukhwinder Singh


.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.