Search Results psb_budget_stages




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_STAGES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master repository for defining the distinct phases, or stages, of a budget cycle, such as "Initial Submission," "Department Review," "Council Approval," and "Final Adopted." Each stage can be associated with a specific budget category, enabling organizations to model complex, multi-step approval workflows that are typical in government and public sector budgeting. The table's primary role is to provide the structural definition for the sequential progression of a budget through its lifecycle, governing the rules, permissions, and routing logic applied at each point.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure and relationships indicate critical fields. The primary key is BUDGET_STAGE_ID, a unique identifier for each stage record. A key foreign key column is BUDGET_STAGE_SET_ID, which links the stage to its parent definition in the PSB_BUDGET_STAGE_SETS table, allowing for different sets of stages for different budget types or fiscal years. Other essential columns would logically include fields to define the stage's sequence order, name, description, and its associated budget category. The table's description as holding "budget stage and budget category definitions" suggests it may denormalize or directly store category information pertinent to each stage.

Common Use Cases and Queries

A primary use case is configuring and reporting on the budget approval workflow. Administrators query this table to validate or audit the defined stage sequence. A common operational query is to determine the current and next available stages for a budget line based on its status. For reporting, it is frequently joined to transaction tables to analyze time spent in or volume of budgets at each stage.

  • Listing Stages for a Stage Set: SELECT budget_stage_id, name, sequence_num FROM psb_budget_stages WHERE budget_stage_set_id = :p_set_id ORDER BY sequence_num;
  • Finding Workflow Rules for a Stage: This table is joined to PSB_BUDGET_WORKFLOW_RULES to retrieve the actions and approvals required for a specific stage.

Related Objects

The PSB_BUDGET_STAGES table is central to the PSB workflow architecture, with several key dependencies as per the provided foreign key constraints.

  • PSB_BUDGET_STAGE_SETS: The parent table. A stage set groups multiple budget stages into a coherent process.
  • PSB_BUDGET_GROUP_CATEGORIES: References a stage via STAGE_ID, likely to associate budget groups or categories with a specific approval point.
  • PSB_BUDGET_WORKFLOW_RULES: Has two foreign key relationships. RULES.STAGE_ID defines the rules applicable for a given stage. RULES.OVERRIDE_STAGE_ID allows a rule to specify an alternate target stage, enabling conditional routing within the workflow.