Dear Sir , Thanks alot for this note. I appreciate this support alot. If You please have simple note or document to upgrade database 9.2.0.8 to 10G in oracle applications 11i I will be thankful for you alot. Thanks and Best Regards Mostafa Eletriby Oracle Technical Consultant Oracle Ebusiness suite Mobile: +2 012 42 65 339 --- On Sat, 9/6/08, fraz baig <aesthetic_hunzai@xxxxxxxxxxx> wrote: From: fraz baig <aesthetic_hunzai@xxxxxxxxxxx> Subject: RE: ATG level To: ora-apps-dba@xxxxxxxxxxxxx Date: Saturday, September 6, 2008, 3:00 AM #yiv2054236824 .hmmessage P { margin:0px;padding:0px;} #yiv2054236824 { FONT-SIZE:10pt;FONT-FAMILY:Tahoma;} 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 +0530 From: k.sridba@xxxxxxxxx To: ora-apps-dba@xxxxxxxxxxxxx Subject: ATG level DBAs How to know the ATG patch level of my applications. Thanks in advance. Get news, entertainment and everything you care about at Live.com. Check it out!