Results for “psb_budget_groups_u3”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB.PSB_BUDGET_GROUPS is a foundational table in the Oracle Public Sector Budgeting (PSB) application, a component of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition information for budget groups and review groups, which are the basic organizational entities used to structure budgeting activity. Budget groups carry a BUDGET_GROUP_TYPE value of R and are arranged in a hierarchical parent/child structure, with the highest node in any hierarchy identified by the ROOT_BUDGET_GROUP flag. Review groups carry a BUDGET_GROUP_TYPE value of W and represent external entities used in the Budget Approval process; they are not hierarchical.

This table is classified as a hub under heuristic Data Vault modeling, reflecting its role as a durable catalog of business entities (budget groups and review groups) keyed by a single surrogate identifier and referenced by many dependent objects. Its primary key is PSB_BUDGET_GROUPS_PK on BUDGET_GROUP_ID. The documented physical schema contains 66 columns, stored in the APPS_TS_TX_DATA tablespace.

Key Information Stored

The table distinguishes a surrogate primary key from several business-key candidates. The most significant columns include:

• BUDGET_GROUP_ID — surrogate primary key; also the sole column of unique index PSB_BUDGET_GROUPS_U1.
• NAME and BUDGET_GROUP_TYPE — together form unique index PSB_BUDGET_GROUPS_U2, discriminating budget groups (R) from review groups (W).
• SHORT_NAME and BUDGET_GROUP_TYPE — together form unique index PSB_BUDGET_GROUPS_U3, the target of the user's "psb_budget_groups_u3" search.
• ROOT_BUDGET_GROUP and ROOT_BUDGET_GROUP_ID — identify the top of a hierarchy and point every group to its hierarchy root; non-unique index PSB_BUDGET_GROUPS_N2 covers the latter.
• PARENT_BUDGET_GROUP_ID — establishes the parent/child linkage; every non-root budget group has a parent. Non-unique index PSB_BUDGET_GROUPS_N1 covers this column.
• SET_OF_BOOKS_ID — foreign key to the ledger, defining the accounting context.
• PS_ACCOUNT_POSITION_SET_ID and NPS_ACCOUNT_POSITION_SET_ID — personnel services and non-personnel services account sets, applicable at the root group only.
• BUDGET_GROUP_CATEGORY_SET_ID — links the group to its category set definition.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — date-range validity for the group definition.
• FREEZE_HIERARCHY_FLAG — controls whether the hierarchy may be modified.
• NUM_PROPOSED_YEARS and NARRATIVE_DESCRIPTION — budgeting scope and descriptive text.
• SEGMENT1_TYPE through SEGMENT30_TYPE — key flexfield segment qualifiers governing account entry.
• Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and REQUEST_ID, ORGANIZATION_ID, BUSINESS_GROUP_ID for multi-org and concurrent processing context.

Common Use Cases and Queries

Typical use cases include locating a group by its short name, resolving hierarchy membership, listing review groups for approval routing, and reporting accounts accessible to users assigned to a group. Because every budget group's account list includes accounts defined for its child groups, hierarchy traversal queries are common.

Resolve a group by its short name (the U3 business key):

• SELECT budget_group_id, name, budget_group_type FROM psb.psb_budget_groups WHERE short_name = :short_name AND budget_group_type = 'R';

List all descendants of a root group:

• SELECT budget_group_id, name, parent_budget_group_id FROM psb.psb_budget_groups WHERE root_budget_group_id = :root_id AND budget_group_type = 'R';

Retrieve review groups for an approval workflow:

• SELECT budget_group_id, name, set_of_books_id FROM psb.psb_budget_groups WHERE budget_group_type = 'W';

Joining to GL_SETS_OF_BOOKS_11I via SET_OF_BOOKS_ID supports ledger-aware reporting, while joins to account position set tables resolve the account sets assigned to each group.

Related Objects

PSB_BUDGET_GROUPS is heavily referenced across the PSB schema. The most significant related objects include:

• GL.GL_SETS_OF_BOOKS_11I — referenced by PSB_BUDGET_GROUPS.SET_OF_BOOKS_ID; provides ledger context.
• PSB_BUDGET_GROUP_CATEGORIES — joins via BUDGET_GROUP_ID; defines category membership.
• PSB_BUDGET_GROUP_RESP — joins via BUDGET_GROUP_ID; assigns user responsibility for a group.
• PSB_BUDGET_REVISIONS and PSB_BUDGET_REVISION_ACCOUNTS — join via BUDGET_GROUP_ID; drive budget revision processing.
• PSB_BUDGET_WORKFLOW_RULES — joins via BUDGET_GROUP_ID and REVIEW_BUDGET_GROUP_ID, linking groups to review groups for approvals.
• PSB_POSITIONS and PSB_POSITION_ACCOUNTS — join via BUDGET_GROUP_ID; support position-based budgeting.
• PSB_WORKSHEETS, PSB_WS_ACCOUNT_LINES, and PSB_WS_POSITION_LINES — join via BUDGET_GROUP_ID; hold worksheet-level budgeting data.
• PSB_ENTITY and PSB_ENTITY_SET — join via BUDGET_GROUP_ID; define entity structures within a group.
• PSB_DATA_EXTRACTS and PSB_SET_RELATIONS — join via BUDGET_GROUP_ID; support extraction and set relationship definitions.

These relationships confirm the table's hub classification, as numerous satellites and link-style tables depend on its primary key.