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),
decode((bug_number),
‘3438354’,’ATG_PF.H’,
‘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
(‘3384350’,
‘3438354’,
‘4017300’,
‘4125550’,
‘4334965’,
‘4676589’,
‘5473858’,
‘5903765’,
‘6241631’)
order by bug_number desc;

 

Nagulu Polagani

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