Search Results psb_budget_revisions




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_REVISIONS 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 functions as the primary header or master table for recording budget revision transactions. A budget revision is a formal process to adjust previously approved budget amounts, and this table serves as the central repository for the metadata and control information of each revision request. Its role is critical for maintaining audit trails, workflow status, and the overall integrity of the budget adjustment process within the PSB application.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as BUDGET_REVISION_ID, which uniquely identifies each revision transaction. Based on its role as a header table and standard PSB design patterns, it typically stores high-level attributes for a revision. This includes references to the associated budget group (via BUDGET_GROUP_ID) and the General Ledger budget set (via GL_BUDGET_SET_ID). Other common columns would capture the revision number, description, current status (e.g., Draft, In-Process, Approved, Posted), effective dates, the person who initiated the request, and timestamps for creation and last update. The table acts as the parent record for all detailed line-item adjustments.

Common Use Cases and Queries

This table is central to reporting and integration tasks related to budget revisions. Common use cases include generating audit reports of all revisions within a date range, tracking the status of pending revisions for management review, and extracting revision header data for integration with external financial systems. A fundamental query involves joining to related tables to get a complete view of a revision.

  • Basic Revision Header Report: SELECT budget_revision_id, revision_number, description, status_code, creation_date FROM psb_budget_revisions WHERE budget_group_id = :p_group AND creation_date >= SYSDATE - 30;
  • Join to Budget Groups for Context: Queries frequently join PSB_BUDGET_REVISIONS to PSB_BUDGET_GROUPS via BUDGET_GROUP_ID to include budget group names and other attributes in reports.
  • Workflow Monitoring: Application screens and custom reports query this table to display a list of revisions filtered by status, such as all revisions currently in an 'Approval' or 'Pending Posting' state.

Related Objects

The PSB_BUDGET_REVISIONS table has defined relationships with several key PSB tables, forming the backbone of the budget revision data model.