Search Results gl_je_lines

Overview

The GL_JE_LINES table is a core transactional data store within the Oracle E-Business Suite General Ledger (GL) module. It holds the individual debit and credit line items that constitute a complete journal entry. Each record in this table represents a single accounting transaction line posted to a specific ledger and natural account. The table's primary function is to store the detailed accounting entries that form the foundation of an organization's financial records. Its integrity is maintained through a primary key and critical foreign key relationships to parent header and setup tables, ensuring data consistency across the GL application.

Key Information Stored

The table's structure is defined by its primary key, composed of JE_HEADER_ID and JE_LINE_NUM, which uniquely identifies every journal line. Essential columns include LEDGER_ID, which links the line to its specific ledger, and CODE_COMBINATION_ID, which references the accounting flexfield (natural account, cost center, etc.) for the line. Other vital columns store the monetary amounts (ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR), the accounting date (EFFECTIVE_DATE), and a description (DESCRIPTION). The table also contains STATUS and POSTED_DATE columns to track the journal's progression through its lifecycle from incomplete to posted status.

Common Use Cases and Queries

This table is central to financial reporting and reconciliation. Common operational use cases include tracing transaction details from subledgers, analyzing account activity, and troubleshooting posting errors. A fundamental query retrieves all lines for a specific journal batch or header. For account analysis, a typical pattern joins GL_JE_LINES to GL_JE_HEADERS and GL_CODE_COMBINATIONS to retrieve posted entries for a given date range and account segment. Auditors frequently query this table to verify the completeness and accuracy of journal entries. The table is also the primary source for custom financial reports that require granular transaction-level data not available in standard summary reports.

Related Objects

GL_JE_LINES maintains integral relationships with several key EBS objects. Its primary parent is the GL_JE_HEADERS table, linked via JE_HEADER_ID, which stores the journal's control information. It references GL_LEDGERS via LEDGER_ID and GL_CODE_COMBINATIONS via CODE_COMBINATION_ID for setup validation. Crucially, as indicated by the extensive foreign key metadata, this table is referenced by numerous Fixed Assets (FA) subledger tables, including FA_ADJUSTMENTS, FA_DEPRN_DETAIL, and their multicurrency equivalents (FA_MC_*). These relationships create the audit trail between asset transactions and their corresponding general ledger entries, demonstrating the table's critical role in the subledger accounting integration.