Search Results xla_source_params_u1

Overview

XLA.XLA_SOURCE_PARAMS is a transactional configuration table within the Subledger Accounting (XLA) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It defines the parameter bindings that the Accounting Program applies to each accounting source registered in the Subledger Accounting engine. Where XLA_SOURCES identifies the available sources of transaction data, XLA_SOURCE_PARAMS specifies how individual parameters attached to those sources are resolved — either as constants supplied by the definition or as references to other seeded sources. This table is central to the Subledger Accounting Methods and Application Accounting Definitions that drive journal entry generation.

A heuristic Data Vault classification for this object is satellite: it is modelled as standalone, with a single-column primary key (SOURCE_PARAM_ID) and no outgoing foreign keys to other hubs or links. The stored attributes describe the descriptive context of the parent source definition rather than independent business entities.

Key Information Stored

The table is keyed by SOURCE_PARAM_ID, a NUMBER(15) surrogate that uniquely identifies each parameter row and is enforced by the primary key XLA_SOURCE_PARAMS_PK. Two unique indexes act as business-key candidates. XLA_SOURCE_PARAMS_U1 enforces uniqueness on SOURCE_PARAM_ID together with ZD_EDITION_NAME. XLA_SOURCE_PARAMS_U2 enforces uniqueness on the composite (APPLICATION_ID, SOURCE_TYPE_CODE, SOURCE_CODE, USER_SEQUENCE, ZD_EDITION_NAME), which represents the meaningful business identifier for a source parameter.

The most significant columns are:

• APPLICATION_ID — internal identifier of the owning application that registered the source.
• SOURCE_TYPE_CODE — categorises the source type within the application.
• SOURCE_CODE — the source code to which the parameter belongs.
• USER_SEQUENCE — user-defined ordering of parameters for a given source.
• PARAMETER_TYPE_CODE — indicates whether the parameter resolves to a constant or to a referenced source.
• CONSTANT_VALUE — the literal value used when PARAMETER_TYPE_CODE indicates a constant.
• REF_SOURCE_APPLICATION_ID, REF_SOURCE_TYPE_CODE, REF_SOURCE_CODE — the reference target identifying a seeded source when the parameter type resolves by reference.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ZD_EDITION_NAME — participates in both unique keys, supporting edition-based redefinition in 12.2.x.

Common Use Cases and Queries

Functional and technical consultants query this table to audit how accounting sources derive their parameters, to diagnose journal entries that post with unexpected values, and to verify seeded versus custom Subledger Accounting configurations. A typical lookup for a specific source is:

• SELECT source_param_id, parameter_type_code, constant_value, user_sequence FROM xla.xla_source_params WHERE application_id = :app_id AND source_type_code = :type AND source_code = :code ORDER BY user_sequence;
• Reports identifying parameters that resolve through a referenced source use the REF_SOURCE_* columns as filter predicates.
• Migration or upgrade validation scripts compare the COMPOSITE business key (APPLICATION_ID, SOURCE_TYPE_CODE, SOURCE_CODE, USER_SEQUENCE) between environments.

Related Objects

The following objects are most significant in relation to XLA_SOURCE_PARAMS:

• XLA_SOURCES — the parent source definition, joined on APPLICATION_ID, SOURCE_TYPE_CODE, and SOURCE_CODE.
• XLA_SOURCE_PARAMS_PK / XLA_SOURCE_PARAMS_U1 / XLA_SOURCE_PARAMS_U2 — the primary and unique constraints that govern row identity.
• XLA_SOURCE_PARAMS_N1 — the non-unique index on REF_SOURCE_APPLICATION_ID, REF_SOURCE_TYPE_CODE, and REF_SOURCE_CODE, supporting reverse lookups of referencing parameters.
• FND_APPLICATION — resolves APPLICATION_ID to an application short name.
• FND_USER — referenced through CREATED_BY and LAST_UPDATED_BY for audit reporting.
• FND_LOGINS — referenced through LAST_UPDATE_LOGIN.
• XLA_ACCOUNTING_PROGRAM / XLA_ACCOUNTING_PKG — Oracle Application programs that consume these parameter definitions at runtime.