Results for “dflt_budget_set_id”

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

Overview

PQH_BUDGET_SETS is a Public Sector HR (PQH) application table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores groupings of budget elements together with their default distribution rules, forming the structural foundation upon which budget periods, budget elements, and positional budget allocations are organized. In the context of Oracle EBS, this object acts as a configuration and control table: each row defines a named budget set that aggregates one or more budget elements, and the set is anchored to a specific budget period through the BUDGET_PERIOD_ID foreign key. The table also carries a reference to a default budget set via DFLT_BUDGET_SET_ID, which allows an organization to designate the baseline set used when no explicit set is chosen.

From a data-modeling perspective, the ETRM metadata classifies this object as satellite-leaning. That classification suggests PQH_BUDGET_SETS is best modeled as a satellite attached to a hub or link, holding descriptive and distribution attributes (the percentage, value, and availability columns) rather than serving as the central transactional entity. The presence of audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER is consistent with a satellite-style, version-tracked record.

Key Information Stored

The table is documented with 21 columns. The most significant are:

• BUDGET_SET_ID — the surrogate primary key (PQH_BUDGET_SETS_PK) that uniquely identifies each budget set.
• DFLT_BUDGET_SET_ID — foreign key to PQH_DFLT_BUDGET_SETS, identifying the default set configuration; part of the PQH_BUDGET_SETS_UK unique key.
• BUDGET_PERIOD_ID — foreign key to PQH_BUDGET_PERIODS, tying the set to its budget period; the second component of the PQH_BUDGET_SETS_UK business-key candidate.
• BUDGET_UNIT1_PERCENT, BUDGET_UNIT2_PERCENT, BUDGET_UNIT3_PERCENT — the percentage distribution applied to each of the three budget units represented in the set.
• BUDGET_UNIT1_VALUE, BUDGET_UNIT2_VALUE, BUDGET_UNIT3_VALUE — the monetary or numeric values assigned to each budget unit.
• BUDGET_UNIT1_VALUE_TYPE_CD, BUDGET_UNIT2_VALUE_TYPE_CD, BUDGET_UNIT3_VALUE_TYPE_CD — code columns that qualify how each unit value is interpreted.
• BUDGET_UNIT1_AVAILABLE, BUDGET_UNIT2_AVAILABLE, BUDGET_UNIT3_AVAILABLE — available balances or flags per unit.
• OBJECT_VERSION_NUMBER — optimistic locking control used by the Oracle framework during concurrent updates.

The business-key candidate (DFLT_BUDGET_SET_ID, BUDGET_PERIOD_ID) is significant: it implies that a given default set and budget period combination is intended to be unique within the table, while the surrogate BUDGET_SET_ID remains the physical primary key.

Common Use Cases and Queries

Typical reporting scenarios include listing all budget sets for an active period, resolving each set's default configuration, and calculating the distributed value of each unit. A representative join query follows:

• SELECT bs.BUDGET_SET_ID, bs.BUDGET_PERIOD_ID, bs.BUDGET_UNIT1_PERCENT, bs.BUDGET_UNIT1_VALUE FROM HR.PQH_BUDGET_SETS bs WHERE bs.BUDGET_PERIOD_ID = :period;
• Joining to PQH_DFLT_BUDGET_SETS to retrieve the default distribution: ... JOIN HR.PQH_DFLT_BUDGET_SETS d ON bs.DFLT_BUDGET_SET_ID = d.DFLT_BUDGET_SET_ID.
• Aggregating elements per set by joining PQH_BUDGET_ELEMENTS on BUDGET_SET_ID.

These queries support budget setup validation, distribution audits, and period-end reconciliation.

Related Objects

• PQH_BUDGET_PERIODS — parent of BUDGET_PERIOD_ID; defines the period a set belongs to.
• PQH_DFLT_BUDGET_SETS — referenced by DFLT_BUDGET_SET_ID; holds default set definitions.
• PQH_BUDGET_ELEMENTS — child table; PQH_BUDGET_ELEMENTS.BUDGET_SET_ID references PQH_BUDGET_SETS, embodying the element membership of each set.
• PQH_BUDGET_SETS_PK / PQH_BUDGET_SETS_UK — the primary and unique indexes enforcing identity and uniqueness.

Together these objects form the budget configuration cluster within Public Sector HR.