Search Results pqh_budget_periods_efc




Overview
Explore in AI Chat

Overview

The table PQH_BUDGET_PERIODS_EFC is a specialized data object within the Oracle E-Business Suite (EBS) Public Sector Human Resources (PQH) module. Its primary role is to support the Euro as Functional Currency (EFC) process in versions 12.1.1 and 12.2.2. This table is not the primary transactional table but a copy of the PQH_BUDGET_PERIODS table, populated specifically by the EFC process. The EFC process is designed to handle currency conversion and reporting for organizations operating in the Eurozone, ensuring financial and budgetary data can be accurately represented and consolidated in Euros alongside other functional currencies. The existence of this table facilitates historical tracking and auditability of budget period data as it was translated during EFC processing runs.

Key Information Stored

The table stores a snapshot of budget period records associated with each EFC process execution. Its composite primary key indicates the two fundamental pieces of information it links: the original budget period identifier and the specific EFC action that created the copy. While the full column list is not detailed in the provided metadata, the structure is a replica of the PQH_BUDGET_PERIODS table. Therefore, it likely contains all budgetary attributes from the source table—such as period name, start and end dates, budget year, and associated entity identifiers—along with the critical EFC_ACTION_ID. This foreign key column is essential as it ties every copied record to a specific instance in the HR_EFC_ACTIONS table, which logs details about each EFC process run, including the conversion date and rate type used.

Common Use Cases and Queries

The primary use case is auditing and reporting on budget data as it was converted into Euros during historical EFC processes. Analysts or system administrators may query this table to verify which budget periods were processed in a given EFC run or to compare Euro-converted budgetary figures against the original values. A common query pattern involves joining to the HR_EFC_ACTIONS table to get context about the conversion event.

Sample Query:
SELECT bp_efc.*, efc.action_date, efc.rate_type
FROM hr.pqh_budget_periods_efc bp_efc
JOIN hr.hr_efc_actions efc ON bp_efc.efc_action_id = efc.efc_action_id
WHERE efc.efc_action_id = :p_action_id;
This query retrieves all budget period records copied by a specific EFC action, along with the action's details.

Related Objects

This table maintains defined relationships with other key EBS objects, primarily through its foreign key constraint.

  • Primary Key: PQH_BUDGET_PERIODS_EFC_PK on columns (BUDGET_PERIOD_ID, EFC_ACTION_ID). This enforces uniqueness for each budget period copy per EFC action.
  • Foreign Key (References): The table has a foreign key relationship where PQH_BUDGET_PERIODS_EFC.EFC_ACTION_ID references the HR_EFC_ACTIONS table. This is the sole documented foreign key, establishing the dependency on the master log of EFC processes.
  • Source Table: As per its description, PQH_BUDGET_PERIODS_EFC is a direct copy of the PQH_BUDGET_PERIODS table, which is the main transactional table for budget period definitions in the Public Sector HR module.