Search Results fnd_compiled_menu_functions_u1

Overview

APPLSYS.FND_COMPILED_MENU_FUNCTIONS is a compiled, runtime-oriented table in Oracle E-Business Suite that flattens the hierarchical structure of FND_MENU_ENTRIES into a single-level set of menu-to-function rows. Its purpose is to accelerate the resolution of which form functions are reachable from a given menu, avoiding recursive traversal of the menu hierarchy at runtime. The table is populated by the FND_FUNCTION package, which compiles menu entries on demand and records compilation state within the same table.

The table also carries compilation markers that distinguish it from its source. A row with FUNCTION_ID = -99999 signals that the associated menu is uncompiled and its contents cannot be trusted, in which case code must fall back to FND_MENU_ENTRIES directly. Because the compiled table does not account for exclusions applied at the responsibility level, any logic honoring exclusions must also consult FND_MENU_ENTRIES. From a modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is standalone; this is a suggestion only, reflecting the absence of hub/link/satellite parent relationships in the ETRM classification.

Key Information Stored

The documented schema exposes only three columns, all of which are material to interpretation:

• MENU_ID (NUMBER) — Foreign key to FND_MENUS; identifies the menu that contains the referenced function. This is the leading column of the unique index.
• FUNCTION_ID (NUMBER) — Foreign key to FND_FORM_FUNCTIONS; identifies the function reachable from that menu. The sentinel value -99999 indicates an uncompiled menu.
• GRANT_FLAG (VARCHAR2) — Encodes the nature of the relationship: 'Y' indicates permission is granted through function security; 'N' (the default) indicates only navigational ability; 'B' indicates the menu has no functions; 'U' indicates the menu requires recompilation.

The business-key candidate, per the documented unique index FND_COMPILED_MENU_FUNCTIONS_U1, is the composite (MENU_ID, FUNCTION_ID). There is no separate surrogate primary key exposed in the documented three-column schema; the unique composite effectively serves as the row identifier. Three additional non-unique indexes support access paths: N1 on FUNCTION_ID, N2 on (MENU_ID, GRANT_FLAG, FUNCTION_ID), and N3 on GRANT_FLAG. Storage resides in tablespace APPS_TS_SEED with PCTFREE 10.

Common Use Cases and Queries

Typical usage centers on security analysis, responsibility-to-function mapping, and compilation troubleshooting. Because the table is denormalized, it is well suited to set-based reporting.

• Listing all functions on a menu: SELECT FUNCTION_ID, GRANT_FLAG FROM FND_COMPILED_MENU_FUNCTIONS WHERE MENU_ID = :menu_id;
• Detecting uncompiled menus: SELECT DISTINCT MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS WHERE FUNCTION_ID = -99999;
• Identifying grant-bearing rows: SELECT MENU_ID, FUNCTION_ID FROM FND_COMPILED_MENU_FUNCTIONS WHERE GRANT_FLAG = 'Y';
• Finding which menus expose a given function: SELECT MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS WHERE FUNCTION_ID = :function_id;

Any direct manipulation of FND_MENU_ENTRIES must fire the database triggers that mark affected rows as uncompiled, ensuring the compiled table is invalidated correctly. When exclusions apply to a responsibility, report authors must reconcile against FND_MENU_ENTRIES rather than relying solely on this table.

Related Objects

• APPLSYS.FND_MENUS — joined on MENU_ID; the parent of the menu side of each row.
• APPLSYS.FND_FORM_FUNCTIONS — joined on FUNCTION_ID; describes each function.
• APPLSYS.FND_MENU_ENTRIES — the source hierarchy compiled into this table and the authoritative fallback for uncompiled or exclusion-affected menus.
• FND_FUNCTION — the PL/SQL package that populates and recompiles this table.
• APPLSYS.FND_RESPONSIBILITY — responsibility definitions that reference menus and drive function-security resolution.
• FND_COMPILED_MENU_FUNCTIONS_U1 / _N1 / _N2 / _N3 — supporting unique and non-unique indexes used for lookup performance.