Wednesday, October 12, 2016

Find out HRMS Family Pack level upto RUP9

SELECT 'HR_PF.' ||
DECODE (BUG_NUMBER,'2115771' ,'A(2115771)',
'2268451' ,'B(2268451)',
'2502761' ,'C(2502761)',
'2632500' ,'D(2632500)',
'2803988' ,'E(2803988)',
'2968701' ,'F(2968701)',
'3116666' ,'G(3116666)',
'3233333' ,'H(3233333)',
'3127777' ,'I(3127777)',
'3333633' ,'J(3333633)',
'3500000' ,'K(3500000)',
'5055050' ,'K RUP1(5055050)',
'5337777' ,'K RUP2(5337777)',
'6699770' ,'K RUP3(6699770)',
'7666111' ,'K RUP4(7666111)',
'9062727' ,'K RUP5(9062727)',
'10015566' ,'K RUP6(10015566)',
'12807777', 'K RUP7(12807777)',
'14488556', 'K RUP8(14488556)',
'17774746','.K RUP9(17774746)') ||
' patchset is installed ' "HR Family Pack",
to_char(last_update_date,'DD-MON-YYYY HH24:MI:SS') "DATE APPLIED"
FROM AD_BUGS
WHERE BUG_NUMBER in ('2115771','2268451','2502761','2632500','2803988',
'2968701','3116666','3233333','3127777','3333633','3500000', '5055050',
'5337777','6699770','7666111','9062727','10015566','12807777','14488556','17774746')
ORDER BY to_number(BUG_NUMBER) DESC
/

Ref Note: SQL: HRMS Products Installation Status (Doc ID 414631.1)
Post a Comment

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information" Error DB Autoconfig ...