Search Results per_assignment_budget_v_efc_pk




Overview
Explore in AI Chat

Overview

The HR.PER_ASSIGNMENT_BUDGET_VALU_EFC table is a specialized audit and historical data table within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Human Resources (HR) module. Its primary role is to support the Euro Functional Currency (EFC) conversion process. This table stores a snapshot of National Currency Unit (NCU) and currency code values from the base assignment budget values table prior to the EFC conversion. It is a critical component for maintaining financial data integrity and auditability, allowing the system to preserve original currency values for historical reference and reporting after a business group's functional currency is converted to the Euro. As documented, this table is exclusively maintained by the automated EFC process and is not intended for manual data manipulation.

Key Information Stored

The table contains a subset of columns from its base table, focusing on the key identifiers and the original currency values. The most critical columns are:

  • ASSIGNMENT_BUDGET_VALUE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE: These columns form part of the primary key and uniquely identify the specific budget value record from the base table that was processed by EFC.
  • EFC_ACTION_ID: A mandatory foreign key column that links to the HR_EFC_ACTIONS table, identifying the specific EFC conversion event that created this historical record.
  • VALUE: Stores the original budget value in the National Currency Unit before the EFC conversion.
  • EFC_BG_CURRENCY: Stores the original Business Group currency code that was in effect prior to the conversion to the Euro.

The primary key constraint, PER_ASSIGNMENT_BUDGET_V_EFC_PK, is defined on the combination of ASSIGNMENT_BUDGET_VALUE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and EFC_ACTION_ID, ensuring a unique historical record for each EFC action on a specific budget entry.

Common Use Cases and Queries

The primary use case is audit reporting and historical analysis of budget values before the EFC conversion. It is queried to reconcile post-conversion Euro values with original NCU values or to generate compliance reports. A typical query retrieves the pre-conversion snapshot for a specific budget assignment or EFC event. The standard query pattern, as indicated by the ETRM documentation, is:

SELECT assignment_budget_value_id,
       effective_start_date,
       effective_end_date,
       efc_action_id,
       value,
       efc_bg_currency
FROM hr.per_assignment_budget_valu_efc
WHERE efc_action_id = :action_id;

For a more comprehensive audit trail, this table is often joined with HR_EFC_ACTIONS to get details of the conversion run and with the current PER_ASSIGNMENT_BUDGET_VALUES_F table to compare pre- and post-conversion figures.

Related Objects

This table has defined relationships with other key EBS objects, primarily through foreign key constraints and its role in the EFC architecture.

  • Primary Key: PER_ASSIGNMENT_BUDGET_V_EFC_PK on this table.
  • Foreign Key (References):
    • TABLE: HR_EFC_ACTIONS via the column EFC_ACTION_ID. This links each record to the master log of EFC conversion actions performed in the system.
  • Base Table: While not a formal foreign key, this EFC table is a direct subset of PER_ASSIGNMENT_BUDGET_VALUES_F, holding a pre-conversion copy of specific columns from that base table.
  • Index: The unique index PER_ASSIGNMENT_BUDGET_V_EFC_PK supports the primary key constraint and is stored in the APPS_TS_TX_IDX tablespace.