Search Results pqh_budgets_efc




Overview
Explore in AI Chat

Overview

The PQH_BUDGETS_EFC table is a critical 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 functions as a historical snapshot table, created and populated by the Euro as Functional Currency (EFC) conversion process. This process is essential for organizations operating in the European Union that must report financial and HR data in Euros while maintaining transactional records in a local currency. The table is an exact structural copy of the primary PQH_BUDGETS table, but it stores budget data that has been converted and frozen at the point of an EFC action. Its role is to provide an immutable audit trail of budget values as they existed at specific conversion points, ensuring compliance and accurate historical reporting in the functional currency.

Key Information Stored

The table stores converted budget records linked to specific EFC events. Its composite primary key is the most significant structural element, consisting of BUDGET_ID and EFC_ACTION_ID. The BUDGET_ID column holds the identifier from the original PQH_BUDGETS table, preserving the link to the core budget definition. The EFC_ACTION_ID is a foreign key that ties each converted budget record to a specific run of the EFC process documented in the HR_EFC_ACTIONS table. Beyond these key columns, the table mirrors all columns from PQH_BUDGETS, typically including details such as budget version, entity, period, and the converted monetary values (e.g., budgeted amounts, funded amounts) in the functional Euro currency.

Common Use Cases and Queries

The primary use case is regulatory and historical reporting on budget data in Euros for specific periods or as of specific conversion dates. Financial auditors may query this table to verify the budget values used in official EU reports. A common query pattern involves joining to HR_EFC_ACTIONS to filter by conversion period or action type. For example, to retrieve all converted budget records from the most recent EFC action, one might use:

  • SELECT b.* FROM pqh_budgets_efc b, hr_efc_actions a WHERE b.efc_action_id = a.efc_action_id AND a.action_status = 'COMPLETED' ORDER BY a.action_date DESC;

Another critical use is comparative analysis, where data in PQH_BUDGETS_EFC is compared against the live data in PQH_BUDGETS to analyze the impact of currency conversion or to track changes in budget values between EFC snapshots.

Related Objects

The table has defined relationships with core EBS objects, primarily through its foreign key constraint. The documented relationship is:

  • HR_EFC_ACTIONS: This is the master table for EFC process runs. The PQH_BUDGETS_EFC.EFC_ACTION_ID column references HR_EFC_ACTIONS, providing metadata about the conversion event (e.g., action date, status, parameters). Every record in PQH_BUDGETS_EFC must correspond to a valid entry in HR_EFC_ACTIONS.

As a copy, its structure is intrinsically related to the PQH_BUDGETS table, though this is a structural rather than a formally constrained foreign key relationship. The BUDGET_ID in PQH_BUDGETS_EFC originates from the primary key of PQH_BUDGETS, maintaining referential integrity to the source budget definition.