Oracle DBA ve Apps DBA blog

appsdba,e-business suite,dba

Posts Tagged ‘Techstack patch

11i veya R12 ye uygulanmış ATG patch lerini tespit etmek

leave a comment »

apps user ı ile aşağıdaki sql ler sisteme uygulanmış ATG patch lerini göstermektedir.

11i için

select bug_number, decode(bug_number,
‘3438354’, ’11i.ATG_PF.H’
,’4017300′ ,’11i.ATG_PF.H.RUP1′
,’4125550′ ,’11i.ATG_PF.H.RUP2′
,’4334965′ ,’11i.ATG_PF.H RUP3′
,’4676589′ ,’11i.ATG_PF.H RUP4′
,’5382500′ ,’11i.ATG_PF.H RUP5 HELP’
,’5473858′ ,’11i.ATG_PF.H.5′
,’5674941′ ,’11i.ATG_PF.H RUP5 SSO Integrat’
,’5903765′ ,’11i.ATG_PF.H RUP6′
,’6117031′ ,’11i.ATG_PF.H RUP6 SSO 10g Integration’
,’6330890′ ,’11i.ATG_PF.H RUP6 HELP’
,’6241631′ ,’11i.ATG_PF.H RUP7′
) n_patch, last_update_date
FROM ad_bugs
WHERE bug_number
IN ( ‘3438354’, ‘4017300’, ‘4125550’, ‘4334965’, ‘4676589’, ‘5382500’, ‘5473858’, ‘5674941’, ‘5903765’, ‘6117031’, ‘6330890’,’6241631′ );

r12 için

select bug_number, decode(bug_number, 
‘6272680’, ‘R12.ATG_PF.A.delta.4’ 
,’6077669′, ‘R12.ATG_PF.A.delta.3’ 
,’5917344′, ‘R12.ATG_PF.A.delta.2’ 
) n_patch, last_update_date 
FROM ad_bugs 
WHERE bug_number 
IN (‘6272680’, ‘6077669’, ‘5917344’); 

Advertisements

Written by Erdem Çer

08/07/2010 at 2:20 pm