While running autoconfig R12 - Autoconfig Failed with Error: FsCtxFileException: Start of Root Element Expected

Autoconfig Error :

[applTEST@hostname scripts]$ adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/oracle1/TEST/inst/apps/TEST_hostname/admin/log/05081154/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location     : /u01/oracle1/TEST/inst/apps/TEST_hostname
Classpath                   : /app/oracle1/TEST/apps/apps_st/comn/java/lib/appsborg2.zip:/app/oracle1/TEST/apps/apps_st/comn/java/classes

Using Context file          : /u01/oracle1/TEST/inst/apps/TEST_hostname/appl/admin/TEST_hostname.xml

Context Value Management will now update the Context file
ERROR: FsCtxFile.XMLParseException
oracle.xml.parser.v2.XMLParseException: Start of root element expected.
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:320)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:341)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:292)
at oracle.apps.ad.autoconfig.oam.FsCtxFile.init(FsCtxFile.java:58)
at oracle.apps.ad.autoconfig.oam.FsCtxFile.overwriteCtx(FsCtxFile.java:208)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.downloadToFs(CtxSynchronizer.java:346)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysContext(FileSysDBCtxMerge.java:681)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysFiles(FileSysDBCtxMerge.java:210)
at oracle.apps.ad.context.CtxValueMgt.mergeCustomInFiles(CtxValueMgt.java:1790)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1608)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
Error occured before Context Value Management could be completed
ERROR: Context Value Management Failed.
Terminate.

The logfile for this session is located at:

    /u01/oracle1/TEST/inst/apps/TEST_hostname/admin/log/05081154/adconfig.log



Solution:

Solution

To implement the solution, please execute the following steps:

1. Connect to SQL*PLUS as "APPLSYS" user. 

(The "APPLSYS" password is always the same as the "APPS" user.)

2. Backup the FND_OAM_CONTEXT_FILES table, for example: 

SQL> CREATE TABLE fnd_oam_context_files_bak 

AS SELECT * FROM fnd_oam_context_files; 

3. Truncate the FND_OAM_CONTEXT_FILES table, for example:

TRUNCATE TABLE fnd_oam_context_files; 

4. Re-run Autoconfig on all nodes to repopulate the data.