FND Log Messages

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics
Repository
GitHub

SQL 14 lines

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,
fltc.transaction_type,
flm.*
from
fnd_log_messages flm,
fnd_log_transaction_context fltc
where
1=1 and
flm.transaction_context_id=fltc.transaction_context_id(+)
order by
flm.log_sequence desc

Parameters 8

ParameterTypeList of values SQL
User NameLOV
flm.user_id=xxen_util.user_id(:user_name)
ModuleLOV
flm.module=:p_module
Module ContainsChar
lower(flm.module) like '%' || lower(:p_module_like) || '%'
Logged within x DaysNumber
flm.timestamp>=sysdate-:days
Date FromDateTime
flm.timestamp>=:date_from
Date ToDateTime
flm.timestamp<=:date_to
Log Level FromLOV
flm.log_level>=:log_level_from
Log Level ToLOV
flm.log_level<=:log_level_to