Search Results entry_code




Overview
Explore in AI Chat

Overview

The view GL_BUD_ASSGNMNT_PRD_RANGES_V is a General Ledger (GL) reporting object that joins budget assignment definitions with their associated budget period ranges. Its sole documented purpose is a restricted deployment designated "10SC ONLY," and the ETRM metadata records that it is not implemented in the reference database. In Oracle EBS 12.1.1 and 12.2.2 environments that do carry the object, the view provides a consolidated, read-only projection of two related budgeting tables so that consumers do not need to perform the join themselves.

The view answers a specific structural question: for a given budget assignment, which fiscal periods are governed by the assignment, and in which year do those periods begin and end? Because budget assignments control funds checking, encumbrance behavior, and budget-versus-actual derivation, exposing the period range alongside the assignment attributes makes the view useful for both inquiry reporting and downstream integration.

Underlying Base Objects

The view is defined over two GL tables, joined on the budget version:

The ETRM metadata lists no referenced base objects beyond the view text itself and no documented owner. All columns are projected directly from the two aliases; no expressions, functions, or additional tables appear in the definition, so the view introduces no derived logic and inherits the data types of the underlying columns.

Key Columns

The column END_PERIOD_NUM is the numeric end period of the range, which is preferable to the name for arithmetic comparisons and ordering.

Common Use Cases and Queries

Typical scenarios include verifying which period ranges an assignment covers, identifying assignments whose ranges end before a target period, and feeding period-aware budget data into external reconciliation processes.

SELECT ba.ledger_id, ba.budget_entity_id, ba.code_combination_id,
       ba.funds_check_level_code, br.period_year, br.end_period_num
FROM   gl_bud_assgnmnt_prd_ranges_v ba, br
WHERE  ba.budget_version_id = br.budget_version_id
AND    ba.ledger_id = :ledger_id;

To isolate assignments whose range has closed within a year, filter on END_PERIOD_NUM and OPEN_FLAG. Note that where the view is not implemented, the equivalent join against GL_BUDGET_ASSIGNMENTS and GL_BUDGET_PERIOD_RANGES should be written explicitly.