FND Messages

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
select
fav.application_name application,
fnm.message_name,
fnm.language_code language,
fnm.message_text,
fnm.message_number,
xxen_util.meaning(fnm.type,'MESSAGE_TYPES',0) type,
fnm.max_length,
fnm.description,
xxen_util.meaning(fnm.category,'FND_KBF_CATEGORY',0) alert_category,
xxen_util.meaning(fnm.severity,'FND_KBF_SEVERITY',0) alert_severity,
xxen_util.meaning(fnm.fnd_log_severity,'FND_LOG_SEVERITY_LEVEL',0) log_severity,
xxen_util.user_name(fnm.created_by) created_by,
xxen_util.client_time(fnm.creation_date) creation_date,
xxen_util.user_name(fnm.last_updated_by) last_updated_by,
xxen_util.client_time(fnm.last_update_date) last_update_date
from
fnd_new_messages fnm,
fnd_application_vl fav
where
1=1 and
fnm.application_id=fav.application_id
order by
fav.application_name,
fnm.message_name,
fnm.language_code
Parameter NameSQL textValidation
Message Text contains
lower(fnm.message_text) like '%'||:message_text_contains||'%'
Char
Message Name like
upper(fnm.message_name) like upper(:message_name_like)
LOV
Application
fav.application_name=:application_name
LOV
Language Code
fnm.language_code=:language_code
LOV
Download
Related Blitz Reports
XLA Create and Assign Sources- Not Supported: Reserved For Future Use XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use EGO Item Image Definition Data Template CAC Interface Error Summary JL Argentine Turnover Tax Data Upload Verification PO View Award Changes Data Definition ECC Project Manufacturing, Commitments WSH Auto Ship Confirm CAC Inventory Lot and Locator OPM Value (Period-End)
Blitz Report™