Search Results hr_efc_actions




Overview
Explore in AI Chat

Overview

The PQH_BUDGET_VERSIONS_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Public Sector Human Resources (PQH) module. It functions as a historical snapshot table, created and populated by the Euro as Functional Currency (EFC) process. This process is critical for organizations operating in the Eurozone, as it facilitates the conversion and retention of budget data from a legacy national currency into the Euro. The table is an exact structural copy of the core PQH_BUDGET_VERSIONS table, preserving budget version details at the point of a specific EFC conversion event. Its primary role is to maintain an auditable record of budget information as it existed prior to or during currency conversion, ensuring data integrity and compliance.

Key Information Stored

The table stores a complete replica of a budget version record, linked to a specific EFC conversion action. Its composite primary key is the most critical structural element, consisting of the original BUDGET_VERSION_ID from the source table and an EFC_ACTION_ID. The BUDGET_VERSION_ID column preserves the identifier of the budget version snapshot, while the EFC_ACTION_ID is a foreign key that ties this snapshot to a specific execution instance of the EFC process recorded in the HR_EFC_ACTIONS table. This linkage allows administrators to trace exactly which conversion run captured this particular state of the budget data. Other columns mirror those in PQH_BUDGET_VERSIONS, typically including details such as budget details, status, effective dates, and associated entity identifiers.

Common Use Cases and Queries

The primary use case is historical auditing and reconciliation of budget data following Euro conversion. Financial controllers or system administrators may query this table to compare pre-conversion and post-conversion budget figures or to investigate discrepancies. A common reporting pattern involves joining to the HR_EFC_ACTIONS table to get context about the conversion event, such as the run date.

  • Sample Query for Audit: SELECT pbve.*, hea.action_date FROM pqh_budget_versions_efc pbve JOIN hr_efc_actions hea ON pbve.efc_action_id = hea.efc_action_id WHERE pbve.budget_version_id = :1 ORDER BY hea.action_date;
  • Data Reconciliation: Comparing amounts in PQH_BUDGET_VERSIONS_EFC (converted Euro values) with source system records to validate the accuracy of the EFC process.
  • Compliance Reporting: Generating reports that demonstrate the state of budgetary controls at the legal moment of currency transition for regulatory purposes.

Related Objects

The table has defined relationships with other EBS objects, primarily through foreign key constraints that ensure referential integrity within the EFC framework.

  • HR_EFC_ACTIONS: This is the primary related table. The column PQH_BUDGET_VERSIONS_EFC.EFC_ACTION_ID is a foreign key referencing HR_EFC_ACTIONS. This relationship associates every snapshot in PQH_BUDGET_VERSIONS_EFC with a master record of an EFC process execution, containing metadata about that run.
  • PQH_BUDGET_VERSIONS: As the source table from which PQH_BUDGET_VERSIONS_EFC is copied, they share an identical structure. The relationship is logical rather than enforced by a database constraint, linked via the BUDGET_VERSION_ID column. This allows for direct data comparison between the active table and its historical EFC snapshot.