FND Messages – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Message Text contains, Message Name like, Application, Language Code
Oracle EBS Tables Used
fnd_new_messages, fnd_application_vl
Report Categories
Related Reports
PAY Payroll Process Summary, FA Asset Book Details
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Messages 19-Oct-2024 094002.xlsx |
| Blitz Report™ XML Import | FND_Messages.xml |
| SQL Source | FND Messages.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-messages/ |
Executive Summary
The FND Messages report lists the standard and custom messages defined in the Message Dictionary. These are the text strings used for error messages, warnings, and labels in Forms and OAF pages.
Business Challenge
- Customization Review: Finding all custom messages (e.g., starting with
XX%) created for custom validations. - Translation: Extracting message text to send to a translation agency.
- Error Analysis: Searching for the text of a cryptic error message to find its internal name and owning application.
The Solution
This Blitz Report lists the message details:
- Message Name: The internal code (e.g.,
APP-FND-01234). - Message Text: The user-facing text, including token placeholders (e.g.,
Value &VALUE is invalid). - Application: The owning module.
Technical Architecture
The report queries FND_NEW_MESSAGES.
Parameters & Filtering
- Message Text contains: Search for a specific phrase (e.g., “insufficient funds”).
- Message Name like: Filter by code pattern.
Performance & Optimization
- Fast Execution: Runs quickly against the message table.
FAQ
- Q: Can I change standard Oracle messages?
- A: It is technically possible but highly discouraged as patches will overwrite them. You should use “Custom Messages” or “Forms Personalization” to override text.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH