Search Results xla_sources_b




Overview
Explore in AI Chat

Overview

The XLA_SOURCES_B table is a core configuration table within the Subledger Accounting (XLA) product of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definitive catalog of subledger sources — the discrete data elements such as amounts, dates, and attributes — that Subledger Accounting uses when evaluating accounting rules, conditions, and journal line definitions. Every source available to a subledger application, whether delivered by Oracle or customized by the implementing organization, is registered here. Because sources drive both the Accounting Methods Builder and the journal entry generation engine, XLA_SOURCES_B is effectively the metadata backbone for rule-based accounting in EBS.

From a Data Vault modeling perspective, the heuristic derived from the foreign key structure classifies this object as satellite-leaning. It functions as a descriptive satellite attached to the parent application and lookups, rather than acting as an independent hub or a linking table.

Key Information Stored

The table is owned by the XLA schema and contains 24 documented columns. The most business-critical columns are:

The surrogate primary key is defined by XLA_SOURCES_B_PK on (APPLICATION_ID, SOURCE_TYPE_CODE, SOURCE_CODE). A unique index, XLA_SOURCES_B_U1, extends this business key with ZD_EDITION_NAME, reflecting the edition-based redefinition model used in 12.2.2.

Common Use Cases and Queries

Implementers query this table most often to inventory available sources, confirm visibility, or trace why a source is unavailable in the Accounting Methods Builder. A typical query lists enabled, visible sources for a given application:

  • SELECT source_code, datatype_code, plsql_function_name FROM xla_sources_b WHERE application_id = :app AND enabled_flag = 'Y' AND visible_flag = 'Y';
  • SELECT source_code, source_table_name, source_column_name FROM xla_sources_b WHERE application_id = :app ORDER BY source_code;
  • SELECT source_code FROM xla_sources_b WHERE flex_value_set_id IS NOT NULL AND key_flexfield_flag = 'Y';

These patterns support diagnostics before rule creation, audit of customized sources, and reconciliation of source definitions after upgrades or patching.

Related Objects

The table is joined and referenced by several significant XLA objects:

Together these relationships establish XLA_SOURCES_B as the entry point for source-driven accounting configuration across all subledgers.