Sunday, June 15, 2014

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.
Reactions:

0 comments:

Post a Comment