Search Results gl_budget_set_id




Overview
Explore in AI Chat

Overview

The PSB_GL_BUDGET_SETS table is a core data structure 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 definition table for Budget Sets, a critical concept for budget control and reporting in integrated GL and PSB environments. A Budget Set is a logical grouping of multiple funding budgets that are applicable to a specific set of account combinations. Its primary functional role is to enable the extraction of consolidated budget balances during the creation of budget worksheets and to facilitate the posting of worksheet estimates when generating budget journals in General Ledger. This object is essential for organizations managing complex, multi-budget appropriations within a single ledger.

Key Information Stored

The table stores the fundamental attributes that define a unique Budget Set. The primary key is the system-generated identifier, GL_BUDGET_SET_ID. The most critical user-facing column is GL_BUDGET_SET_NAME, an 80-character mandatory field that holds the unique name of the budget set within its ledger. The table is explicitly tied to a specific General Ledger ledger via the SET_OF_BOOKS_ID column, which forms a composite unique constraint with the name. Standard Oracle "Who" columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) track row history. The table also includes a CONTEXT column and ten ATTRIBUTE columns to support Descriptive Flexfield (DFF) customization, allowing implementations to capture additional qualifying information specific to their business needs.

Common Use Cases and Queries

This table is central to budget inquiry, setup validation, and integration reporting. A common operational need is to retrieve all budget sets defined for a particular ledger, often for setup audits or user reference in downstream processes. The following query pattern is fundamental:

  • Listing Budget Sets by Ledger:
    SELECT gl_budget_set_name, gl_budget_set_id, last_update_date
    FROM psb.psb_gl_budget_sets
    WHERE set_of_books_id = :ledger_id
    ORDER BY gl_budget_set_name;
  • Validating Unique Name for a Ledger: Before creating a new budget set via a custom interface or script, a check against the unique constraint (SET_OF_BOOKS_ID, GL_BUDGET_SET_NAME) is required to prevent ORA-00001 errors.
  • Integration Reporting: The table is frequently joined to budget detail and assignment tables (e.g., PSB_GL_BUDGET_SET_ASSIGNMENTS) to produce reports showing which specific budgets and account ranges are grouped under each named budget set.

Related Objects

PSB_GL_BUDGET_SETS is a parent table with key relationships to other PSB entities. Based on the unique index structure and functional description, the primary foreign key relationships are:

  • PSB_GL_BUDGET_SET_ASSIGNMENTS: This child table likely references PSB_GL_BUDGET_SETS.GL_BUDGET_SET_ID to define the specific budgets and account combinations that are members of the parent budget set.
  • GL_SET_OF_BOOKS: The SET_OF_BOOKS_ID column foreign key references the GL_SET_OF_BOOKS table (or GL_LEDGERS in R12), tethering each budget set to a single EBS ledger.
  • Budget Worksheet and Journal Tables: Downstream PSB and GL tables for worksheet lines (PSB_GL_WORKSHEET_LINES) and budget journals will reference the GL_BUDGET_SET_ID to identify the source budget set used for balance calculations and postings.