Search Results xla_acct_line_types_b




Overview
Explore in AI Chat

Overview

XLA_ACCT_LINE_TYPES_B is a Subledger Accounting (XLA) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the line accounting types defined for an event class within a given application, entity, and Accounting Methods Builder (AMB) context. Each row defines a distinct accounting line that Subledger Accounting may generate when it processes transactions for a specific event class, forming part of the accounting method configuration that bridges subledger transactions to General Ledger entries.

In Data Vault modeling terms, the metadata classifies this object as standalone, and its structure reflects a reference or satellite-style entity rather than a transactional hub: it holds relatively static configuration (descriptive and behavioral attributes) keyed by a composite business identifier. The row is qualified by a foreign key to GL_ENCUMBRANCE_TYPES via ENCUMBRANCE_TYPE_ID, linking line accounting types to encumbrance semantics used in budgetary accounting.

Key Information Stored

The primary key, XLA_ACCT_LINE_TYPES_B_PK, is a composite surrogate spanning APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, AMB_CONTEXT_CODE, ACCOUNTING_LINE_TYPE_CODE, and ACCOUNTING_LINE_CODE. The unique index XLA_ACCT_LINE_TYPES_B_U1 extends this with ZD_EDITION_NAME, reflecting the editioning/partitioning model introduced in 12.2.x. The 26 documented columns include the following most significant attributes:

  • APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE – identify the owning application, subledger entity, and event class for which the line type is defined.
  • AMB_CONTEXT_CODE – the Accounting Methods Builder context; supports multiple accounting method configurations per entity.
  • ACCOUNTING_LINE_TYPE_CODE and ACCOUNTING_LINE_CODE – the business keys naming the accounting line type and the specific line generated.
  • ACCOUNTING_CLASS_CODE and ACCOUNTING_ENTRY_TYPE_CODE – drive how the resulting journal entry is classified (e.g., invoice, payment, accrual).
  • NATURAL_SIDE_CODE and SWITCH_SIDE_FLAG – determine the debit/credit orientation and whether the natural side is reversed.
  • GL_TRANSFER_MODE_CODE – controls summary versus detail transfer to General Ledger.
  • ROUNDING_CLASS_CODE, MERGE_DUPLICATE_CODE, MPA_OPTION_CODE – govern rounding, duplicate-line merging, and multi-period accounting behavior.
  • BUSINESS_METHOD_CODE and BUSINESS_CLASS_CODE – link the line type to the accounting program logic that creates the line.
  • TRANSACTION_COA_ID – identifies the transaction chart of accounts used for account derivation.
  • ENCUMBRANCE_TYPE_ID – foreign key to GL_ENCUMBRANCE_TYPES for encumbrance-enabled lines.
  • GAIN_OR_LOSS_FLAG and ENABLED_FLAG – control gain/loss treatment and whether the line type is active.

Common Use Cases and Queries

Typical usage includes diagnosing why a subledger transaction produced, or failed to produce, a specific accounting line during Create Accounting; auditing the configured accounting method for a given event class; and producing configuration reports across entities and AMB contexts. A representative query joins the table to GL_ENCUMBRANCE_TYPES and filters by application, entity, and event class:

SELECT h.ACCOUNTING_LINE_TYPE_CODE, h.ACCOUNTING_LINE_CODE,
       h.ACCOUNTING_CLASS_CODE, h.NATURAL_SIDE_CODE,
       h.GL_TRANSFER_MODE_CODE, h.ENABLED_FLAG,
       e.ENCUMBRANCE_TYPE_ID
FROM   XLA_ACCT_LINE_TYPES_B h,
       GL_ENCUMBRANCE_TYPES e
WHERE  h.ENCUMBRANCE_TYPE_ID = e.ENCUMBRANCE_TYPE_ID(+)
AND    h.APPLICATION_ID = :app_id
AND    h.ENTITY_CODE = :entity
AND    h.EVENT_CLASS_CODE = :event_class;

Reporting scenarios include verifying ENABLED_FLAG coverage, identifying lines where SWITCH_SIDE_FLAG or NATURAL_SIDE_CODE deviates from expected debit/credit rules, and validating GL_TRANSFER_MODE_CODE consistency across AMB contexts.

Related Objects

  • GL_ENCUMBRANCE_TYPES – joined via ENCUMBRANCE_TYPE_ID to resolve encumbrance semantics for encumbrance-enabled line types.
  • XLA_EVENT_CLASSES / XLA_ENTITIES – supply the EVENT_CLASS_CODE and ENTITY_CODE that qualify each line type.
  • XLA_AMB_CONTEXTS – provides the AMB_CONTEXT_CODE defining the accounting method context.
  • XLA_ACCT_LINE_TYPES_TL – the translation table for customer-facing line type names.
  • XLA_ACCT_LINE_TYPES_S / XLA_ACCT_LINE_TYPES_A – editioning and audit counterparts of the base table in 12.2.x.
  • XLA_AE_LINES – the actual journal line table populated using configuration from this table at accounting time.

Together these objects define and drive how subledger activity is translated into balanced accounting entries transferred to General Ledger.