Search Results psb_gl_budgets




Overview
Explore in AI Chat

Overview

The PSB_GL_BUDGETS table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module. It functions as a master repository for storing the names and identifiers of General Ledger (GL) budgets that are logically grouped within a budget set. In the context of public sector and complex organizational budgeting, a budget set is a collection of related budgets used for planning, control, and reporting. This table establishes the fundamental link between individual budget definitions and the higher-level sets to which they belong, enabling structured budget hierarchy management and consolidation processes essential for governmental and institutional financial oversight.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define its critical structural data. The central column is GL_BUDGET_ID, which serves as the unique primary key identifier for each budget record within the PSB system. The GL_BUDGET_SET_ID is a crucial foreign key column that links each budget to its parent budget set defined in the PSB_GL_BUDGET_SETS table. Based on standard PSB data model patterns, the table likely also contains columns for the budget name (NAME), a description (DESCRIPTION), an associated ledger or set of books ID, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is central to queries that list budgets for a specific planning cycle or reporting entity. A common use case is generating a report of all budgets within a particular budget set for review or data validation. Administrators may query this table to understand the composition of budget sets before running budget consolidation or translation processes. A typical SQL pattern involves joining to the budget sets table to retrieve meaningful context:

  • SELECT bg.NAME, bg.GL_BUDGET_ID, bs.NAME AS BUDGET_SET_NAME FROM PSB_GL_BUDGETS bg, PSB_GL_BUDGET_SETS bs WHERE bg.GL_BUDGET_SET_ID = bs.GL_BUDGET_SET_ID ORDER BY bs.NAME, bg.NAME;
  • Another critical use case is during the configuration of budget relationships and hierarchies, where the GL_BUDGET_ID is referenced as a parent or child node in the PSB_SET_RELATIONS table.

Related Objects

The PSB_GL_BUDGETS table has defined relationships with several other key PSB tables, forming the backbone of the budgeting data model.

  • PSB_GL_BUDGET_SETS: This is the parent table. Each record in PSB_GL_BUDGETS is associated with a single budget set via the foreign key PSB_GL_BUDGETS.GL_BUDGET_SET_ID referencing PSB_GL_BUDGET_SETS.
  • PSB_SET_RELATIONS: This table references PSB_GL_BUDGETS as a parent. The foreign key PSB_SET_RELATIONS.GL_BUDGET_ID points to PSB_GL_BUDGETS.GL_BUDGET_ID. This relationship allows for the construction of complex hierarchical relationships (e.g., parent-child, summary-detail) between different budgets within the system.