How to check if you have applied IHELP related patches

Single Tier Check to see what iHELP patchsets you have applied

SET head off Lines 120 pages 100
col n_patch format A65
col bug_number format A10
col patch_name format A10
spool iHELP_ptch_level.txt
select ' iHELP ' FROM dual;
/
select bug_number, decode(bug_number,
'2400604' '11i.JULY 2002 IHELP CONSOLIDAT'
,'2662802' ,'11i.11.5.9 CONSOLIDATED IHELP'
,'2979358' ,'11i.Updates User guide 11.5.9'
,'3048030' ,'11i.JSp Help Oracle Applications'
,'3049986' ,'11i.CORRECTION TO HELPSEARCHTIPS'
,'3058486' ,'11i. FND.G CONSOLIDATED DOCUMENTAT'
,'3215160' ,'11i.Concurrent Program definition '
,'3275245' ,'11i.11.5.10 ONLINE HELP CONSOLIDA'
,'3394061 ' ,'11i.iHelp Rollup'
,'3457622' ,'11i.ADDITIONAL TARGETS FOR WINDOW'
,'3480901' ,'11i.ACCESSIBILITY STATEMENTS IN R1'
,'3621328' ,'11i.FUNCTIONAL ADMINISTRATION FRAM'
,'3721322' ,'11i.DOCUMENT MANAGEMENT ONLINE HE'
,'3835545' ,'11i. COMBINED ATTACHMENT AND LOBS'
,'3970596' ,'11i.NLS: OAATTACHMENTAPIHELPER'
,'4075479' ,'11i.UMX ONLINE HELP FILES'
,'4963151' ,'11i.11I.ATG_PF.H RUP3'
,'5382500' ,'11i.ATG_PF.H RUP5 HELP'
,'5395066' ,'11i.DOCUMENTATION FRM.H'
,'5530097' ,'11i.HELP BUILDER WONT LOAD'
,'5608991' ,'11i.HELP FAILS TO LAUNCH AFTER RU4'
,'6330890' ,'11i.ATG_PF.H RUP6 HELP'
) n_patch, last_update_date
FROM ad_bugs
WHERE bug_number IN ( '2400604' '2662802' '2979358' '3048030' '3049986' '3058486' '3215160' '3275245' '3394061 ' '3457622' '3480901' '3621328' '3721322' '3835545' '3970596' '4075479' '4963151' '5382500' '5395066' '5530097' '5608991' '6330890' );

Multi Tier Check to see what patches have been applied and not applied

set serveroutput on size 100000
DECLARE
TYPE p_patch_array_type is varray(100) of varchar2(10);
TYPE a_abstract_array_type is varray(100) of varchar2(60);
p_patchlist p_patch_array_type;
a_abstract a_abstract_array_type;
p_appltop_name VARCHAR2(50);
p_patch_status VARCHAR2(15);
p_appl_top_id NUMBER;

CURSOR alist_cursor IS
SELECT appl_top_id, name
FROM ad_appl_tops;

procedure println(msg in varchar2)
IS
BEGIN
dbms_output.put_line(msg);
END;

BEGIN
open alist_cursor;

p_patchlist := p_patch_array_type( '2400604'
,'2662802'
,'2979358'
,'3048030'
,'3049986'
,'3058486'
,'3215160'
,'3275245'
,'3394061 '
,'3457622'
,'3480901'
,'3621328'
,'3721322'
,'3835545'
,'3970596'
,'4075479'
,'4963151'
,'5382500'
,'5395066'
,'5530097'
,'5608991'
,'6330890'
);
a_abstract := a_abstract_array_type( '11i.JULY 2002 IHELP CONSOLIDAT'
,'11i.11.5.9 CONSOLIDATED IHELP'
,'11i.Updates User guide 11.5.9'
,'11i.JSp Help Oracle Applications'
,'11i.CORRECTION TO HELPSEARCHTIPS'
,'11i. FND.G CONSOLIDATED DOCUMENTAT'
,'11i.Concurrent Program definition '
,'11i.11.5.10 ONLINE HELP CONSOLIDA'
,'11i.iHelp Rollup'
,'11i.ADDITIONAL TARGETS FOR WINDOW'
,'11i.ACCESSIBILITY STATEMENTS IN R1'
,'11i.FUNCTIONAL ADMINISTRATION FRAM'
,'11i.DOCUMENT MANAGEMENT ONLINE HE'
,'11i. COMBINED ATTACHMENT AND LOBS'
,'11i.NLS: OAATTACHMENTAPIHELPER'
,'11i.UMX ONLINE HELP FILES'
,'11i.11I.ATG_PF.H RUP3'
,'11i.ATG_PF.H RUP5 HELP'
,'11i.DOCUMENTATION FRM.H'
,'11i.HELP BUILDER WONT LOAD'
,'11i.HELP FAILS TO LAUNCH AFTER RU4'
,'11i.ATG_PF.H RUP6 HELP'
);

LOOP
FETCH alist_cursor INTO p_appl_top_id, p_appltop_name;
EXIT WHEN alist_cursor%NOTFOUND;
IF p_appltop_name NOT IN ('GLOBAL','*PRESEEDED*')
THEN
println(p_appltop_name ':');
for i in 1..p_patchlist.count
LOOP
p_patch_status := ad_patch.is_patch_applied('11i', p_appl_top_id, p_patchlist(i));
println('..Patch ' a_abstract(i)
' 'p_patchlist(i)' was '
p_patch_status);
END LOOP;
END IF;
println('.');
END LOOP;
close alist_cursor;
END;
/
===============================================================================

Release 12

Single Tier Check to see what iHELP patchsets you have applied

SET head off Lines 120 pages 100
col n_patch format A65
col bug_number format A10
col patch_name format A10
spool iHELP _ptch_level.txt
select ' iHELP ' FROM dual;
/
select bug_number, decode(bug_number,
'5051400' 'R12.ONLINE HELP FOR ORACLE APPLICATIONS RELEASE 12'
,'5240400' ,'R12.Consolidated online help'
,'5717700' ,'R12 CONSOLIDATED ONLINE HELP FOR 12.0.3'
,'5983726' ,'R12.Help Update 2 for 12.0'
,'6317446' ,'R12.OAT online hlp 3 for 12.0'
,'6333541' ,'R12.apps user guide help'
,'6333541' ,'R12.CONSOLIDATED ONLINE HELP 12.0.2'
,'6400100' ,'R12.CONSOLIDATED ONLINE HELP 12.0.4'
,'7109200' ,'R12.CONSOLIDATED ONLINE HELP 12.0.6'
,'6496142' ,'R12. ORACLE APPLICATIONS TECHN'
) n_patch, last_update_date
FROM ad_bugs
WHERE bug_number IN ( '5051400' '5240400' '5717700' '5983726' '6317446' '6333541' '6333541' '6400100' '6496142' );

Multi Tier Check to see what patches have been applied and not applied

Cut and paste the following and send to customer
When they paste into sqlplus session they need to follow it with /

set serveroutput on size 100000
DECLARE
TYPE p_patch_array_type is varray(100) of varchar2(10);
TYPE a_abstract_array_type is varray(100) of varchar2(60);
p_patchlist p_patch_array_type;
a_abstract a_abstract_array_type;
p_appltop_name VARCHAR2(50);
p_patch_status VARCHAR2(15);
p_appl_top_id NUMBER;

CURSOR alist_cursor IS
SELECT appl_top_id, name
FROM ad_appl_tops;

procedure println(msg in varchar2)
IS
BEGIN
dbms_output.put_line(msg);
END;

BEGIN
open alist_cursor;

p_patchlist := p_patch_array_type( '5051400'
,'5240400'
,'5717700'
,'5983726'
,'6317446'
,'6333541'
,'6333541'
,'6400100'
,'7109200'
,'6496142'
);
a_abstract := a_abstract_array_type( 'R12.ONLINE HELP FOR ORACLE APPLICATIONS RELEASE 12'
,'R12.Consolidated online help'
,'R12 CONSOLIDATED ONLINE HELP FOR 12.0.3'
,'R12.Help Update 2 for 12.0'
,'R12.OAT online hlp 3 for 12.0'
,'R12.apps user guide help'
,'R12.CONSOLIDATED ONLINE HELP 12.0.2'
,'R12.CONSOLIDATED ONLINE HELP 12.0.4'
,'R12.CONSOLIDATED ONLINE HELP 12.0.6'
,'R12. ORACLE APPLICATIONS TECHN'
);

LOOP
FETCH alist_cursor INTO p_appl_top_id, p_appltop_name;
EXIT WHEN alist_cursor%NOTFOUND;
IF p_appltop_name NOT IN ('GLOBAL','*PRESEEDED*')
THEN
println(p_appltop_name ':');
for i in 1..p_patchlist.count
LOOP
p_patch_status := ad_patch.is_patch_applied('11i', p_appl_top_id, p_patchlist(i));
println('..Patch ' a_abstract(i)
' 'p_patchlist(i)' was '
p_patch_status);
END LOOP;
END IF;
println('.');
END LOOP;
close alist_cursor;
END;
/