Search Results pqh_budget_details_efc




Overview
Explore in AI Chat

Overview

The PQH_BUDGET_DETAILS_EFC table 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. As explicitly documented, this table is a copy of the core PQH_BUDGET_DETAILS table, populated specifically by the EFC conversion routines. It serves as a historical or parallel ledger, storing budget detail information that has been translated into Euros for organizations operating under this specific financial reporting requirement. Its existence ensures that original transactional data in the base currency is preserved while providing a compliant dataset for Euro-based reporting and analysis.

Key Information Stored

The table stores a replicated set of budget detail records, with the crucial addition of a link to the EFC conversion process. The primary key is a composite of BUDGET_DETAIL_ID and EFC_ACTION_ID, which ties each converted record to a specific instance of the EFC process. While the full column list mirrors PQH_BUDGET_DETAILS (containing details like budget amounts, periods, and element links), the most critical columns for its purpose are:

  • BUDGET_DETAIL_ID: The identifier linking back to the original source record in the PQH_BUDGET_DETAILS table.
  • EFC_ACTION_ID: The foreign key to the HR_EFC_ACTIONS table, which tracks the specific conversion job that populated the data, including critical metadata like conversion rates and dates.
  • All monetary amounts within this table are expected to be the Euro-equivalent values as calculated during the EFC process.

Common Use Cases and Queries

The primary use case is generating financial reports for entities that must report budgets in Euros. Auditors or finance personnel may query this table to verify converted amounts or trace the impact of specific conversion rates. A typical query would join to the EFC actions table to understand the conversion context. For example, to retrieve all Euro-converted budget details for a specific conversion run, one might use:

SELECT efc.* FROM pqh_budget_details_efc efc WHERE efc.efc_action_id = :action_id;

Another common pattern is comparative analysis, joining PQH_BUDGET_DETAILS_EFC back to PQH_BUDGET_DETAILS on BUDGET_DETAIL_ID to review original versus converted values for a given period or budget element.

Related Objects

This table has defined relationships with several core EBS objects, as per the provided metadata. The most direct dependency is through its foreign key constraint.

  • Primary Key Table: The table's primary key is PQH_BUDGET_DETAILS_EFC_PK on the columns (BUDGET_DETAIL_ID, EFC_ACTION_ID).
  • Foreign Key Relationship: PQH_BUDGET_DETAILS_EFC.EFC_ACTION_ID references HR_EFC_ACTIONS. This is a critical link, as HR_EFC_ACTIONS is the master table logging all EFC conversion processes in the system.
  • Source Table: As a copy, its structure and core data originate from PQH_BUDGET_DETAILS, the main transactional table for budget details in the Public Sector HR module.