Find ATG Rollup Patch Level in R12

How to Find ATG Rollup Patch Level in R12??

Please use below query to query for ATG rollup Patch level in Oracle Applications.

connect to apps schema “sqlplus apps/apps”
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)’
from AD_BUGS b
where b.BUG_NUMBER in (‘4440000′,’5082400′,’5484000′,’6141000′,’6435000’,
order by patch;

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)