Oct 10, 2012

Enable FND Logging

Follow the steps to enable FND Logging.


 A. Set the system profiles 
          FND: Debug Log Enabled -> Yes 
     FND: Debug Log Level   -> Statement 
     FND: Debug Log Module  -> % 

  B. Submit Create Accounting, or any process which has FND log statements.

  C. Run the following SQL after completion of CP using the CP request id 

       SELECT log_sequence, module,message_text 
       FROM fnd_log_messages 
       WHERE transaction_context_id in 
            (select transaction_context_id 
             from fnd_log_transaction_context 
             where transaction_id = <CP request id>) 
       ORDER BY log_sequence; 

No comments:

Post a Comment