Autoconfig Failed with Error: FsCtxFileException: Start of Root Element Expected (Doc ID 876806.1)

On Oracle Applications 11.5.10.2, when attempting to run autoconfig the following error occurs.

Action to be taken : Copy the Data Base Context onto the file system

Result : Download of Context file failed

StackTrace:

java.lang.Exception: java.lang.Exception: oracle.apps.ad.autoconfig.oam.FsCtxFileException: Start of root element expected.

at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysContext(FileSysDBCtxMerge.java:655)

at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysFiles(FileSysDBCtxMerge.java:206)

at oracle.apps.ad.context.CtxValueMgt.mergeCustomInFiles(CtxValueMgt.java:1763)

at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1579)

at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:709)

ERROR: Context Value Management Failed.

Terminate.

CAUSE

The issue is caused by invalid data or corruption in the fnd_oam_context_files table

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.