Search Results pqh_bdgt_pool_realloctions_efc

Overview

The PQH_BDGT_POOL_REALLOCTIONS_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Public Sector HR (PQH) module. Its primary role is to support the Euro as Functional Currency (EFC) process in environments where the Euro is the mandated reporting currency. The table is an exact structural copy of the base table, PQH_BDGT_POOL_REALLOCATIONS, and is populated exclusively by the EFC process. It serves as a critical repository for storing budget pool reallocation data that has been converted or processed to comply with Euro-centric accounting and reporting requirements, ensuring financial data integrity for public sector organizations operating under these regulations.

Key Information Stored

The table stores a complete replica of budget pool reallocation records, synchronized for EFC compliance. Its structure is defined by the primary key, which is a composite of REALLOCATION_ID and EFC_ACTION_ID. The REALLOCATION_ID links each record back to its source entry in the original PQH_BDGT_POOL_REALLOCATIONS table, maintaining data lineage. The EFC_ACTION_ID is a foreign key column that references the HR_EFC_ACTIONS table, which tracks and controls the execution of the EFC conversion process. This linkage is crucial for auditing, allowing administrators to trace which EFC process run created or updated the records in this table.

Common Use Cases and Queries

This table is primarily accessed for financial reporting and reconciliation in Euro-functional currency environments. Common operational scenarios include generating audit reports for EFC-processed budget reallocations and reconciling amounts between the base table and its EFC counterpart. A typical query pattern involves joining to the HR_EFC_ACTIONS table to understand the processing context.

• Retrieving all reallocations processed by a specific EFC run:

  SELECT * FROM pqh_bdgt_pool_realloctions_efc efc
WHERE efc.efc_action_id = &action_id;

• Comparing a specific reallocation between the base and EFC tables for data integrity checks:

  SELECT base.*, efc.* FROM pqh_bdgt_pool_reallocations base
FULL OUTER JOIN pqh_bdgt_pool_realloctions_efc efc ON base.reallocation_id = efc.reallocation_id
WHERE base.reallocation_id = &realloc_id OR efc.reallocation_id = &realloc_id;

Related Objects

The PQH_BDGT_POOL_REALLOCTIONS_EFC table has defined dependencies within the HR schema. Its existence is fundamentally tied to the base object it mirrors and the process that populates it.

• PQH_BDGT_POOL_REALLOCATIONS: The source table from which this EFC table's structure is copied and from which data is sourced during the EFC process.
• HR_EFC_ACTIONS: The controlling table referenced via the foreign key (EFC_ACTION_ID). This relationship documents which EFC conversion action populated the records.
• EFC Process (Program/Engine): While not a database object, the proprietary EFC process is the sole mechanism for populating and maintaining this table; it should not be modified directly via DML.