Search Results gl_je_lines_n3

Overview

GL_JE_LINES is the core journal entry line table within the Oracle E-Business Suite General Ledger module (schema GL), documented as VALID at release 12.1.1 and 12.2.2. It stores the individual debit and credit lines that make up each journal entry created through the Enter Journals form or loaded programmatically via the Journal Import interface. There is a one-to-many relationship between journal entries and journal entry lines: each row in GL_JE_LINES records the parent journal header identifier, a line number, the accounting flexfield combination, and the entered and accounted debit or credit amounts. STATUS carries the value 'U' for unposted and 'P' for posted. The table resides in the APPS_TS_TX_DATA tablespace and is registered in FND Design Data as SQLGL.GL_JE_LINES. From a Data Vault modeling perspective, the mined relationship structure classifies this object as hub-leaning, because it holds strong identifying business keys (JE_HEADER_ID and JE_LINE_NUM) that anchor numerous downstream references across the EBS schema.

Key Information Stored

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

• JE_HEADER_ID — Journal entry header defining column and part of the composite primary key GL_JE_LINES_PK; foreign key to GL_JE_HEADERS.
• JE_LINE_NUM — Journal entry line number, the second component of the primary key and of the unique index GL_JE_LINES_U1 (JE_HEADER_ID, JE_LINE_NUM).
• LEDGER_ID — Ledger defining column; foreign key to GL_LEDGERS.
• CODE_COMBINATION_ID — Key flexfield combination defining column; foreign key to GL_CODE_COMBINATIONS.
• PERIOD_NAME — Accounting period associated with the line; part of nonunique index GL_JE_LINES_N1.
• EFFECTIVE_DATE — Journal entry line effective date.
• STATUS — Line status, 'U' unposted or 'P' posted.
• ENTERED_DR / ENTERED_CR — Debit and credit amounts in the entered currency.
• ACCOUNTED_DR / ACCOUNTED_CR — Debit and credit amounts in the ledger's base currency.
• DESCRIPTION — Journal entry line description (240 characters).
• LINE_TYPE_CODE — Line type classification.
• SUBLEDGER_DOC_SEQUENCE_ID / SUBLEDGER_DOC_SEQUENCE_VALUE — Subledger document sequencing columns, indexed by GL_JE_LINES_N3.
• GL_SL_LINK_ID / GL_SL_LINK_TABLE — Linkage back to the originating subledger transaction.
• Reference and descriptive flexfield columns — REFERENCE_1 through REFERENCE_10, ATTRIBUTE1–20, and CONTEXT columns.

The surrogate primary key is GL_JE_LINES_PK (JE_HEADER_ID, JE_LINE_NUM), which also serves as the business-key candidate exposed by unique index GL_JE_LINES_U1.

Common Use Cases and Queries

GL_JE_LINES is central to financial reporting, reconciliation, and audit. Typical scenarios include retrieving all lines for a posted journal, analyzing activity by account combination or accounting period, and tracing subledger accounting entries back to their source transactions.

• Listing lines for a specific journal: SELECT je_line_num, code_combination_id, entered_dr, entered_cr, status FROM gl_je_lines WHERE je_header_id = :header_id ORDER BY je_line_num;
• Account activity for a period: filter on CODE_COMBINATION_ID and PERIOD_NAME, leveraging index GL_JE_LINES_N1.
• Posted-versus-unposted analysis by joining to GL_JE_HEADERS and filtering GL_JE_LINES.STATUS.
• Subledger reconciliation using SUBLEDGER_DOC_SEQUENCE_ID and GL_SL_LINK_ID to match General Ledger lines to their originating subledger documents.

Related Objects

GL_JE_LINES references and is referenced by numerous objects across the EBS schema:

• GL_JE_HEADERS — Parent journal entry header, joined via JE_HEADER_ID.
• GL_LEDGERS — Joined via LEDGER_ID.
• GL_CODE_COMBINATIONS — Joined via CODE_COMBINATION_ID.
• GL_INTERFACE / GL_INTERFACE_HISTORY — Journal import sources joined via JE_HEADER_ID.
• GL_IMPORT_REFERENCES — Traceability of imported lines via JE_HEADER_ID.
• GL_ARCHIVE_LINES / GL_ARCHIVE_REFERENCES — Archived journal lines referencing JE_HEADER_ID.
• GL_BC_PACKETS / GL_BC_PACKETS_HISTS — Balances cubing and summary data referencing JE_HEADER_ID.
• FA_DEPRN_DETAIL and related FA tables — Fixed asset depreciation and adjustment entries referencing JE_HEADER_ID.
• GL_JOURNAL_REPORTS_ITF — Journal reporting interface joined via HEADER_ID.