Search Results psb_budget_groups_v




Overview
Explore in AI Chat

Overview

PSB_BUDGET_GROUPS_V is an APPS-owned view in the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. Its purpose is to present budget group definitions alongside the attributes of their parent and root budget groups, the associated general ledger set of books, and the owning organization. The view is principally a reporting and inquiry construct: forms, concurrent programs, and integration components within PSB reference it to resolve hierarchical relationships between budget groups without repeatedly joining the base table to itself.

The presence of the ROOT_REQUEST_ID column in user search patterns reflects the fact that budget group generation and hierarchy refresh are request-driven operations. The view exposes request identifiers inherited from the base table, allowing users to trace which concurrent request created or last affected a budget group record. In this sense the view functions as a denormalized presentation layer that simplifies hierarchy-aware reporting and audit queries.

Underlying Base Objects

The view text is defined over five documented base objects:

  • PSB_BUDGET_GROUPS — aliased three times (BG, BGP, BGR) to supply the budget group itself, its parent, and its root.
  • GL_SETS_OF_BOOKS — aliased RSOB, providing the set of books name, chart of accounts, and currency for the root budget group.
  • HR_ALL_ORGANIZATION_UNITS_TL — aliased ORG, supplying the translated organization name for the organization_id on the budget group.

The join predicates restrict the first alias, BG, to records where NVL(BG.ROOT_BUDGET_GROUP,'N') = 'N', meaning the view primarily exposes top-level (root) budget group rows and their hierarchy context. Parent and root attributes are derived through the self-joins on PSB_BUDGET_GROUPS. The documented ETRM metadata lists no additional referenced base objects, so the view should be treated as a self-contained PSB reporting object anchored on the budget group table.

Key Columns

Common Use Cases and Queries

The view is typically queried to produce hierarchy-aware listings of budget groups for a ledger, to identify which concurrent request generated a given root budget group, or to feed downstream reporting and integration extracts. A representative query tracing root budget group request information is:

  • SELECT budget_group_id, name, root_budget_group_id, request_id, set_of_books_id FROM apps.psb_budget_groups_v WHERE request_id = :p_request_id;
  • SELECT name, short_name, currency_code, organization_id FROM apps.psb_budget_groups_v WHERE set_of_books_id = :p_sob ORDER BY name;
  • SELECT budget_group_id, name, freeze_hierarchy_flag, num_proposed_years FROM apps.psb_budget_groups_v WHERE root_budget_group = 'N';

Because the view restricts output to root-level records and aggregates parent, root, ledger, and organization attributes, it is well suited to ad hoc reporting in Oracle Reports, BI Publisher, and OAF-based inquiry pages where the underlying PSB_BUDGET_GROUPS self-referencing structure would otherwise require complex joins.