An Oracle blog about Workflow logs
-
Server
May 10, 2018
Collecting E-Business Suite logs in workflow
Overview
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.
Logging Configuration Parameters
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
Steps to collect E-Business Suite Logs
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.
- Get the max log sequence using below query and note down this number and refer as SEQ1.
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.
Additional Resources
Refer to Logging Framework Overview section in Oracle E-Business Suite Developer's Guide