The Oracle E-Business Suite Logging Framework provides the ability to store and retrieve log messages for debugging, error reporting, and alerting purposes. This blog explains about collecting E-Business Suite Logs in workflow.
Set the below logging configuration parameters to collect logs in workflow.
Set the logging configuration parameters
Navigate to the Profiles page as below
Functional Administrator -> Core Services -> Profiles
Set the below specified profile option values at Site Level or at the User level.
AFLOG_ENABLED - Yes
Specifies if logging is enabled or not. The default value is NULL (False).
AFLOG_MODULE - %wf%
Specifies which modules are logged. The default value is NULL (%).
AFLOG_LEVEL - Statement
Specifies the logging level. The default value is NULL (Log.UNEXPECTED).
AFLOG_FILENAME - << NO Value>>
Specifies the file where middle-tier log messages are written.
After setting the above values, clear the cache by using below steps.
Navigate to the Caching Framework page as below
Functional Administrator -> Core Services -> Caching Framework
Click on Total Caching components link
Search for code : PROFILE%OPTION%
Select check boxes for PROFILE_OPTION_CACHE & PROFILE_OPTION_VALUE_CACHE
Click on clear cache button
Logout from the application
E-Business Suite Logs for Workflow can be collected using the below steps.
Set the above specified profile option values at Site Level or at the user level.
select max(log_sequence) from fnd_log_messages -- <SEQ1>
Run your test case to reproduce the issue
Now get all the relevant log messages using below query
select * from fnd_log_messages where module like '%wf%' and log_sequence >= <SEQ1> order by log_sequence;
where <SEQ1> is the max log sequence number as noted in step3.
Upload the query o/p to an excel sheet.
Refer to Logging Framework Overview section in Oracle E-Business Suite Developer's Guide