Results for “fnd_application_unknown_view”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_APPLICATION_UNKNOWN_VIEW is a PUBLIC synonym owned by the APPS schema in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. The view belongs to the FND (Application Object Library) product and serves a specific reporting purpose: it presents a superset of the registered Oracle EBS applications by combining every row in the FND_APPLICATION registration table with a synthetic "Unknown" entry. That synthetic row is not physically stored in FND_APPLICATION; it is manufactured at runtime from a lookup so that reports, concurrent programs, and integration interfaces can attribute transactions, diagnostic data, or audit records to an unspecified or unidentified application rather than leaving the application identifier null.

Underlying Base Objects

The view text documented in ETRM is a UNION ALL over two sources:

• FND_APPLICATION (referenced through a synonym) joined to FND_APPLICATION_TL on APPLICATION_ID, with the translation restricted by the condition T.LANGUAGE = USERENV('LANG'). FND_GLOBAL is the package that implements USERENV semantics for the EBS session, returning the current language so that the application name and description appear in the user's session language. This branch carries ORDER_BY = 2.
• FND_LOOKUPS (documented as a view), filtered on LOOKUP_TYPE = 'FND_APPLICATION_UNKOWN_VIEW'. This branch supplies a single placeholder row with APPLICATION_ID = -1, ORDER_BY = 1, and a NULL BASEPATH. The lookup code populates APPLICATION_SHORT_NAME, and the lookup meaning and description populate APPLICATION_NAME and DESCRIPTION.

Because the second branch is a lookup rather than a table row, administrators can relabel or translate the "Unknown" entry without touching FND_APPLICATION, and the UNION ALL guarantees no duplication between registered applications and the placeholder.

Key Columns

• APPLICATION_ID — The application identifier. Registered applications carry their normal positive FND_APPLICATION ID; the "Unknown" row always returns -1, so it can never collide with a real application.
• APPLICATION_SHORT_NAME — The short name used throughout EBS profile options, FNDLOAD, and API parameters. The placeholder value derives from the lookup code.
• BASEPATH — The operating-system base directory of the application's product installation. This is NULL for the "Unknown" row because no filesystem location corresponds to it.
• APPLICATION_NAME — The translated display name, sourced from FND_APPLICATION_TL for live applications and from the lookup meaning for the placeholder.
• DESCRIPTION — The translated description of the application.
• ORDER_BY — An internal sort discriminator. The value 1 is assigned to the "Unknown" row and 2 to all real applications, so an ORDER BY ORDER_BY clause consistently positions the placeholder first, before the alphabetically unsorted application list.

Common Use Cases and Queries

The view is typically used as a lookup source where a value list of applications must always offer an "Unknown" choice — for example in diagnostic or discovery scripts, custom concurrent program parameters, or interfaces that record a source application. It is also useful for validating that the placeholder lookup row exists and is translated.

Listing applications with the placeholder first:

• SELECT application_id, application_short_name, application_name, order_by FROM fnd_application_unknown_view ORDER BY order_by, application_name;

Retrieving the sentinel row alone:

• SELECT application_id, application_short_name, application_name FROM fnd_application_unknown_view WHERE application_id = -1;

Resolving an application short name, defaulting unmatched values to the placeholder:

• SELECT NVL(v.application_name, 'Unknown') FROM fnd_application_unknown_view v WHERE v.application_short_name = :short_name;

Because it references FND_LOOKUPS through the translation-aware FND_GLOBAL language, results respect the caller's NLS language setting, making the view safe for multilingual reporting.