X

An Oracle blog about Workflow logs

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.

  1. Set the logging configuration parameters

    1. Navigate to the Profiles page as below
      Functional Administrator -> Core Services -> Profiles

    2. 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.

  2. After setting the above values, clear the cache by using below  steps.

    1. Navigate to the Caching Framework page as below
      Functional Administrator -> Core Services -> Caching Framework

    2. Click on Total Caching components link

    3. Search for code : PROFILE%OPTION%

    4. Select check boxes for PROFILE_OPTION_CACHE & PROFILE_OPTION_VALUE_CACHE

    5. Click on clear cache button

  3. Logout from the application

Steps to collect E-Business Suite Logs

E-Business Suite Logs for Workflow can be collected using the below steps.

  1. Set the above specified profile option values at Site Level or at the user level.

  2. 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>
  3. Run your test case to reproduce the issue

  4. 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.

  5. 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

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.