How to determine if you are on the latest Autoconfig related patches.

run below queries in SQLPLUS connected as APPS user:

SET head off Lines 120 pages 100 col n_patch format A65 col bug_number format A10 col patch_name format A10 spool LACF_ptch_level.txt select ' LACF ' FROM dual; / select bug_number, decode(bug_number, '2488995' ,'11i.ADX.A' ,'2682177' ,'11i.ADX.B' ,'2682863' ,'11i.TXK-C' ,'2757379' ,'11i.TXK-D' ,'2902755' ,'11i.TXK-E' ,'3002409' ,'11i.ADX.C' ,'3104607' ,'11i.TXK-F' ,'3219567' ,'11i.TXK-B' ,'3239694' ,'11i.TXK-G' ,'3271975' ,'11i.ADX.E' ,'3416234' ,'11i.TXK-H' ,'3453499' ,'11i.ADX.F' ,'3594604' ,'11i.TXK-I' ,'3817226' ,'11i.ADX.E.1' ,'3950067' ,'11i.TXK-J' ,'4104924' ,'11i.TXK-K' ,'4367673' ,'11i.TXK-J.1' ,'4717668' ,'11i.TXK-M' ,'5035661' ,'11i.One_off' ,'5107107' ,'11i.TXK-N ROLLUP PATCH (AUG 2' ,'5414396' ,'11i.Rapidclone Cons Jan2008' ,'5414396 ' ,'11i RAPIDCLONE CONSOLIDATED FIXES JAN/2008 ' ,'5456078' ,'11i.One_off_a' ,'5473858' ,'11i.ATG_PF.H RUP5' ,'5478710' ,'11i.TXK-O' ,'5759055' ,'11i.TXK-P' ,'5903765' ,'11i.ATG_PF.H RUP6' ,'5985992' ,'11i.TXK-Q' ,'6372396' ,'11i.TXK-S' ,'6718351' ,'11i.Rapidclone CONSOLIDATED' ) n_patch, last_update_date FROM ad_bugs WHERE bug_number IN ( '2488995', '2682177', '2682863', '2757379', '2902755', '3002409', '3104607', '3219567', '3239694', '3271975', '3416234', '3453499', '3594604', '3817226', '3950067', '4104924', '4367673', '4717668', '5035661', '5107107', '5414396', '5414396', '5456078', '5473858', '5478710', '5759055', '5903765', '5985992', '6372396', '6718351' );

FOR MULTI NODE INSTANCES:

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( '2488995' ,'2682177' ,'2682863' ,'2757379' ,'2902755' ,'3002409' ,'3104607' ,'3219567' ,'3239694' ,'3271975' ,'3416234' ,'3453499' ,'3594604' ,'3817226' ,'3950067' ,'4104924' ,'4367673' ,'4717668' ,'5035661' ,'5107107' ,'5414396' ,'5414396 ' ,'5456078' ,'5473858' ,'5478710' ,'5759055' ,'5903765' ,'5985992' ,'6372396' ,'6718351' ); a_abstract := a_abstract_array_type( '11i.ADX.A' ,'11i.ADX.B' ,'11i.TXK-C' ,'11i.TXK-D' ,'11i.TXK-E' ,'11i.ADX.C' ,'11i.TXK-F' ,'11i.TXK-B' ,'11i.TXK-G' ,'11i.ADX.E' ,'11i.TXK-H' ,'11i.ADX.F' ,'11i.TXK-I' ,'11i.ADX.E.1' ,'11i.TXK-J' ,'11i.TXK-K' ,'11i.TXK-J.1' ,'11i.TXK-M' ,'11i.One_off' ,'11i.TXK-N ROLLUP PATCH (AUG 2' ,'11i.Rapidclone Cons Jan2008' ,'11i RAPIDCLONE CONSOLIDATED FIXES JAN/2008 ' ,'11i.One_off_a' ,'11i.ATG_PF.H RUP5' ,'11i.TXK-O' ,'11i.TXK-P' ,'11i.ATG_PF.H RUP6' ,'11i.TXK-Q' ,'11i.TXK-S' ,'11i.Rapidclone CONSOLIDATED' ); 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;
/

For RELEASE 12 instances:
SET head off Lines 120 pages 100 col n_patch format A65 col bug_number format A10 col patch_name format A10 spool LACF_ptch_level.txt select ' LACF ' FROM dual; / select bug_number, decode(bug_number, '4494373' ,'R12.TXK.A' ,'5872965' ,'R12.OAM.A' ,'5909746' ,'R12.TXK.A.1' ,'5917601' ,'R12.TXK.A.2' ,'6077487' ,'R12.TXK.A.DELTA.3' ,'6145693' ,'R12.Rapidclone Cons Jan2008' ,'6776948' ,'R12.Rapidclone CONSOLIDATED' ) n_patch, last_update_date FROM ad_bugs WHERE bug_number IN ( '4494373', '5872965', '5909746', '5917601', '6077487', '6145693', '6776948' );

R12 FOR MULTI NODE INSTANCES:

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( '4494373' ,'5872965' ,'5909746' ,'5917601' ,'6077487' ,'6145693' ,'6776948' ); a_abstract := a_abstract_array_type( 'R12.TXK.A' ,'R12.OAM.A' ,'R12.TXK.A.1' ,'R12.TXK.A.2' ,'R12.TXK.A.DELTA.3' ,'R12.Rapidclone Cons Jan2008' ,'R12.Rapidclone CONSOLIDATED' ); 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;
/

Change profile option Concurrent:GSM Enabled to 'Y' after every AutoConfig run if GSM is not required to be enabled

1. Backup the file $FND_TOP/admin/template/afcpgsm.sql then open it for editing.

2. Change the part that looks like:

set_profile(0, 'CONC_GSM_ENABLED',10001, 0,'Y',0);
To:
set_profile(0, 'CONC_GSM_ENABLED',10001, 0,'N',0);

i.e. Change the 'Y' to 'N'.

3. Save the file.

4. Next time when AutoConfig is run, it will set the profile option to 'N'.

How To Verify if Autoconfig is Enabled on 11.5.x

There exists a script under /bin named adcfginfo.sh (adcfginfo.cmd on Windows) which can be used to check if autoconfig is enabled in an instance.

Usage:

adcfginfo.sh [help]

adcfginfo.sh contextfile= [show=]
[log=] [appspass=]


This script generates a logfile under $APPL_TOP/admin/$CONTEXT_NAME/log when it is run.


another method to find out if an instance is autoconfig enabled is to open adovars or the environment file inder and check the file's header. If the instance was autoconfig enabled, the file would contain the following header.

############################################################################
#
# AutoConfig automatically generates this file. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink
# document 165195.1 for assistance.
#
############################################################################


One thing to note is that if a file containing this header is manually edited, it is no longer officially autoconfig enabled.