Results for “xla_sources_fvl”

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

Overview

The XLA_SOURCES_FVL view is a Subledger Accounting (XLA) dictionary object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a descriptive, language-aware ("_FVL" designating a Flexfield Value / translated list) view that exposes the metadata definitions of accounting sources available to the Subledger Accounting engine. Each row represents a single accounting source — such as a distribution amount, a currency code, or a balancing segment value — that Subledger Accounting can use when generating journal entries from subledger transactions.

The view consolidates the base source definitions with their translated names and descriptions, the owning application, the associated value set, the owning lookup type, and, critically for the user's search context, the associated key flexfield. The presence of ID_FLEX_NAME (sourced from FND_ID_FLEXS) allows report authors and integrators to resolve the internal ID_FLEX_CODE into the human-readable flexfield name without an additional join. This makes the view a convenient single-stop reference for enumerating, filtering, and displaying accounting source metadata.

Underlying Base Objects

The view is defined over the following documented base objects:

• XLA_SOURCES_B — the base table storing source definitions (application, source type, source code, datatype, value set, flags, flexfield attributes).
• XLA_SOURCES_TL — the translatable table supplying NAME and DESCRIPTION in the session language.
• FND_APPLICATION_TL — joined up to three times to resolve application names: the owning application, the view application, and the flexfield application.
• FND_FLEX_VALUE_SETS — resolves FLEX_VALUE_SET_ID to FLEX_VALUE_SET_NAME.
• FND_ID_FLEXS — resolves ID_FLEX_CODE to ID_FLEX_NAME.
• FND_LOOKUP_TYPES_TL — resolves the source's lookup type to a meaning.
• FND_SEGMENT_ATTRIBUTE_TYPES — supplies the segment prompt as SEGMENT_NAME.
• XLA_LOOKUPS — referenced within the view's lookup join chain.

All joins on translated tables are filtered by USERENV('LANG'), and value-set, view-application, and lookup joins are outer (+) joins, so sources lacking those attributes are still returned.

Key Columns

• APPLICATION_ID, APPLICATION_NAME — the product owning the source.
• SOURCE_TYPE_CODE, SOURCE_CODE — the unique identifier of the source within its application.
• NAME, DESCRIPTION — translated display text for the source.
• DATATYPE_CODE, PLSQL_FUNCTION_NAME — data type and the function used to derive the source value.
• FLEX_VALUE_SET_ID, FLEX_VALUE_SET_NAME — the value set constraining valid source values.
• ID_FLEX_CODE, ID_FLEX_NAME — the key flexfield code and its descriptive name; central to the user's search.
• FLEXFIELD_APPLICATION_ID, FLEXFIELD_APPLICATION_NAME — the application owning the flexfield.
• KEY_FLEXFIELD_FLAG, SEGMENT_CODE, SEGMENT_NAME — indicate the source maps to a key flexfield segment and its prompt.
• ENABLED_FLAG, VISIBLE_FLAG, SUM_FLAG, TRANSLATED_FLAG — control flags governing availability, display, summing, and translation behaviour.
• VIEW_APPLICATION_ID, VIEW_APPLICATION_NAME, LOOKUP_TYPE, LOOKUP_TYPE_MEANING — optional view and lookup metadata.
• Audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to document or audit which sources are available to Subledger Accounting, and to resolve ID_FLEX_CODE to a flexfield name for reporting.

• Listing all enabled sources for a given application.
• Identifying sources bound to a specific key flexfield.
• Verifying value-set and datatype configuration before customization.

Sample SQL:

• SELECT application_name, source_code, name, datatype_code FROM xla_sources_fvl WHERE enabled_flag = 'Y' ORDER BY application_name, name;
• SELECT source_code, name, id_flex_code, id_flex_name, flexfield_application_name FROM xla_sources_fvl WHERE id_flex_name IS NOT NULL;
• SELECT source_code, name, flex_value_set_name, segment_name FROM xla_sources_fvl WHERE application_name = 'Payables';