Search Results xla_ae_line_acs




Overview
Explore in AI Chat

Overview

XLA_AE_LINE_ACS is a Subledger Accounting (XLA) table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores the relationship between subledger journal entry lines and their associated analytical detail values. In the context of subledger accounting, an "analytical criterion" represents a user-defined dimension, qualifier, or attribute used to further classify journal entry lines — for example, a product line, project, or cost center designation that is not part of the natural account itself. This table captures that classification by mapping each accounted journal entry line to one or more analytical detail values through numbered analytical criterion columns.

The table resides in the XLA schema and is owned by the Subledger Accounting product. From a modeling perspective, the metadata classifies this object heuristically as standalone, meaning it does not exhibit the strong foreign-key fan-in or fan-out typically associated with hub or link constructs; it is best treated as a satellite or detail table whose rows are meaningful only in the context of a parent journal entry line.

Key Information Stored

The physical schema documents eleven columns. The most important are:

  • AE_HEADER_ID — identifies the subledger journal entry header to which the line belongs; a component of both the primary key and the unique index.
  • AE_LINE_NUM — the line number within the journal entry header; combined with AE_HEADER_ID, it locates the exact accounted line being classified.
  • ANALYTICAL_CRITERION_CODE — the identifier of the analytical criterion being applied to the line.
  • ANALYTICAL_CRITERION_TYPE_CODE — the type categorization of the analytical criterion (for example, a source or value type distinguishing how the criterion is evaluated).
  • AMB_CONTEXT_CODE — the application messaging/context code that scopes the analytical criterion to a specific subledger application or context.
  • OBJECT_VERSION_NUMBER — the optimistic locking version column used by the Oracle Applications Framework for concurrent update control.
  • AC1, AC2, AC3, AC4, AC5 — five generic analytical detail value columns holding the actual values assigned to the criterion for that journal line. These are the payload of the row.

The surrogate primary key is XLA_AE_LINE_ACS_PK, defined over (AE_HEADER_ID, AE_LINE_NUM, ANALYTICAL_CRITERION_CODE, ANALYTICAL_CRITERION_TYPE_CODE, AMB_CONTEXT_CODE). A unique index, XLA_AE_LINE_ACS_U1, is defined over exactly the same column list, confirming these five columns as the business-key candidate that guarantees one row per analytical criterion per journal line per context.

Common Use Cases and Queries

Typical reporting scenarios include extracting analytical detail for a posted journal entry, reconciling subledger balances by analytical dimension, and validating that all required criteria have been populated against accounted lines. A representative query joins the accounted line table to retrieve the criterion values:

  • SELECT l.ae_header_id, l.ae_line_num, a.analytical_criterion_code, a.ac1, a.ac2, a.ac3 FROM xla_ae_lines l, xla_ae_line_acs a WHERE l.ae_header_id = a.ae_header_id AND l.ae_line_num = a.ae_line_num; — joins lined rows to their analytical detail.
  • Filter by ANALYTICAL_CRITERION_CODE and AMB_CONTEXT_CODE to isolate a single analytical dimension across a journal batch.
  • Use AC1 through AC5 in GROUP BY clauses to aggregate accounted amounts along analytical dimensions for management reporting.

Because the classifier carries no static value, each row is meaningful only alongside the parent accounted line, making this an effective satellite for analytical classification.

Related Objects

  • XLA_AE_LINES — the parent accounted journal entry line table; joined on AE_HEADER_ID and AE_LINE_NUM.
  • XLA_AE_HEADERS — the journal entry header; joined on AE_HEADER_ID, providing batch and event context.
  • XLA_DISTRIBUTION_LINKS — ties accounted lines to their originating subledger distributions; joined on AE_HEADER_ID and AE_LINE_NUM.
  • XLA_EVENTS — represents the accounting event that produced the journal entry.
  • XLA_ANALYTICAL_CRITERIA — defines the analytical criteria referenced by ANALYTICAL_CRITERION_CODE.
  • XLA_AE_LINE_ACS appears in application modules such as Payables (AP) and Receivables (AR), so related lookups such as FND_LOOKUP_VALUES supply the context and criterion type descriptions used in reporting.