Search Results okl_ae_lines




Overview
Explore in AI Chat

Overview

The OKL_AE_LINES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the detailed transactional repository for accounting entry lines, which are the individual debit and credit components that comprise a complete accounting journal entry. Each record in this table represents a single accounting line item, linking a specific account, amount, and accounting flexfield combination to a parent accounting entry header. Its primary role is to store the granular financial data necessary for generating accurate and auditable general ledger entries for all leasing and financing transactions, such as revenue recognition, asset depreciation, and interest accruals.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure of such a table is defined by its relationships and purpose. The critical columns include the primary key, AE_LINE_ID, which uniquely identifies each line. The foreign key column, AE_HEADER_ID, links the line to its parent record in the OKL_AE_HEADERS table. Other essential columns typically found in this context would store the accounting flexfield (Code Combination ID), the entered and accounted monetary amounts (ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR), and a line description. The table also likely includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditability.

Common Use Cases and Queries

This table is central to financial reporting and reconciliation within the OKL module. A common use case is tracing the detailed accounting impact of a specific lease contract or financial transaction by joining through the header table. For troubleshooting or audit purposes, consultants often query this table to verify that accounting entries were created correctly. A typical query pattern involves joining to OKL_AE_HEADERS to retrieve header-level context, such as the source transaction.

SELECT ael.ae_line_id,
       ael.code_combination_id,
       ael.accounted_dr,
       ael.accounted_cr,
       aeh.je_category_name,
       aeh.period_name
FROM okl_ae_lines ael,
     okl_ae_headers aeh
WHERE ael.ae_header_id = aeh.ae_header_id
AND aeh.source_id = <transaction_id>;

Reporting use cases include generating detailed account analyses and validating the balance of debits and credits for a given accounting batch or period.

Related Objects

The table maintains a strict hierarchical relationship within the OKL accounting engine. As documented, its sole, critical foreign key relationship is:

  • OKL_AE_HEADERS: Every record in OKL_AE_LINES must reference a valid parent header. The join is performed on OKL_AE_LINES.AE_HEADER_ID = OKL_AE_HEADERS.AE_HEADER_ID. The header table provides the batch, period, and source transaction context for the individual line items.

Furthermore, as the repository for final accounting entries, this table is the ultimate target for data flowing from various OKL transaction processing programs and interfaces. It is a foundational object for custom financial reports and integrations with the General Ledger.