How to find applied family pack in oracle apps

[ghanshyamkhetan]

Hi All,

Can you please tell me how can i find which family pack is applied in my database. Can u just tell me the table name.

[latif]

Hi All,

you can check ad_applied_patches in applsys schema,


bye

[shhuang]

which product's family pack?

1. Financials Family Pack using
select
substr(bug_number,1,10) BUG,
decode(bug_number,
'1807809','11i.FIN_PF.A',
'2218339','11i.FIN_PF.B',
'2380068','11i.FIN_PF.C',
'2629235','11i.FIN_PF.D',
'3016445','11i.FIN_PF.D.1',
'2842697','11i.FIN_PF.E',
'3153675','11i.FIN_PF.F',
'3653484','11i.FIN_PF.G'
) PATCH,
creation_date App_date
from ad_bugs
where bug_number in ('1807809','2218339','2380068','2629235','3016445','2842697','3153675','3653484'
)
order by 2;



2. ATG Family Pack using
SELECT (bug_number),
decode((bug_number),
'4017300','ATG CU 1',
'4125550','ATG CU 2',
'4334965','ATG CU 3',
'4676589','ATG CU 4',
'5473858','ATG CU 5',
'Other')
FROM ad_bugs
WHERE bug_number IN
('4017300','4125550','4334965','4676589','5473858')
order by bug_number desc;

--from Oracle Metalink