FND Log Messages

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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.log_sequence desc
Parameter Name SQL text Validation
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
FND Concurrent Requests 11i FND Concurrent Requests CE Bank Statement and Reconciliation EGO Item Image Definition Data Template 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™

Blitz Report™ provides multiple benefits: