Search Results xla_acctg_methods_tl




Overview
Explore in AI Chat

Overview

XLA_ACCTG_METHODS_TL is a translation (TL) table in the XLA schema, owned by the Subledger Accounting (XLA) product within Oracle E-Business Suite. It stores the language-dependent descriptive attributes of Subledger Accounting Methods — the named, user-visible identity of each accounting method defined in the application. Subledger Accounting Methods determine how subledger transactions are converted into accounting entries, including which journal line types, account derivation rules, and mapping sets are applied. The base definition of an accounting method resides in XLA_ACCTG_METHODS_B, while this _TL table holds the translatable name and description rows keyed by language.

The ETRM metadata classifies this object heuristically as standalone from a Data Vault modeling perspective; no foreign key relationships to a parent hub were detected in the documented structure. This suggests that, if modeled dimensionally, XLA_ACCTG_METHODS_TL would most plausibly function as a satellite-like descriptive store attached to the accounting method hub, rather than as a link connecting multiple business entities.

Key Information Stored

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

  • ACCOUNTING_METHOD_TYPE_CODE — identifies the classification of the accounting method (for example, primary or secondary ledger method); participates in both the primary key and the unique business keys.
  • ACCOUNTING_METHOD_CODE — the internal code identifying the accounting method; the principal business identifier and part of the primary key.
  • LANGUAGE — the NLS language code for the translated row; part of the primary key.
  • NAME — the translated display name of the accounting method. This column is a business-key candidate: unique index XLA_ACCTG_METHODS_TL_U2 enforces uniqueness on (ACCOUNTING_METHOD_TYPE_CODE, NAME, LANGUAGE, ZD_EDITION_NAME).
  • DESCRIPTION — the translated textual description of the accounting method.
  • SOURCE_LANG — the language from which the translation originated, used for language derivation and fallback.
  • ZD_EDITION_NAME — the editioned-data column supporting Oracle's Online Patching (adopted in EBS 12.2.2); it is included in both unique indexes.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording who created and last modified the row and when.

The surrogate primary key, XLA_ACCTG_METHODS_TL_PK, is defined on (ACCOUNTING_METHOD_TYPE_CODE, ACCOUNTING_METHOD_CODE, LANGUAGE). The documented unique indexes XLA_ACCTG_METHODS_TL_U1 (ACCOUNTING_METHOD_TYPE_CODE, ACCOUNTING_METHOD_CODE, LANGUAGE, ZD_EDITION_NAME) and XLA_ACCTG_METHODS_TL_U2 (ACCOUNTING_METHOD_TYPE_CODE, NAME, LANGUAGE, ZD_EDITION_NAME) serve as business-key candidates, ensuring that a method cannot be duplicated or ambiguously named within a language and edition.

Common Use Cases and Queries

Typical uses include LOV and list-of-values lookups when assigning an accounting method to a ledger, subledger application, or application accounting definition, and reporting that must present method names in the user's language. Because the table is language-dependent, queries should filter on LANGUAGE or join to FND_LANGUAGES to resolve the correct translation.

A simple retrieval of a method by code:

  • SELECT accounting_method_code, name, description FROM xla_acctg_methods_tl WHERE accounting_method_type_code = :type AND language = USERENV('LANG');
  • Join to the base table to obtain language-independent attributes, filtering on the method code and language to return a single descriptive row.
  • Report all methods available per language by grouping on ACCOUNTING_METHOD_TYPE_CODE and LANGUAGE.

Reporting use cases include documenting the set of accounting methods configured in an instance, auditing translation coverage across installed languages, and exposing method names in custom concurrent programs that generate accounting diagnostics.

Related Objects

  • XLA_ACCTG_METHODS_B — the base (language-independent) table holding the same method keys; joined on ACCOUNTING_METHOD_TYPE_CODE and ACCOUNTING_METHOD_CODE.
  • XLA_ACCTG_METHODS_TL primary key references and business keys used by dependent XLA setup tables that reference accounting method codes.
  • FND_LANGUAGES — joined on LANGUAGE to resolve language names and installed-language checks.
  • XLA_LEDGERS / ledger setup views — accounting methods are associated with ledgers and subledger applications, so method codes surface through ledger configuration queries.
  • XLA_APPLICATION_ACCOUNTING_DEFINITIONS — application accounting definitions are scoped to an accounting method, linking definitions to method codes.
  • FND_APPLICATION and related XLA setup views — used in reporting that resolves method ownership by application.

Because no foreign keys were documented, integration is primarily through shared business keys (ACCOUNTING_METHOD_TYPE_CODE, ACCOUNTING_METHOD_CODE) rather than enforced referential constraints.