Results for “fnd_application_unkown_view”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.FND_APPLICATION_UNKNOWN_VIEW is a reporting view in the Oracle E-Business Suite Applications Technology layer. It exposes a unified list of Oracle EBS applications, combining registered applications from the application registry with a special fallback lookup value used when an application cannot be resolved to a defined registered application. The view is primarily consumed by forms, concurrent programs, and integration interfaces that require a selection list of applications and must also accommodate an "unknown" or "unresolved" choice.
In Oracle EBS 12.1.1 and 12.2.2 the object is owned by the APPS schema and is defined with a UNION ALL of two branches. The first branch returns all registered applications; the second branch returns a single synthetic row with an application identifier of -1, drawn from the FND_LOOKUPS lookup type FND_APPLICATION_UNKOWN_VIEW. This composite design is what distinguishes the view from the simpler FND_APPLICATION table: it guarantees that the "unknown" option always appears, even for lookups that do not correspond to a formally registered application.
Underlying Base Objects
The documented metadata identifies four referenced base objects:
- FND_APPLICATION (referenced as a synonym) — the application registry storing APPLICATION_ID, APPLICATION_SHORT_NAME, and BASEPATH.
- FND_APPLICATION_TL (referenced as a synonym) — the translated application registry storing APPLICATION_NAME and DESCRIPTION per language.
- FND_GLOBAL (package) — supplies USERENV('LANG'), the session language used to join the translated table, so results are returned in the user's current language.
- FND_LOOKUPS (view) — the lookup definitions source; the second UNION ALL branch pulls rows where LOOKUP_TYPE = 'FND_APPLICATION_UNKOWN_VIEW'.
The view therefore joins FND_APPLICATION to FND_APPLICATION_TL on APPLICATION_ID and language, and unions that result set with the lookup-based synthetic row.
Key Columns
- APPLICATION_ID — the numeric application identifier; -1 for the synthetic "unknown" row.
- APPLICATION_SHORT_NAME — the application short name for registered applications; for the synthetic row it carries LOOKUP_CODE.
- BASEPATH — the application's base path; NULL for the synthetic row.
- APPLICATION_NAME — the translated application name; for the synthetic row it carries the lookup MEANING.
- DESCRIPTION — the translated application description, or the lookup DESCRIPTION for the synthetic row.
- ORDER_BY — a sort key: 1 for the lookup-derived row and 2 for registered applications, ensuring the "unknown" entry sorts ahead of normal applications.
Common Use Cases and Queries
The view is typically used to populate application selection lists in concurrent program parameters, custom forms, and integration payloads where an "unresolved application" placeholder is required. A representative query retrieves the full application list in display order:
SELECT application_id, application_short_name, application_name FROM apps.fnd_application_unknown_view ORDER BY order_by, application_name;
To isolate only genuine registered applications, filtering on application_id > 0 removes the synthetic lookup row. Conversely, querying application_id = -1 returns the "unknown" entry supplied by the FND_APPLICATION_UNKOWN_VIEW lookup type. Because the translated branch depends on USERENV('LANG'), callers should verify that the session language is initialized through FND_GLOBAL; otherwise the join to FND_APPLICATION_TL may return no rows for applications lacking translations in that language.
In both 12.1.1 and 12.2.2 the view definition and its documented base objects are consistent, making it a stable reference for application enumeration logic across releases.
-
Union of all rows in the table FND_APPLICATION and the row "Unknown" indicating unknown application
APPS.FND_APPLICATION_UNKNOWN_VIEW·↳ FND_APPLICATION·↳ FND_APPLICATION_TL·↳ FND_GLOBAL·Explore FND module →
-
Union of all rows in the table FND_APPLICATION and the row "Unknown" indicating unknown application
APPS.FND_APPLICATION_UNKNOWN_VIEW·↳ FND_APPLICATION·↳ FND_APPLICATION_TL·↳ FND_GLOBAL·Explore FND module →