Search Results fnd_new_messages

Overview

The FND_NEW_MESSAGES table is a core repository for translatable application messages within Oracle E-Business Suite (EBS). Residing in the APPLSYS schema and owned by the Application Object Library (FND) product, it serves as the central store for all user-facing text strings, error messages, prompts, and labels that appear in the application's graphical user interface (GUI). Its role is fundamental to the internationalization and localization framework of EBS, enabling the system to present messages in the language specified by the user's session. This table is the successor to the older FND_MESSAGES table and is the primary table used for message storage in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify and store a message for a specific application and language. Its primary key is a composite of APPLICATION_ID, MESSAGE_NAME, and LANGUAGE_CODE. The APPLICATION_ID links to FND_APPLICATION, scoping the message to a particular product module. The MESSAGE_NAME is the internal identifier used by developers to reference the message in code. The LANGUAGE_CODE, linked to FND_LANGUAGES, specifies the translation locale. The most critical data column is MESSAGE_TEXT, which holds the actual translated string displayed to the end-user. Other supporting columns typically include metadata such as creation dates, last update dates, and the user who last modified the record, facilitating maintenance and auditing.

Common Use Cases and Queries

The primary use case is the runtime retrieval of translated text by the FND_MESSAGE API. When an application calls a function like FND_MESSAGE.SET_NAME('APP','MESSAGE_NAME'), the system queries this table to fetch the corresponding MESSAGE_TEXT for the current session's language. Administrators and developers frequently query this table for troubleshooting, auditing, and customization purposes. A common pattern is to search for messages containing specific text or to verify translations for a module.

• Finding a specific message: SELECT message_text FROM apps.fnd_new_messages WHERE message_name = 'DUPLICATE_VALUE' AND application_id = 660 AND language_code = 'US';
• Listing all messages for an application: SELECT message_name, language_code, message_text FROM apps.fnd_new_messages WHERE application_id = 660 ORDER BY message_name, language_code;
• Identifying custom messages added to the system: SELECT * FROM apps.fnd_new_messages WHERE created_by != 0 OR last_updated_by != 0;

Related Objects

FND_NEW_MESSAGES has integral relationships with several key EBS objects. As per the provided metadata, it holds foreign key relationships to FND_APPLICATION (via APPLICATION_ID) and FND_LANGUAGES (via LANGUAGE_CODE), ensuring referential integrity for applications and installed languages. Furthermore, it is referenced by other product-specific tables, indicating its central role. The metadata shows foreign key dependencies from OKL_TRX_MSGS in Oracle Lease and Finance Management (OKL) and PON_CUSTOM_MESSAGES in Oracle Sourcing (PON), where these modules store references to standard application messages. The primary API for interacting with this table is the FND_MESSAGE PL/SQL package, which provides programmatic functions for setting, retrieving, and displaying messages.