Search Results per_budget_values_efc




Overview
Explore in AI Chat

Overview

The PER_BUDGET_VALUES_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module. It functions as a historical snapshot table, created and populated exclusively by the EFC (Euro as Functional Currency) process. This process is a critical component for organizations operating in the Eurozone, designed to convert and store legacy financial data from legacy national currencies into the Euro. The table's primary role is to preserve a converted copy of budget value data from the core PER_BUDGET_VALUES table, ensuring a compliant and auditable record of financial information as it existed at the point of Euro conversion. It is not a transactional table for day-to-day operations but serves as a permanent reference for historical reporting and compliance.

Key Information Stored

The table's structure mirrors that of its source, PER_BUDGET_VALUES, with the crucial addition of a column linking it to the EFC conversion event. The most significant columns include:

  • BUDGET_VALUE_ID: The primary identifier for the budget value record, carried over from the original table. It forms part of the composite primary key for this snapshot.
  • EFC_ACTION_ID: A mandatory foreign key column that links the record to the HR_EFC_ACTIONS table. This column identifies the specific EFC conversion run that created this snapshot, providing essential audit trail information.

The remaining columns would replicate the budget-specific data from PER_BUDGET_VALUES at the time of conversion, such as budget version, assignment ID, currency code (now in EUR), and the converted monetary value amounts.

Common Use Cases and Queries

The primary use case is historical analysis and regulatory auditing of HR budget data pre- and post-Euro conversion. A typical query would join this table to the EFC actions table to retrieve all budget values converted in a specific EFC run, or to compare converted historical values against current figures. For example, to audit a specific conversion batch:

SELECT pbv_efc.* FROM per_budget_values_efc pbv_efc, hr_efc_actions hea WHERE pbv_efc.efc_action_id = hea.efc_action_id AND hea.action_name = '<CONVERSION_RUN_NAME>';

Reporting use cases are almost exclusively compliance-focused, such as generating evidence for financial auditors demonstrating the accurate and consistent conversion of HR budget data during the EFC process. Direct data manipulation (INSERT/UPDATE/DELETE) on this table is performed only by the EFC process itself.

Related Objects

This table has defined relationships with two key objects, as per the provided metadata:

  • Primary Source Table: PER_BUDGET_VALUES. PER_BUDGET_VALUES_EFC is a direct structural and data copy of this core transactional table.
  • Foreign Key Relationship: HR_EFC_ACTIONS. The table has a foreign key constraint where PER_BUDGET_VALUES_EFC.EFC_ACTION_ID references HR_EFC_ACTIONS. This relationship is vital for tracing every record in the snapshot back to the specific system action that created it.

The composite primary key constraint PER_BUDGET_VALUES_EFC_PK is defined on (BUDGET_VALUE_ID, EFC_ACTION_ID), ensuring uniqueness for each converted snapshot record.