Page 1 of 1
How to find applied family pack in oracle apps
Posted: Fri Feb 29, 2008 7:48 am
by 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.
Posted: Sun Mar 02, 2008 8:31 am
by latif
Hi All,
you can check ad_applied_patches in applsys schema,
bye
Posted: Wed Mar 12, 2008 2:39 am
by 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