Search Results per_budget_values_efc_pk




Overview
Explore in AI Chat

Overview

The HR.PER_BUDGET_VALUES_EFC table is a specialized technical table within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It functions as a historical snapshot table for the Enterprise Fusion Currency (EFC) conversion process. EFC is a critical financial process that standardizes transactional data across different currencies into a single reporting currency. This table's sole purpose is to preserve a subset of columns from its base table, PER_BUDGET_VALUES, specifically capturing the original National Currency Unit (NCU) values and currency codes before the EFC conversion was applied. It is exclusively maintained by the EFC process itself, ensuring an audit trail of pre-conversion budget data.

Key Information Stored

The table stores a minimal set of columns focused on the pre-EFC state of budget values. The BUDGET_VALUE_ID and EFC_ACTION_ID columns together form the primary key (PER_BUDGET_VALUES_EFC_PK), linking the snapshot to a specific budget record and a specific EFC process run. The VALUE and BUDGET_CURRENCY columns hold the original monetary amount and its currency code prior to conversion. A crucial column is EFC_BG_CURRENCY, which stores the Business Group Currency used as a basis for the EFC conversion for that specific record. This structure allows for historical comparison and analysis of budget figures before and after currency standardization.

  • BUDGET_VALUE_ID: Foreign key to the original budget value record.
  • EFC_ACTION_ID: Foreign key to HR_EFC_ACTIONS, identifying the EFC process instance.
  • VALUE: The original budget value in the National Currency Unit (NCU).
  • BUDGET_CURRENCY: The original currency code of the VALUE.
  • EFC_BG_CURRENCY: The Business Group Currency used for the EFC conversion.

Common Use Cases and Queries

This table is primarily used for audit, reconciliation, and troubleshooting purposes related to the EFC process. Financial and system administrators may query it to verify the accuracy of conversions by comparing pre-EFC values with post-EFC values in the main transaction tables. It is essential for diagnosing discrepancies in consolidated financial reports that span multiple currencies. A typical query involves joining to the HR_EFC_ACTIONS table to get context about the conversion run (e.g., date, status).

Sample Audit Query:
SELECT pbv.budget_value_id,
pbv.value AS original_ncu_value,
pbv.budget_currency AS original_currency,
pbv.efc_bg_currency,
hea.action_date
FROM hr.per_budget_values_efc pbv,
hr.hr_efc_actions hea
WHERE pbv.efc_action_id = hea.efc_action_id
AND hea.action_date BETWEEN :p_start_date AND :p_end_date;
This query retrieves the snapshot data along with the date of the EFC action for a given time period.

Related Objects

The table has defined relationships with other key EBS objects, primarily through foreign key constraints. Its structure is central to the EFC audit trail.

  • Primary Key: PER_BUDGET_VALUES_EFC_PK on (BUDGET_VALUE_ID, EFC_ACTION_ID). This was the object of the user's search.
  • Foreign Key (References): The EFC_ACTION_ID column is a foreign key referencing the HR_EFC_ACTIONS table. This links every record in PER_BUDGET_VALUES_EFC to a specific execution of the EFC process.
  • Base Table: While not a formal foreign key, this table is a direct subset of columns from the base transaction table PER_BUDGET_VALUES, identified by the BUDGET_VALUE_ID.