Results for “xla_applications_xvl”

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

Overview

XLA_APPLICATIONS_XVL is a translated (VL-suffixed) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the XLA (Subledger Accounting) product and presents application registration information for those applications that participate in the Subledger Accounting architecture. In Oracle EBS, Subledger Accounting acts as a centralized accounting engine that transforms subledger transactions into journal entries before they reach General Ledger. To perform this role, XLA must maintain knowledge of which applications are configured as subledgers, and this view provides the translated, user-facing metadata for those applications alongside their XLA subledger classification.

The view is documented with a status of VALID and returns translated information related to the application set associated with XLA. It is a logical read-only object that unifies generic application definitions with XLA-specific subledger configuration, allowing reports, concurrent programs, and integrations to present application names and descriptions in the session’s language while identifying how each application is treated within the subledger accounting model.

Underlying Base Objects

The view is defined over two documented base objects:

• FND_APPLICATION_VL (VIEW) — the translated applications view in the FND (Application Object Library) schema. It supplies APPLICATION_ID, APPLICATION_SHORT_NAME, APPLICATION_NAME, and DESCRIPTION in the current language. It is aliased as F in the view definition.
• XLA_SUBLEDGERS (SYNONYM) — the XLA subledger registration object, aliased as X. It supplies APPLICATION_ID and APPLICATION_TYPE_CODE for each application recognized as a subledger.

The view text is a UNION of two branches. The first branch joins FND_APPLICATION_VL to XLA_SUBLEDGERS on APPLICATION_ID, returning the XLA application type code for every registered subledger. The second branch selects from FND_APPLICATION_VL alone, hard-coding a literal 'X' as the application type code and restricting to APPLICATION_ID = 602, the identifier conventionally reserved for Oracle General Ledger. This union guarantees that both configured subledgers and the General Ledger application appear in a single consolidated result set.

Key Columns

• APPLICATION_ID — the numeric primary identifier of the application, sourced from FND_APPLICATION_VL and correlated with XLA_SUBLEDGERS.
• APPLICATION_TYPE_CODE — the XLA subledger type classification for the application. For General Ledger (602) this is the literal 'X'.
• APPLICATION_SHORT_NAME — the short name used as the application identifier in configuration and APIs.
• APPLICATION_NAME — the translated display name of the application.
• DESCRIPTION — the translated description text for the application.

Common Use Cases and Queries

This view is typically used to drive subledger selection lists, diagnostic reports, and integration code that must enumerate applications active in Subledger Accounting. A typical query lists all XLA-enabled subledgers with their translated names:

• SELECT application_id, application_type_code, application_short_name, application_name FROM apps.xla_applications_xvl ORDER BY application_name;
• SELECT application_name, application_type_code FROM apps.xla_applications_xvl WHERE application_short_name = 'SQLGL'; — isolates the General Ledger entry with its 'X' type code.
• SELECT x.application_name, s.application_type_code FROM apps.xla_applications_xvl x WHERE x.application_id = :p_app_id; — parameterized lookups for a specific application.

Because the view returns translated columns, querying it under the correct language session setting yields localized application names, making it preferable to joining the base FND tables directly in multilingual environments. Its UNION structure ensures that General Ledger is always represented, which is essential when XLA processing requires an application context for GL-bound journal entries.