Search Results originating_bal_seg_value




Overview
Explore in AI Chat

Overview

The GLFV_ACTUAL_JOURNAL_ENTRIES view is a General Ledger (GL) reporting and inquiry object exposed in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents actual journal entry header information enriched with descriptive attributes drawn from the ledger, journal batch, journal category, journal source, and daily conversion type definitions. The view is designed to support journal entry inquiry, reconciliation reporting, and integration extracts where header-level detail for posted and unposted actual journals is required.

The view is subject to Oracle's ledger access set security model. Its WHERE clause invokes GL_SECURITY_PKG.LOGIN_ACCESS_ID and joins GL_ACCESS_SETS, GL_ACCESS_SET_LEDGERS, and, conditionally, GL_JE_SEGMENT_VALUES and GL_ACCESS_SET_ASSIGNMENTS. This restricts returned rows to the ledgers and balancing/management segment values the logged-in user is authorized to access, making it suitable for secured self-service reporting. The ETRM metadata notes the view is "Not implemented in this database," indicating it is delivered as a definition rather than a seeded runtime object in that environment.

Underlying Base Objects

The view is defined over the following documented base objects: GL_JE_HEADERS (aliased JE1 for the primary header, and self-joined as JE2 and JE3 for parent and reversed journal name resolution), GL_LEDGERS, GL_JE_BATCHES, GL_JE_CATEGORIES, GL_JE_SOURCES, GL_DAILY_CONVERSION_TYPES, GL_ACCESS_SETS, and GL_ACCESS_SET_LEDGERS. The primary driving table is GL_JE_HEADERS; all other joins provide descriptive or security context. The self-joins to GL_JE_HEADERS resolve the names of parent journals (JE2.NAME) and reversed journals (JE3.NAME) via PARENT_JE_HEADER_ID and REVERSED_JE_HEADER_ID respectively.

Key Columns

Common Use Cases and Queries

Typical scenarios include journal entry inquiries by conversion type, reconciliation of entered versus accounted totals, batch-level journal listings, and reversal tracking. The following query filters journals by user conversion type and ledger:

  • SELECT name, period_name, currency_code, currency_conversion_rate, user_conversion_type, currency_conversion_date, control_total FROM glfv_actual_journal_entries WHERE ledger_id = :ledger_id AND user_conversion_type = :conv_type;

Reversal and accrual analysis can be performed by selecting ACCRUAL_REV_PERIOD_NAME, ACCRUAL_REV_EFFECTIVE_DATE, and the resolved reversal status columns. Because the view embeds access set security, queries run against it return only ledgers the current user may access, which simplifies row-level security in custom reports and extracts. Where additional journal line detail is required, the view's JE_HEADER_ID can be joined to GL_JE_LINES.