Search Results dflt_budget_set_id




Overview
Explore in AI Chat

Overview

The HR.PQH_DFLT_BUDGET_SETS table is a master data repository within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Human Resources (HR) module. It functions as a core configuration table for the Oracle Advanced Benefits (OAB) and Oracle HRMS Budgeting functionality. The table's primary role is to define and store named groupings of default budget elements and funding sources. These predefined budget sets serve as templates, enabling the efficient and consistent assignment of budget structures to various organizational entities, such as business groups, during the setup and maintenance of compensation and benefits plans.

Key Information Stored

The table stores the fundamental attributes required to identify and manage a default budget set. The DFLT_BUDGET_SET_ID is the unique, system-generated primary key identifier. The DFLT_BUDGET_SET_NAME provides the descriptive label for the budget set template. The BUSINESS_GROUP_ID column is a mandatory foreign key that links the budget set to a specific business group, enforcing data security at the Business Group level as per the Oracle HRMS multi-org architecture. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information, while OBJECT_VERSION_NUMBER is used for optimistic locking and concurrency control in the application's middle-tier logic.

Common Use Cases and Queries

This table is central to configuration and reporting tasks related to benefits budgeting. Administrators use it to review or maintain the list of available default budget set templates. A common operational query involves fetching all budget sets for a specific business group to populate a list of values in the application interface. For troubleshooting or data validation, analysts may join this table with its child detail tables to verify the completeness of a budget set's configuration. A typical reporting query to list all budget sets with basic audit information is:

  • SELECT dflt_budget_set_id, dflt_budget_set_name, business_group_id, creation_date, last_updated_by FROM hr.pqh_dflt_budget_sets WHERE business_group_id = :p_bg_id ORDER BY dflt_budget_set_name;

Another critical use case involves identifying which budget sets are actively referenced by transactional data, such as worksheets or active budget definitions.

Related Objects

The HR.PQH_DFLT_BUDGET_SETS table maintains several key foreign key relationships, positioning it as a parent record for detailed budget configuration. It is referenced by the following child tables, using DFLT_BUDGET_SET_ID as the join column:

Furthermore, it references the HR_ALL_ORGANIZATION_UNITS table via the BUSINESS_GROUP_ID column to enforce business group context. The table also has associated database views (PQH_DFLT_BUDGET_SETS, PQH_DFLT_BUDGET_SETS_WHO) that provide application-level access and standardized audit column formatting.