Search Results ax_sle_lines




Overview
Explore in AI Chat

Overview

AX_SLE_LINES is a table in the AX schema owned by the Global Accounting Engine (AX) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the individual journal entry lines that result from the subledger accounting process, representing the accounting distribution detail associated with each subledger journal entry. Within the AX architecture, AX_SLE_HEADERS captures the journal entry header information, while AX_SLE_LINES captures the corresponding line-level accounting distributions, identifying the accounting flexfield, entered and accounted amounts, currency conversion details, and the source transaction references that generated each line.

Under the heuristic Data Vault classification derived from the foreign key structure, AX_SLE_LINES is best modeled as a link table. It sits between AX_SLE_HEADERS and GL_CODE_COMBINATIONS, resolving the relationship between a journal entry and the accounting code combinations that its lines reference. This classification reflects its role as an associative entity carrying degenerate attributes (amounts, flags, references) alongside its foreign key relationships.

Key Information Stored

The physical schema documents 127 columns. The most significant columns include:

Common Use Cases and Queries

AX_SLE_LINES is commonly queried for subledger-to-GL reconciliation, journal line reporting, and audit of posting activity. A representative join returns header-to-line detail:

  • SELECT l.sle_header_id, l.sle_line_num, l.code_combination_id, l.accounted_dr, l.accounted_cr FROM ax.ax_sle_lines l WHERE l.sle_header_id = :header_id ORDER BY l.sle_line_num;

To confirm which lines remain unposted to GL, filter on the posting flag:

  • SELECT * FROM ax.ax_sle_lines WHERE gl_posted_flag = 'N';

Currency conversion and drill-back reporting use the currency columns and SOURCE_ID/SOURCE_TABLE to trace an accounting line to its subledger origin. Reconciliation extracts typically join AX_SLE_LINES to AX_SLE_HEADERS and GL_CODE_COMBINATIONS to produce a full journal line report by ledger, period, and accounting flexfield.

Related Objects

  • AX_SLE_HEADERS — parent of AX_SLE_LINES; joined on JOURNAL_SEQUENCE_ID and SLE_HEADER_ID.
  • GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID for accounting flexfield descriptions and validation.
  • GL_JE_LINES — received lines in General Ledger, correlated via GL_SL_LINK_ID and GL_TRANSFER_LINE_NUM.
  • GL_JE_HEADERS — GL journal header corresponding to the transferred AX journal entry.
  • GL_LEDGERS / FND_SET_OF_BOOKS — provide the ledger/Set of Books context via SET_OF_BOOKS_ID.
  • XLA_* tables — subledger accounting engine tables that feed the AX journal entries.

The relationships above are grounded in the documented primary key, the unique index AX_SLE_LINES_U1, and the foreign keys to AX_SLE_HEADERS and GL_CODE_COMBINATIONS.