ATG patch level oracle apps 11i

How to find the atg patch level in oracle apps 11i ?

Use below query to query for ATG patch level:

Connect to apps schema “sqlplus apps/apps”

SELECT (bug_number),
‘4017300’,’ATG_PF.H RUP 1′,
‘4125550’,’ATG_PF.H RUP 2′,
‘4334965’,’ATG_PF.H RUP 3′,
‘4676589’,’ATG_PF.H RUP 4′,
‘5473858’,’ATG_PF.H RUP 5′,
‘5903765’,’ATG_PF.H RUP 6′,
‘6241631’,’ATG_PF.H RUP 7′)
FROM ad_bugs
WHERE bug_number IN
order by bug_number desc;


Nagulu Polagani

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