Search Results psb_gl_budget_sets




Overview
Explore in AI Chat

Overview

The PSB_GL_BUDGET_SETS table is a core data definition table within the Oracle E-Business Suite (EBS) module Public Sector Budgeting (PSB). It serves as the master repository for defining budget sets, which are logical groupings of budgets within a specific set of books. This table is fundamental for establishing the structural framework for budget creation, revision, and reporting in a public sector or other budgeting context. Its primary role is to link budget definitions to a specific financial ledger (set of books) and to act as a parent entity for detailed budget data and related transactional objects. It is important to note that the Public Sector Budgeting module is marked as obsolete in the provided documentation for EBS 12.1.1 and 12.2.2.

Key Information Stored

Based on the provided metadata, the table's structure centers on a unique identifier and a link to the general ledger. The primary key column, GL_BUDGET_SET_ID, uniquely identifies each budget set definition within the system. A critical foreign key column is SET_OF_BOOKS_ID, which references the GL_SETS_OF_BOOKS_11I table. This column anchors the budget set to a specific financial ledger, ensuring all budgets within the set adhere to the correct accounting structure, calendar, and currency. While specific descriptive columns like NAME or DESCRIPTION are not listed in the excerpt, a typical implementation would include such fields to provide a meaningful label for the budget set definition.

Common Use Cases and Queries

A primary use case is retrieving all budget sets defined for a particular ledger to support setup or reporting activities. A common query would join PSB_GL_BUDGET_SETS to GL_SETS_OF_BOOKS to list budget sets with their associated ledger name. Another critical scenario involves validating data integrity before budget entry by ensuring a budget set exists for a given ledger ID. For reporting, this table is often the starting point in a join hierarchy to aggregate budget data across all budgets within a set. A sample query pattern is:

  • SELECT bg_set.GL_BUDGET_SET_ID, bg_set.SET_OF_BOOKS_ID, sob.NAME
    FROM PSB_GL_BUDGET_SETS bg_set, GL_SETS_OF_BOOKS sob
    WHERE bg_set.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID
    AND sob.SET_OF_BOOKS_ID = :ledger_id;

The documentation's note "Not implemented in this database" suggests that in some deployments, this table and related PSB objects may be absent, indicating the module is not installed.

Related Objects

The PSB_GL_BUDGET_SETS table has defined relationships with several key transactional tables in the Public Sector Budgeting module, as documented by its foreign keys:

  • Parent Table: GL_SETS_OF_BOOKS_11I, joined via PSB_GL_BUDGET_SETS.SET_OF_BOOKS_ID.
  • Child Tables:
    • PSB_BUDGET_REVISIONS, which references PSB_GL_BUDGET_SETS via the GL_BUDGET_SET_ID column to associate budget revisions with a specific budget set.
    • PSB_GL_BUDGETS, which references PSB_GL_BUDGET_SETS via the GL_BUDGET_SET_ID column, making the budget set the parent container for individual budget definitions.
    • PSB_WORKSHEETS, which references PSB_GL_BUDGET_SETS via the GL_BUDGET_SET_ID column to link budgeting worksheets to the overarching budget set.

These relationships create a hierarchy where a Set of Books contains one or more Budget Sets, which in turn contain specific Budgets, Revisions, and Worksheets.