Search Results gl_budget_set_name




Overview
Explore in AI Chat

Overview

The PSB.PSB_GL_BUDGET_SETS table is a General Ledger budget set definition table within the Oracle EBS Public Sector Budgeting (PSB) module. It stores the definition of Budget Sets. A budget set groups multiple funding budgets, applicable to a set of account combinations, used to extract budget balances during worksheet creation or to post worksheet estimates during budget journal creation in General Ledger. In Oracle EBS 12.1.1 and 12.2.2, PSB is primarily used by Public Sector / government-oriented budgeting functionality, and this table acts as the master record for the grouping of budgets that PSB worksheets, revisions, interfaces, and GL budget records rely upon.

From a Data Vault modeling perspective, the object is classified as hub-leaning. This is a heuristic classification: PSB_GL_BUDGET_SETS carries a single-column surrogate primary key (GL_BUDGET_SET_ID), holds the stable business identifier GL_BUDGET_SET_NAME scoped to a Set of Books, and serves as the parent referenced by multiple downstream tables. It therefore behaves much like a hub, with the dependent transaction and revision details living in satellite and link tables elsewhere in the model.

Key Information Stored

The table contains 19 documented columns. The most important are:

  • GL_BUDGET_SET_ID — NUMBER(15). The General Ledger budget set identifier. This is the surrogate primary key of the table and the value propagated to all dependent child tables. It is also the column of unique index PSB_GL_BUDGET_SETS_U1.
  • GL_BUDGET_SET_NAME — VARCHAR2(80). The user-facing name of the budget set. Along with Set of Books, it forms the business-key candidate enforced by unique index PSB_GL_BUDGET_SETS_U2.
  • SET_OF_BOOKS_ID — NUMBER(15). The General Ledger Set of Books identifier that scopes the budget set. It is the second column of the PSB_GL_BUDGET_SETS_U2 unique index and a foreign key to GL_SETS_OF_BOOKS_11I.
  • CONTEXT — VARCHAR2(30). The Descriptive Flexfield context for the budget set record.
  • ATTRIBUTE1 through ATTRIBUTE10 — VARCHAR2(150) each. Descriptive Flexfield segment columns available for customer-specific extension of the budget set definition.
  • Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. These record audit and concurrency information in line with EBS conventions.

The distinction between the surrogate key (GL_BUDGET_SET_ID) and the composite business key (SET_OF_BOOKS_ID + GL_BUDGET_SET_NAME) is important when performing lookups, data migrations, or integrations where a budget set must be resolved by its natural name within a ledger.

Common Use Cases and Queries

A frequent search pattern for this table is by budget set name. Because GL_BUDGET_SET_NAME is only unique within a Set of Books, queries should normally constrain by both columns:

  • Resolving a budget set to its numeric identifier for use in child-table joins or interfaces.
  • Listing all budget sets defined for a given ledger or Set of Books.
  • Checking duplicates or validating naming conventions during data migration.
  • Auditing recently created or modified budget sets using the Who columns.

Representative SQL patterns:

  • SELECT GL_BUDGET_SET_ID, GL_BUDGET_SET_NAME, SET_OF_BOOKS_ID FROM PSB.PSB_GL_BUDGET_SETS WHERE GL_BUDGET_SET_NAME = :name AND SET_OF_BOOKS_ID = :sob;
  • SELECT GL_BUDGET_SET_ID, GL_BUDGET_SET_NAME FROM PSB.PSB_GL_BUDGET_SETS WHERE SET_OF_BOOKS_ID = :sob ORDER BY GL_BUDGET_SET_NAME;
  • SELECT GL_BUDGET_SET_ID, GL_BUDGET_SET_NAME, CREATION_DATE FROM PSB.PSB_GL_BUDGET_SETS WHERE CREATED_BY = :user_id;

For reporting, joining to GL Sets of Books (SET_OF_BOOKS_ID) resolves the ledger name, while joining to the child tables described below provides the budgets, worksheets, and revisions associated with each set.

Related Objects

The table participates in a defined relational structure. The following are the most significant related objects:

  • GL_SETS_OF_BOOKS_11I (referenced by this table). Joined on PSB_GL_BUDGET_SETS.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS_11I.SET_OF_BOOKS_ID to retrieve the ledger or Set of Books designation.
  • PSB_GL_BUDGETS (references this table). Joined on GL_BUDGET_SET_ID; holds the individual budgets grouped by the set.
  • PSB_BUDGET_REVISIONS (references this table). Joined on GL_BUDGET_SET_ID; tracks revisions associated with the budget set.
  • PSB_WORKSHEETS (references this table). Joined on GL_BUDGET_SET_ID; worksheets extract budget balances using the set definition.
  • PSB_GL_INTERFACES (references this table). Joined on GL_BUDGET_SET_ID; carries entries posted during budget journal creation.

Because four distinct child tables reference GL_BUDGET_SET_ID, this table functions as the central parent in the PSB budgeting model. Any change to a budget set identifier affects all four dependents, so deletes and key updates should be treated with care, consistent with referential integrity enforced in the EBS PSB schema.