Search Results fnd_application_all_view




Overview
Explore in AI Chat

Overview

FND_APPLICATION_ALL_VIEW is a reporting view owned by the APPS schema in the FND – Application Object Library product. It is a UNION ALL that combines every registered row from the FND_APPLICATION table with one additional synthetic row whose APPLICATION_ID is -2 and whose short name is the lookup code "ALL". That extra row represents a wildcard meaning "All Applications," allowing reports, concurrent program parameters, and value sets to offer a single selectable entry that implies the whole set of installed applications rather than one specific application.

The view is essentially a convenience layer for LOVs (lists of values) and reporting queries. Because it exposes a stable, low-cost result set with the same columns as FND_APPLICATION, developers can point a parameter LOV or a custom report directly at FND_APPLICATION_ALL_VIEW and automatically inherit application descriptions, basepaths, and the "All" option without writing UNION logic themselves. Its ORDER_BY column guarantees that the "All" entry sorts first, making the LOV behave predictably.

Underlying Base Objects

According to the documented definition, the view is built from the following APPS synonyms and objects:

  • FND_APPLICATION (SYNONYM) — the base table of registered Oracle EBS applications, supplying APPLICATION_ID, APPLICATION_SHORT_NAME, and BASEPATH.
  • FND_APPLICATION_TL (SYNONYM) — the translated table holding APPLICATION_NAME and DESCRIPTION, joined on APPLICATION_ID and filtered by LANGUAGE = USERENV('LANG').
  • FND_LOOKUPS (VIEW) — provides the synthetic "All" row through lookup type FND_APPLICATION_ALL_VIEW, contributing the lookup code as APPLICATION_SHORT_NAME plus MEANING and DESCRIPTION.
  • FND_GLOBAL (PACKAGE) — indirectly referenced via USERENV('LANG'), which resolves the session language so the translated name and description match the runtime locale.

The first branch of the UNION ALL joins FND_APPLICATION to FND_APPLICATION_TL, effectively reproducing the active-application listing. The second branch selects the wildcard row with a fixed ORDER_BY of 1. Because the join uses synonyms rather than fully qualified names, it inherits whatever grants and synonyms exist in the APPS schema at runtime.

Key Columns

  • APPLICATION_ID — numeric primary identifier for an application; -2 for the "All" row.
  • APPLICATION_SHORT_NAME — the short name (for example, FND, GL, AP) used widely in concurrent programs, profile options, and FND_GLOBAL calls; for the synthetic row it is the lookup code "ALL".
  • BASEPATH — the operating-system directory path to the application's installation; NULL for the "All" row.
  • APPLICATION_NAME — the translated display name from FND_APPLICATION_TL, resolved to the session language.
  • DESCRIPTION — the translated descriptive text for the application; NULL for the "All" row.
  • ORDER_BY — a sorting key where 1 places the "All" row first and 2 places every real application after it.

Common Use Cases and Queries

The view most frequently backs parameter LOVs and reports that must let a user choose either one application or all applications, such as audit or cross-application queries.

  • Populating a parameter LOV that includes an "All" option: SELECT application_short_name, application_name FROM fnd_application_all_view ORDER BY order_by, application_name;
  • Filtering a report while honouring a possible -2 selection: SELECT * FROM fnd_application_all_view WHERE application_id = NVL(:p_app_id, application_id);
  • Resolving a short name to an ID (or detecting the "All" case): SELECT application_id FROM fnd_application_all_view WHERE application_short_name = :p_short_name;
  • Validating application references in concurrent programs prior to submission.

Because the trailing row is synthesized from FND_LOOKUPS, adding or altering it is done through the lookup type FND_APPLICATION_ALL_VIEW rather than through application registration, and developers should treat the -2 identifier as a reserved sentinel when writing conditional logic.