Search Results reallocation_id




Overview
Explore in AI Chat

Overview

The table PQH_BDGT_POOL_REALLOCTIONS is a core data object within the Oracle E-Business Suite (EBS) Public Sector HR (PQH) module, specifically for versions 12.1.1 and 12.2.2. It is owned by the HR schema and holds a valid status. This table is fundamental to the budget management functionality, serving as the primary repository for recording resource reallocation transactions related to budget positions. Its role is to track the movement of financial or headcount resources between different budgetary entities or pools, enabling detailed audit trails and supporting complex budgeting scenarios typical in public sector and other regulated HR environments.

Key Information Stored

The table's structure is designed to capture the essential details of each reallocation event. The primary key is the REALLOCATION_ID, which uniquely identifies each transaction record. A critical foreign key relationship exists via the POOL_ID column, which references the PQH_BUDGET_POOLS table. This link ties each reallocation to a specific source or destination budget pool. While the provided metadata does not list all columns, typical data stored in such a table would include the reallocation amount or quantity, effective dates, the source and target position or budget detail identifiers, the reallocation reason or type, and standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is central to processes where budget resources must be transferred or adjusted after initial allocation. Common use cases include mid-year budget adjustments, reallocating surplus funds from one department to another, or moving headcount between positions due to reorganization. For reporting and reconciliation, analysts frequently query this table. A sample SQL pattern to analyze reallocations for a specific budget pool would be:

  • SELECT reallocation_id, pool_id, reallocation_amount, effective_date
  • FROM pqh_bdgt_pool_realloctions
  • WHERE pool_id = <pool_id_value>
  • ORDER BY effective_date DESC;

Another common query involves joining with PQH_BUDGET_POOLS to generate a summary report of all reallocation activity per pool, crucial for period-end financial closing and budget variance analysis.

Related Objects

PQH_BDGT_POOL_REALLOCTIONS has defined dependencies within the PQH product family. Its most significant relationship is with the PQH_BUDGET_POOLS table, as enforced by the foreign key on POOL_ID. This indicates that reallocations are intrinsically linked to defined budget pools. It is highly probable that this table is referenced by various Public Sector HR forms, workflows, and APIs that manage the budget reallocation process. Furthermore, it may serve as a source for key budget-related views or be accessed by standard Oracle APIs for data integrity and validation during transaction processing. Developers and DBAs should consider these relationships during any data migration, upgrade, or customization effort.