Reports2017-11-18T12:27:27+00:00

FND Log Messages

Description
Categories: Application, DBA, Enginatics

select
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 in (select fu.user_id from fnd_user fu where fu.user_name=:user_name)
LOV
Log Level To
flm.log_level<=:log_level_to
LOV
Log Level From
flm.log_level>=:log_level_from
LOV
Date To
flm.timestamp<=:date_to
DateTime
Date From
flm.timestamp>=:date_from
DateTime
Within x Days
flm.timestamp>=sysdate-:days
Number