Search Results psb_budget_groups

Overview

The PSB_BUDGET_GROUPS table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, versions 12.1.1 and 12.2.2. It serves as the master repository for defining and managing budget groups, which are fundamental organizational constructs for budgetary control and reporting. A budget group typically represents a distinct budgetary entity, such as a department, program, or fund, within a specific set of books (ledger). It is critical to note that the PSB module is documented as obsolete in the provided ETRM metadata, indicating it may be in a state of maintenance or sunset. The table's primary function is to act as a central hub, linking budget definitions to related configuration and transactional data across the budgeting lifecycle.

Key Information Stored

While the specific column list is not detailed in the provided excerpt, the primary and foreign key relationships define its critical structure. The primary key, BUDGET_GROUP_ID, uniquely identifies each budget group record. A crucial foreign key, SET_OF_BOOKS_ID, links each budget group to a specific ledger in the General Ledger (GL) module via the GL_SETS_OF_BOOKS_11I table, anchoring the budget group to a financial reporting entity. Other columns, though not listed, would typically store attributes such as the budget group name, description, status, effective dates, and configuration flags controlling its behavior within the PSB application.

Common Use Cases and Queries

This table is primarily accessed for setup, reporting, and integration purposes. A common administrative query would list all active budget groups for a given ledger to verify setup. For reporting, analysts often join PSB_BUDGET_GROUPS with transactional tables like PSB_BUDGET_REVISIONS to aggregate budget amounts by group. Given the module's obsolete status, a critical use case is data extraction for migration or archival. A foundational query to retrieve basic budget group information would be:

• SELECT bg.BUDGET_GROUP_ID, bg.NAME, bg.SET_OF_BOOKS_ID, sob.NAME AS LEDGER_NAME FROM PSB_BUDGET_GROUPS bg, GL_SETS_OF_BOOKS_11I sob WHERE bg.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID;

Related Objects

The PSB_BUDGET_GROUPS table has extensive relationships, acting as a parent to numerous child tables in the PSB schema. Based on the documented foreign keys:

• Parent Reference: GL_SETS_OF_BOOKS_11I (via SET_OF_BOOKS_ID).
• Child References: The table is referenced by BUDGET_GROUP_ID in:
  • PSB_BUDGET_GROUP_CATEGORIES
  • PSB_BUDGET_GROUP_RESP
  • PSB_BUDGET_REVISIONS and PSB_BUDGET_REVISION_POSITIONS
  • PSB_BUDGET_WORKFLOW_RULES (for both primary and review groups)
  • PSB_DATA_EXTRACTS
  • PSB_POSITION_ACCOUNTS
  • PSB_SET_RELATIONS
  • PSB_WORKSHEETS
  • PSB_WS_DISTRIBUTION_RULES, PSB_WS_DISTRIBUTION_DETAILS, and PSB_WS_DISTRIBUTION_RULE_LINES

This network of relationships underscores the table's role as the anchor for budget group configuration, workflow, position control, worksheet distribution, and budget revision data.