Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

My Cloud Certifications:
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Saturday, February 1, 2014

Enable FND Debug and get data from FND_LOG_MESSAGES table

Enable FND Debug and get log information from FND_LOG_MESSAGES table:


If the size of FND_LOG_MESSAGES table is too big? then

Considering running the concurrent request:  “Purge Debug Log and System Alerts”. 


 Enable Debug mode:-


1)Log into system admin responsibility and set the following profile options
FND: Debug Log Enabled - Yes
FND: Debug Log Level - Statement  (Consider other options from the drop down if needed)
FND: Debug Log Module - %

 2)Capture the Max sequence number
 SELECT MAX(log_sequence)  b4seq# FROM fnd_log_messages;

 3)Try to reproduce the issue with above user for which FND profile options are set.

4)Capture the Max sequence number again:
SELECT MAX(log_sequence) afterseq# FROM fnd_log_messages;

5)Run following select to get the log messages
log_sequence > b4seq# -1 and b4seq#