FND Log Messages

Description
Run FND Log Messages and other Oracle EBS reports with Blitz Report™ on our demo environment
select
xxen_util.user_name(flm.user_id) user_name,
xxen_util.meaning(flm.log_level,'AFLOG_LEVELS',0) log_level_name,
flm.*
from
fnd_log_messages flm
where
1=1
order by
flm.timestamp desc
Parameter Name SQL text Validation
User Name
flm.user_id=xxen_util.user_id(:user_name)
LOV
Logged within x Days
flm.timestamp>=sysdate-:days
Number
Date From
flm.timestamp>=:date_from
DateTime
Date To
flm.timestamp<=:date_to
DateTime
Log Level From
flm.log_level>=:log_level_from
LOV
Log Level To
flm.log_level<=:log_level_to
LOV