Search Results xla_acctg_methods_tl_u2

Overview

XLA.XLA_ACCTG_METHODS_TL is the translation (TL) table that stores language-specific, user-facing text for Subledger Accounting accounting methods in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the XLA (Subledger Accounting) schema, which is the foundation of the SLA engine introduced in R12. An "accounting method" defines the set of accounting rules and journal line types used to generate subledger journal entries for a given accounting method type (for example, a specific application or event class grouping). Because method names and descriptions must be presented in multiple languages, this table holds the translatable columns — NAME and DESCRIPTION — keyed by LANGUAGE, while the non-translated attributes reside in the base table XLA_ACCTG_METHODS_B.

Per the ETRM metadata classification, this object is heuristic "standalone," meaning it does not participate in a foreign key reference chain of its own. In Data Vault terms, the table can be modeled as a satellite attached to the accounting method hub — the language-dependent descriptive attributes (name, description, source language) function as descriptive payload, while the combination of method type code, method code, and language forms the natural key that joins to the hub. This is a modeling suggestion only; the physically documented object is a standard EBS translation table.

Key Information Stored

The table contains 12 documented columns. The most significant are:

• ACCOUNTING_METHOD_TYPE_CODE — classifies the accounting method by type; part of every unique key.
• ACCOUNTING_METHOD_CODE — the internal identifier of the accounting method (up to 30 characters).
• LANGUAGE — the NLS language code for the translated row; part of every unique key.
• NAME — the user-visible accounting method name (up to 80 characters); a business-key candidate.
• DESCRIPTION — a longer descriptive text (up to 240 characters).
• SOURCE_LANG — the language in which the row was originally entered.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns tracking row creation and modification.
• ZD_EDITION_NAME — the edition/partition column present in the 12.2.2 documented schema, supporting the Editioning / Online Patching model introduced in EBS 12.2.

The primary key is XLA_ACCTG_METHODS_TL_PK on (ACCOUNTING_METHOD_TYPE_CODE, ACCOUNTING_METHOD_CODE, LANGUAGE). The unique index XLA_ACCTG_METHODS_TL_U1 mirrors the primary key business key, while XLA_ACCTG_METHODS_TL_U2 — the index that matches the user's search term — enforces uniqueness on (ACCOUNTING_METHOD_TYPE_CODE, NAME, LANGUAGE, ZD_EDITION_NAME), guaranteeing that method names are unique within a language and type.

Common Use Cases and Queries

The most frequent use is a join from the base table to the TL table to retrieve the localized method name for reporting, setup listings, or validation within Subledger Accounting configuration screens. A typical query is:

SELECT b.accounting_method_code, t.name, t.description
FROM   xla.xla_acctg_methods_b b,
       xla.xla_acctg_methods_tl t
WHERE  b.accounting_method_type_code = t.accounting_method_type_code
AND    b.accounting_method_code      = t.accounting_method_code
AND    t.language = USERENV('LANG');

Reporting use cases include generating a list of available accounting methods per type, auditing that NAME uniqueness holds per language (XLA_ACCTG_METHODS_TL_U2), and validating translation completeness by comparing rows in the base table against each LANGUAGE. Developers should never write to this table directly; it is maintained through standard Oracle Applications programs, consistent with the "Oracle Internal Use Only" warning in the ETRM documentation.

Related Objects

• XLA_ACCTG_METHODS_B — base table holding core (non-translated) method attributes; joined on ACCOUNTING_METHOD_TYPE_CODE and ACCOUNTING_METHOD_CODE.
• XLA_ACCTG_METHOD_RULES — rules associated with a given accounting method.
• XLA_ACCTG_METHODS_VL — the standard view unioning base and TL tables for a single-language read.
• XLA_EVENT_CLASSES_TL — related translation table for event classes used within accounting methods.
• XLA_APPLICATION_ACCTG_METHODS — associates accounting methods with applications.
• FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY WHO columns.
• FND_LANGUAGES — provides the valid values for LANGUAGE.