Search Results external_reference




Overview
Explore in AI Chat

Overview

The GLFV_BUDGET_JOURNAL_ENTRIES view belongs to the Oracle General Ledger (GL) module of Oracle E-Business Suite, version 12.1.1 / 12.2.2. It exposes journal entry header information restricted to budget-related journals by joining GL_JE_HEADERS to GL_BUDGET_VERSIONS. The view is a "flexfield" (FV) style reporting object, meaning it flattens descriptive identifiers — ledger names, category names, source names, and budget version names — onto a single row so that downstream reports, OBIEE extracts, Discoverer worksheets, and custom SQL do not have to repeat lookup joins.

The view is documented as Not implemented in this database, meaning it is delivered as a database object but not seeded with data of its own; its rows are derived entirely at query time. Its practical role is to provide a consolidated, security-aware read layer over budget journal headers, including the EXTERNAL_REFERENCE column that users search on to reconcile budget entries against legacy or third-party systems.

Underlying Base Objects

The ETRM metadata documents no persistent base tables separate from the SQL text. The view is defined over the following GL objects:

The WHERE clause ties rows to the caller's login access set through GL_SECURITY_PKG.LOGIN_ACCESS_ID, and permits a row only when the access set is at full ledger level (SECURITY_SEGMENT_CODE = 'F' or ACCESS_PRIVILEGE_CODE = 'F') or when a matching segment value assignment exists.

Key Columns

Common Use Cases and Queries

The most frequent scenario is tracing a budget journal by its external reference. A typical query is:

  • SELECT je_header_id, name, ledger_id, budget_name, period_name, external_reference, control_total FROM glfv_budget_journal_entries WHERE external_reference = 'PO-2024-00417';
  • Reconciling budget journals to a feeder system by listing all entries for a source and period: filter on USER_JE_SOURCE_NAME and PERIOD_NAME.
  • Auditing budget-to-actual comparisons by joining this view to GL_BALANCES on LEDGER_ID, PERIOD_NAME, and CURRENCY_CODE.
  • Detecting reversal activity via REVERSED_JE_HEADER_ID and the accrual reversal lookup columns.

Because access set security is embedded in the view, results automatically respect the responsibility's data access set, which makes it safe for end-user reporting without additional security predicates.