Results for “xla_sources_assignable_xvl”

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

Overview

XLA_SOURCES_ASSIGNABLE_XVL is a read-only view owned by the APPS schema within the Subledger Accounting (XLA) product of Oracle E-Business Suite, valid across release levels 12.1.1 and 12.2.2. It exposes the population of accounting sources that are eligible for assignment to a subledger application's accounting method, presenting them in a form that is directly consumable by Oracle Application Framework (OAF) pages, concurrent programs, and integration interfaces. The view resolves the internal foreign keys ordinarily required to interpret XLA_SOURCES_B into descriptive, multi-language text by joining translation tables and the applications name table. As a "_XVL" object it is a validation view intended for LOV and lookup consumption rather than for direct transactional update; no DML is permitted against it.

Underlying Base Objects

The documented view definition is a UNION of two branches over the same core tables:

• XLA_SOURCES_B — the base table holding source definitions, their datatypes, PL/SQL derivation functions, and control flags such as ENABLED_FLAG, VISIBLE_FLAG, SUM_FLAG, and TRANSLATED_FLAG.
• XLA_SOURCES_TL — the translation table supplying NAME and DESCRIPTION for the source in the session language.
• FND_APPLICATION_TL — the application translation table supplying the owning application name.
• XLA_REFERENCE_OBJECTS — referenced in the second UNION branch, which reconciles sources owned by a different (reference) application.

The join predicates enforce LANGUAGE = USERENV('LANG'), restrict to source type code 'S' (standard sources), and require ENABLED_FLAG = 'Y'. Consequently only enabled, assignable sources are surfaced.

Key Columns

• APPLICATION_ID / SOURCE_APPLICATION_ID — the application owning the accounting source; the second branch substitutes REFERENCE_OBJECT_APPL_ID for cross-application sources.
• SOURCE_APPLICATION_NAME — descriptive name resolved from FND_APPLICATION_TL.
• SOURCE_TYPE_CODE / SOURCE_CODE — the composite key identifying the source within the application.
• NAME / DESCRIPTION — translated display text from XLA_SOURCES_TL.
• ENABLED_FLAG — indicates the source is active; the view filters to 'Y'.
• VISIBLE_FLAG — controls whether the source is presented to users during accounting method setup. This column is the target of the common visible_flag search, as it governs the checkbox behavior on the Create Accounting Method and Source Assignment pages.
• SUM_FLAG, TRANSLATED_FLAG, KEY_FLEXFIELD_FLAG — behavioral indicators for summarization, currency translation, and key flexfield participation.
• DATATYPE_CODE — the data type governing validation of the source value.
• PLSQL_FUNCTION_NAME — derivation function invoked to populate the source.
• FLEX_VALUE_SET_ID, ID_FLEX_CODE, SEGMENT_CODE, FLEXFIELD_APPLICATION_ID — flexfield binding information.
• LOOKUP_TYPE, VIEW_APPLICATION_ID — lookup and view binding context.

Common Use Cases and Queries

The view is typically queried to enumerate assignable sources for a subledger application when configuring or diagnosing an accounting method, and to locate sources whose visibility or enablement flags have been altered. A representative query follows:

SELECT source_code
     , name
     , source_application_name
     , datatype_code
     , visible_flag
     , enabled_flag
  FROM apps.xla_sources_assignable_xvl
 WHERE source_application_id = 222
 ORDER BY name;

To audit visibility settings specifically:

SELECT source_code, name, visible_flag
  FROM apps.xla_sources_assignable_xvl
 WHERE visible_flag = 'Y'
   AND source_application_id = 222;

Because the view already restricts to enabled sources of type 'S' and resolves language-dependent columns, it is preferred over direct queries against XLA_SOURCES_B when building LOVs or reports, eliminating the need to reproduce the translation joins manually.