FND Log Messages

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
select
trunc(flm.timestamp,'month') month,
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.log_sequence desc
Parameter NameSQL textValidation
User Name
flm.user_id=xxen_util.user_id(:user_name)
LOV
Module
flm.module=:p_module
LOV
Module Contains
lower(flm.module) like '%' || lower(:p_module_like) || '%'
Char
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
Download
Related Blitz Reports
CAC Interface Error Summary FND Messages FND Concurrent Requests 11i FND Concurrent Requests JL Argentine Turnover Tax Data Upload Verification ECC Enterprise Asset Management, Work Orders (Maintenance), SQL1 PQH Report Under Budgeted Entities PO View Award Changes Data Definition ECC Project Manufacturing, Commitments
Blitz Report™