Search Results fnd_menu_entries_vl




Overview
Explore in AI Chat

Overview

FND_MENU_ENTRIES_VL is a bilingual (VL, "view with language") view in the APPS schema belonging to the FND — Application Object Library product. It presents the ordered entries that make up Oracle EBS menus, combining the untranslated structural columns stored in FND_MENU_ENTRIES with the translatable prompt and description text held in FND_MENU_ENTRIES_TL. Because it resolves the translatable text automatically against the session language, the view returns prompt and description values already localized for the current user, making it the preferred access point for reporting and integration rather than querying the base tables directly.

The object searched for, grant_flag, is one of the columns the view exposes and is central to how EBS decides whether a menu entry is granted to a responsibility. In Oracle EBS 12.1.1 and 12.2.2 the definition is identical and the view is documented as VALID in both releases.

Underlying Base Objects

The view is defined over two documented base objects, each accessed through a synonym in the APPS schema:

  • FND_MENU_ENTRIES — the non-translatable table holding the structural definition of each menu entry (menu, sequence, target function or submenu, and the grant flag).
  • FND_MENU_ENTRIES_TL — the translatable table holding PROMPT and DESCRIPTION per language.

The join is performed on MENU_ID and ENTRY_SEQUENCE, with the translatable side filtered by T.LANGUAGE = USERENV('LANG'). This is why the view returns a single, language-appropriate row per menu entry. The view text aliases FND_MENU_ENTRIES as B and FND_MENU_ENTRIES_TL as T, and derives ROW_ID from B.ROWID.

Key Columns

  • ROW_ID — the row identifier derived from the base table ROWID.
  • MENU_ID — identifies the menu to which the entry belongs.
  • ENTRY_SEQUENCE — the position of the entry within the menu; combined with MENU_ID it is the key linking to the translatable table.
  • SUB_MENU_ID — populated when the entry points to a submenu rather than a function.
  • FUNCTION_ID — populated when the entry points to a function.
  • GRANT_FLAG — indicates whether the entry is granted (Y) or excluded (N) when the menu is inherited or referenced; it governs inclusion of the entry in the effective menu hierarchy.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard audit columns inherited from the base table.
  • PROMPT, DESCRIPTION — the language-specific display text sourced from FND_MENU_ENTRIES_TL.

Common Use Cases and Queries

Typical scenarios include auditing menu structure, tracing which functions a responsibility can reach, and reporting grants for security or SOX reviews. A basic listing of a menu's entries follows:

  • SELECT menu_id, entry_sequence, function_id, sub_menu_id, grant_flag, prompt FROM fnd_menu_entries_vl WHERE menu_id = :menu_id ORDER BY entry_sequence;
  • SELECT menu_id, entry_sequence, function_id, prompt FROM fnd_menu_entries_vl WHERE grant_flag = 'Y' ORDER BY menu_id, entry_sequence;

Because PROMPT and DESCRIPTION are already language-resolved, the view is well suited to end-user reports and to integrations that must present menu labels without performing their own translation join. When the exact localized text is not required, querying FND_MENU_ENTRIES directly is marginally cheaper, but FND_MENU_ENTRIES_VL remains the recommended, self-contained source for menu entry metadata in both 12.1.1 and 12.2.2.