Search Results psb_budget_group_categories




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_GROUP_CATEGORIES table is a core data object within the Oracle E-Business Suite (EBS) module Public Sector Budgeting (PSB), which is designated as obsolete in releases 12.1.1 and 12.2.2. This table serves a critical junction function in the budget formulation workflow. It is designed to manage the association between budget groups—logical collections of budget data—and specific budget categories. By linking these entities, the table enables the structured classification and organization of budget line items or activities within a defined budgetary framework, facilitating detailed tracking, reporting, and approval processes tailored for public sector requirements.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key structure defines its essential data. The central identifier is the BUDGET_GROUP_CATEGORY_ID, which serves as the table's primary key. The table's purpose is established through its foreign key relationships: the BUDGET_GROUP_ID column links to the PSB_BUDGET_GROUPS table, and the STAGE_ID column links to the PSB_BUDGET_STAGES table. This structure indicates that the table stores records that assign a specific budget category to a particular budget group, potentially within the context of a defined budget workflow stage. The metadata explicitly states this table is "Not implemented in this database," suggesting it may be a reference or legacy object in standard installations.

Common Use Cases and Queries

The primary use case for this table is to query which budget categories are applicable to a given budget group, which is fundamental for generating budget entry templates and validation rules. A typical query would join to the related group and stage tables to provide context. For instance, to list all category associations for a specific budget group, one might use a SQL pattern such as:

  • SELECT bgc.budget_group_category_id, bg.budget_group_name, bgc.stage_id FROM psb_budget_group_categories bgc JOIN psb_budget_groups bg ON bgc.budget_group_id = bg.budget_group_id WHERE bg.budget_group_id = :p_group_id;

Given the module's obsolete status and the note on non-implementation, direct operational use in reporting or processes is likely minimal in current deployments, with any functionality potentially migrated to alternative solutions.

Related Objects

This table is centrally connected to two other key PSB tables via foreign key constraints, forming a core part of the (obsolete) budgeting data model.

  • PSB_BUDGET_GROUPS: The parent table for the BUDGET_GROUP_ID foreign key. This table defines the budget groups themselves.
  • PSB_BUDGET_STAGES: The parent table for the STAGE_ID foreign key. This table defines the stages in the budget workflow, indicating the category assignment may be stage-specific.
  • PSB_BUDGET_GROUP_WFLOW_PK: This is the name of the primary key constraint on the BUDGET_GROUP_CATEGORY_ID column, enforcing record uniqueness.