r12.2

[satish]

Hi Erman,

Need your help

I wanted to change the s_custom_file path in context file.I want to put in under $APPL_TOP and so i have edited xml as below

[appldev@erpdevelopment template]$ grep -i s_custom_file $CONTEXT_FILE
         <oa_env_file type="custom" oa_var="s_custom_file" osd="unix">/u01/DEVDBAPPS/fs1/EBSapps/appl/customDEVDB_erpdevelopment.env</oa_env_file>
[appldev@erpdevelopment template]$

and i have created the file manually

[appldev@erpdevelopment appl]$ ls -lrt /u01/DEVDBAPPS/fs1/EBSapps/appl/customDEVDB_erpdevelopment.env
-rwxr-xr-x. 1 appldev dba 126 Oct  9 09:20 /u01/DEVDBAPPS/fs1/EBSapps/appl/customDEVDB_erpdevelopment.env
[appldev@erpdevelopment appl]$

Then brought down the apps services and ran autoconfig but my value was lost and it was picking the old value

[appldev@erpdevelopment appl]$ grep -i s_custom_file $CONTEXT_FILE
         <oa_env_file type="custom" oa_var="s_custom_file" osd="unix">/u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/appl/admin/customDEVDB_erpdevelopment.env</oa_env_file>
[appldev@erpdevelopment appl]$

Wanted to know from where it was picking up the old value

[ErmanArslansOracleBlog]

From the autoconfig templates probably.

[satish]

erman,

Even i changed the adxmlctx.tmp as below both in custom folder as well as in $AD_TOP/admin/template

I have edited the adxmlctx.tmp as below

/u01/DEVDBAPPS/fs1/EBSapps/appl/ad/12.0.0/admin/template
[appldev@erpdevelopment template]$ grep -i custom_file /u01/DEVDBAPPS/fs1/EBSapps/appl/ad/12.0.0/admin/template/adxmlctx.tmp
      <oa_env_file type="custom" oa_var="s_custom_file" osd="unix" default="%s_appl_config_home%\custom%s_contextname%.env">%s_custom_file%</oa_env_file>

But still it was picking up the old value,Any other ideas?

[ErmanArslansOracleBlog]

the version of your apps context file may be lower than what it is stored in db.

(s_contextserial)

Check table FND_OAM_CONTEXT_FILES -- SERIAL_NUMBER column...

If the db side is higher, then what you are facing is normal.

Read -  Autoconfig Reverts To Old Context File Values (Doc ID 357922.1)

This note clearly explaing the siuation.. It is for EBS 11i , but you can make it applicable to EBS 12.2 as well.

[satish]

It worked,perfect!!!

what i personally feel is we get quick replies from this blog than we raise an SR and work on it