Search Results ax_sle_lines




Overview
Explore in AI Chat

Overview

The AX_SLE_LINES table is a core data structure within the Global Accounting Engine (AX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the detailed repository for individual journal entry lines, forming the granular accounting transactions that are ultimately transferred to the General Ledger (GL). Each record in this table represents a single debit or credit line item, capturing the accounting flexfield combination, monetary amount, and associated descriptive information. Its existence is fundamental to the AX module's role as a high-volume, centralized accounting hub that standardizes and consolidates financial data from diverse subledgers before posting to GL.

Key Information Stored

The table's primary key, comprised of JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, and SLE_LINE_NUM, ensures the uniqueness of each line within the accounting stream. Critical columns include CODE_COMBINATION_ID, which stores the foreign key to the accounting flexfield structure (GL_CODE_COMBINATIONS) defining the natural account, cost center, and other segments. The table holds the monetary value of the line, typically in columns for entered and accounted amounts, along with the currency code. Descriptive attributes such as the line description and reference information are also stored. The SLE_HEADER_ID column provides the critical link to the parent header record in the AX_SLE_HEADERS table, which contains summary-level information like the journal batch, date, and status.

Common Use Cases and Queries

This table is central to troubleshooting, reconciliation, and custom reporting for accounting entries generated by the Global Accounting Engine. Common operational queries involve tracing the detailed composition of a specific journal entry or analyzing postings to a particular account.

  • Retrieving all lines for a specific journal header: SELECT * FROM ax.ax_sle_lines WHERE sle_header_id = <header_id> ORDER BY sle_line_num;
  • Analyzing account activity before GL transfer: SELECT gcc.segment1, gcc.segment2, axl.accounted_dr, axl.accounted_cr FROM ax.ax_sle_lines axl JOIN gl_code_combinations gcc ON axl.code_combination_id = gcc.code_combination_id WHERE gcc.segment1 = '<account>';
  • Reconciliation between AX and source subledgers: Queries often join AX_SLE_LINES with AX_SLE_HEADERS and source transaction tables using reference columns to validate the accuracy and completeness of accounted amounts.

Related Objects

AX_SLE_LINES has defined dependencies within the AX schema. Its primary relationship is with the AX_SLE_HEADERS table, enforced by a foreign key on JOURNAL_SEQUENCE_ID and SLE_HEADER_ID. This link is essential for retrieving the journal's context. Another crucial foreign key references GL_CODE_COMBINATIONS, tying each accounting line to the official chart of accounts. The table is also integral to the AX posting process, interacting with key APIs and concurrent programs that validate, summarize, and transfer these line items to the General Ledger interface tables (e.g., GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES).