Search Results budget_group_category_id

Overview

The PSB.PSB_BUDGET_GROUP_CATEGORIES table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, present in both releases 12.1.1 and 12.2.2. It functions as a junction or assignment table that manages the relationship between budget groups and budget categories. A budget category is a type of budget set used to logically group budget groups. The primary role of this table is to enable the definition of workflow rules by associating budget groups with specific stages (categories). This categorization also provides a foundation for grouping budget groups for enhanced reporting and analytical purposes within the budgeting lifecycle.

Key Information Stored

The table's structure is designed to track category assignments and standard application metadata. The most critical columns include:

• BUDGET_GROUP_CATEGORY_ID (NUMBER): The primary key and unique identifier for each category assignment record.
• BUDGET_GROUP_ID (NUMBER): A foreign key referencing PSB_BUDGET_GROUPS, identifying the specific budget group being categorized.
• STAGE_ID (NUMBER): A foreign key referencing PSB_BUDGET_STAGES, defining the budget category or stage to which the group is assigned.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the record's creation and modification history.
• Descriptive Flexfield Columns (ATTRIBUTE1-8, CONTEXT): Provide extensibility for capturing organization-specific attributes related to the category assignment.

Common Use Cases and Queries

This table is central to queries that determine which budget groups belong to a particular workflow stage or category. A common use case is generating a list of all budget groups assigned to a specific stage for workflow routing or approval notifications. For reporting, it allows for aggregating budget data by category. A fundamental query pattern involves joining to the related master tables:

SELECT bgc.BUDGET_GROUP_CATEGORY_ID,
bg.BUDGET_GROUP_NAME,
bs.STAGE_NAME
FROM PSB.PSB_BUDGET_GROUP_CATEGORIES bgc,
PSB.PSB_BUDGET_GROUPS bg,
PSB.PSB_BUDGET_STAGES bs
WHERE bgc.BUDGET_GROUP_ID = bg.BUDGET_GROUP_ID
AND bgc.STAGE_ID = bs.STAGE_ID
AND bs.STAGE_NAME = 'Initial Submission'; -- Example category filter

Administrative scripts may also query this table to audit or clean up assignment data, using the BUDGET_GROUP_CATEGORY_ID for precise record identification.

Related Objects

PSB_BUDGET_GROUP_CATEGORIES is a dependent object with defined foreign key relationships to two primary master tables in the PSB schema:

• PSB.PSB_BUDGET_GROUPS: Linked via the BUDGET_GROUP_ID column. This table stores the definition of budget groups.
• PSB.PSB_BUDGET_STAGES: Linked via the STAGE_ID column. This table defines the various budget stages or categories available for assignment.

The table's primary key constraint, PSB_BUDGET_GROUP_WFLOW_PK, is defined on BUDGET_GROUP_CATEGORY_ID, ensuring each assignment record is uniquely identifiable. This key may be referenced by other objects not detailed in the provided metadata.