Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, July 19, 2007

Query to find out your ATG_PF.H Rollup level till RUP7

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 apps.ad_bugs
WHERE bug_number IN
(
'3438354',
'4017300',
'4125550',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631')
order by bug_number desc
/

5 comments:

Ger van de Lindt (Holland) said...

Hi, Thanks for this nice query. On question though. Why are you using bugnumber '3384350' in the WHERE claues and not in the SELECT clause?

Kind regards
Ger van de Lindt

Vikram Das said...

Hi,

If you notice, the select cause is using decode function, that is the reason I have bug number in the select clause. It works like this, If you have a patch number, then the correct description needs to be shown.

- Vikram

Nico said...

Hi Vikram
Thanks for the query. I have the same question that was asked in the previous post. You probably have misunderstood the question. Why there is no description for the patch no 3384350?

Regards,
Nico

Vikram Das said...

Hi Nico,

Thanks for pointing this out. I realize now that 3384350 is not supposed to be in the query. Patch 3384350 is the 11i SCM family pack J and has no meaning in this query. I have corrected the query and removed 3384350 from the query.

- Vikram

Puspak Virtues and Vices.... said...

How to find the RUP level in R12 instance ??