Search Results gl_je_lines_v

Overview

GL_JE_LINES_V is an APPS-owned database view in the Oracle E-Business Suite General Ledger module, valid in both 12.1.1 and 12.2.2. It presents journal entry line detail joined with journal header and reconciliation attributes, providing a denormalized read-only surface over the underlying journal line table. Because EBS General Ledger stores balances and transaction detail across several tables, this view consolidates the line-level accounting facts — entered and accounted debit/credit amounts, code combinations, period and ledger context, descriptive references, and descriptive flexfield (DFF) columns — together with tax-related and reconciliation metadata. It is widely used for reporting, subledger-to-GL reconciliation, and integration extracts.

Notably for the search term taxable_line_flag, this column is not exposed directly in the documented GL_JE_LINES_V view text. The view does expose adjacent tax columns such as TAX_CODE, INVOICE_DATE, INVOICE_IDENTIFIER, and INVOICE_AMOUNT, which originate from the e-Business Tax/AP context populated on certain journal lines. Where a taxable line flag is required at the GL layer, it is typically sourced from the underlying tax repository (e.g., AP/AR tax lines) or from GL_JE_LINES' flexfield attributes rather than directly from this view.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects for GL_JE_LINES_V:

• GL_JE_LINES (SYNONYM) — the primary source of line-level journal data.
• GL_JE_LINES_RECON (SYNONYM) — supplies reconciliation attributes such as JGZZ_RECON_STATUS, JGZZ_RECON_DATE, JGZZ_RECON_ID, and JGZZ_RECON_REF.
• GL_CODE_COMBINATIONS (SYNONYM) — referenced for the accounting flexfield combination.
• GL_SYSTEM_USAGES (SYNONYM) — used to drive the DECODE logic around RECONCILIATION_UPG_FLAG for 11i/12 reconciliation reference handling.

The view selects from GL_JE_LINES (aliased JEL), joins reconciliation data from GL_JE_LINES_RECON (aliased REC), and applies a NVL on JGZZ_RECON_STATUS to default to 'U'. The DECODE on USE.RECONCILIATION_UPG_FLAG (from GL_SYSTEM_USAGES) determines whether the 11i reference column JGZZ_RECON_REF_11I or the current JGZZ_RECON_REF is returned, reflecting the reconciliation upgrade transition between 11i and R12. Header-level attributes are appended from the journal header (JE).

Key Columns

• JE_HEADER_ID / JE_LINE_NUM — identifies the parent journal header and the line sequence.
• CODE_COMBINATION_ID — the accounting flexfield combination for the line.
• ENTERED_DR / ENTERED_CR / ACCOUNTED_DR / ACCOUNTED_CR — entered and accounted debit/credit amounts.
• LEDGER_ID / PERIOD_NAME / EFFECTIVE_DATE / STATUS — ledger, accounting period, effective date, and line status.
• TAX_CODE, INVOICE_DATE, INVOICE_IDENTIFIER, INVOICE_AMOUNT — tax and invoice context columns relevant to tax reporting.
• CONTEXT, ATTRIBUTE1–20, CONTEXT2, CONTEXT3, CONTEXT4 — descriptive flexfield segments.
• JGZZ_RECON_STATUS / JGZZ_RECON_DATE / JGZZ_RECON_ID / JGZZ_RECON_REF — reconciliation tracking attributes, with status defaulting to 'U' when null.

Common Use Cases and Queries

The view supports journal line reporting, tax-aware extracts, and reconciliation monitoring. A representative query for tax-related lines:

• SELECT je_header_id, je_line_num, ledger_id, period_name, tax_code, invoice_amount, entered_dr, entered_cr FROM gl_je_lines_v WHERE tax_code IS NOT NULL;
• SELECT je_header_id, je_line_num, jgzz_recon_status FROM gl_je_lines_v WHERE jgzz_recon_status IN ('R','U');
• SELECT code_combination_id, SUM(accounted_dr), SUM(accounted_cr) FROM gl_je_lines_v WHERE period_name = :p_period GROUP BY code_combination_id;

Because taxable_line_flag is not a documented column here, integrations requiring an explicit taxable indicator should derive it from tax tables or DFF attributes rather than expecting it on this view.