Search Results fnd_menus_vl




Overview
Explore in AI Chat

Overview

FND_MENUS_VL is a multilingual (translated) view owned by the APPS schema in Oracle E-Business Suite. It is part of the FND — Application Object Library product and is documented as a VALID object in both EBS 12.1.1 and 12.2.2. The view exposes menu definitions used by the Oracle EBS security and navigation model, combining the language-independent attributes of a menu with its language-specific translated name and description. Its suffix, _VL, is the standard EBS naming convention for a "view with translation" that resolves translated columns for the session's current language. The view is therefore the preferred reporting and integration interface for querying menu metadata, since it presents user-facing menu text rather than internal code values.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both accessed through synonyms in the APPS schema:

  • FND_MENUS — the base table holding language-independent menu attributes, including MENU_ID, MENU_NAME, TYPE, and the standard WHO audit columns.
  • FND_MENUS_TL — the translation table holding USER_MENU_NAME and DESCRIPTION for each installed language.

The view definition joins these two objects on MENU_ID and filters the translation by the current session language:

SELECT B.ROWID ROW_ID, B.MENU_ID, B.MENU_NAME, B.TYPE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATION_DATE, B.CREATED_BY, T.USER_MENU_NAME, T.DESCRIPTION FROM FND_MENUS_TL T, FND_MENUS B WHERE B.MENU_ID = T.MENU_ID AND T.LANGUAGE = USERENV('LANG')

Because the join is filtered by USERENV('LANG'), the view returns exactly one translated row per menu for the language of the querying session. The ROW_ID column supplies the base-table ROWID, allowing the view to be treated like a single base object for certain forms and API purposes.

Key Columns

  • MENU_ID — the internal primary key of the menu, used as the foreign key in menu hierarchy and responsibility-assignment relationships.
  • MENU_NAME — the internal, language-independent menu name, used by FND functions and menu-loading logic.
  • USER_MENU_NAME — the translated, user-facing menu name displayed in the Navigator and administration forms.
  • DESCRIPTION — the translated description of the menu.
  • TYPE — indicates the menu type classification, distinguishing menu constructs (for example, standard menus versus menu entries used by the security model).
  • ROW_ID — the ROWID of the underlying FND_MENUS row.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard WHO audit columns inherited from FND_MENUS, supporting change tracking and audit reporting.

Common Use Cases and Queries

FND_MENUS_VL is typically used to report on the menu structure, to resolve menu IDs to readable names, and to join menu definitions to responsibility or function-assignment data. A representative query lists all menus with their translated names and descriptions:

SELECT MENU_ID, MENU_NAME, USER_MENU_NAME, DESCRIPTION, TYPE FROM APPS.FND_MENUS_VL ORDER BY USER_MENU_NAME;

To locate a menu by its displayed name:

SELECT MENU_ID, MENU_NAME, USER_MENU_NAME FROM APPS.FND_MENUS_VL WHERE USER_MENU_NAME LIKE 'System%';

Because translations are resolved at runtime, the same query returns text in the language defined by the session's LANG setting, which makes the view suitable for localized reporting and for validating that a required translation exists in a given language. Administrators also use it to confirm menu definitions before assigning menus to responsibilities or diagnosing Navigator visibility issues.