RE: ATG level

Dear Sri,
 
 You can use following query for any of the ATG levels
 
select b.bug_number bug, b.LAST_UPDATED_BY ldate, decode(bug_number,
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',
4334965, '11i.ATG_PF.H RUP3',
4676589, '11i.ATG_PF.H.RUP4',
5473858, '11i.ATG_PF.H.RUP5') patch
from AD_BUGS b
where b.BUG_NUMBER in ('3438354','3240000', '3460000', 
'3140000','3480000','4017300',
'4125550','4334965', '4676589', '5473858')
order by patch ;

Date: Sat, 6 Sep 2008 12:10:47 +0530From: k.sridba@xxxxxxxxxxx: 
ora-apps-dba@xxxxxxxxxxxxxxxxxxxx: ATG level
DBAs
 
How to know the ATG patch level of my applications.
 
Thanks in advance.
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

Other related posts: