XML Gateway ECX Transaction Logs

Pre 11.5.10: the logs are directed to a directory present in UTL_FILE_DIRECTORY
Post 11.5.10: the logs are maintained using FND_LOGS

How to enable Logs
Enable the Profile below

FND: Debug Log Module = ecx%
FND: Debug Log Enabled = Yes
FND: Debug Log Level = Statement

Login and navigate to Oracle Application Manager > Monitoring > Logs and query for module: ecx%.

The logs can also be retrieved by the below steps:

Execute $ECX_TOP/patch/115/sql/ECXLGINI.sql.
Review the Log messages in OAM UI. Login and navigate to Oracle Application Manager > Monitoring > Logs and query for module: ecx%.



Physical ecx log file can be fetched as below:

·         Run the below query:

 select module from apps.fnd_log_messages where module like ‘ecx%’ order by     log_sequence;

·         execute $ECX_TOP/patch/115/sql/ECXLGUTL.sql .

This script will prompt for a module name.