Search Results per_assignment_budget_valu_efc




Overview
Explore in AI Chat

Overview

The PER_ASSIGNMENT_BUDGET_VALU_EFC table is a specialized data object within the Oracle E-Business Suite Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It functions as a historical snapshot table created and populated by the Euro as Functional Currency (EFC) conversion process. This process is a critical one-time operation for organizations adopting the Euro, designed to convert and preserve transactional data from a legacy functional currency. The table is an exact structural copy of the core transactional table PER_ASSIGNMENT_BUDGET_VALUES_F. Its primary role is to archive the pre-conversion state of assignment budget value records, ensuring a complete audit trail and data integrity for historical reporting and compliance purposes after the currency migration is complete.

Key Information Stored

The table stores archived rows from the PER_ASSIGNMENT_BUDGET_VALUES_F table, which manages budgeted compensation values for assignments. Its composite primary key is critical for uniquely identifying each archived snapshot. The key columns are ASSIGNMENT_BUDGET_VALUE_ID, which identifies the specific budget record; EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, which define the date range of the budget entry's validity; and EFC_ACTION_ID. The EFC_ACTION_ID is a foreign key column that links each archived row to the HR_EFC_ACTIONS table, which logs metadata about the specific EFC conversion job that created the snapshot. Other columns mirror those in the source table, capturing all relevant budget value details such as currency, amount, and assignment linkage as they existed at the moment of conversion.

Common Use Cases and Queries

The primary use case for this table is historical auditing and reporting on assignment budget values from before the Euro conversion. It is typically queried in conjunction with the main transactional table to compare pre- and post-conversion values or to reconstruct historical financial data in the legacy currency. Common queries involve filtering by the EFC_ACTION_ID to isolate records from a specific conversion run or joining to assignment tables for comprehensive historical analysis. A sample reporting pattern is shown below:

  • SELECT efc.* FROM hr.per_assignment_budget_valu_efc efc WHERE efc.efc_action_id = &action_id; – To review all budget records archived by a specific EFC process.
  • SELECT hist.*, act.conversion_date FROM hr.per_assignment_budget_valu_efc hist JOIN hr_efc_actions act ON hist.efc_action_id = act.efc_action_id WHERE hist.assignment_id = &assign_id; – To retrieve the archived budget history for a specific assignment along with the conversion date.

Direct manipulation of this table is rare; it is primarily a read-only source for historical inquiry.

Related Objects

This table has defined dependencies within the HR schema, primarily through its foreign key relationship. The key related objects are:

  • Primary Source Table: PER_ASSIGNMENT_BUDGET_VALUES_F – This is the operational table from which the EFC table's structure and original data are derived.
  • Foreign Key Reference: HR_EFC_ACTIONS table – The PER_ASSIGNMENT_BUDGET_VALU_EFC.EFC_ACTION_ID column references HR_EFC_ACTIONS. This relationship provides the context for the conversion event, linking each snapshot row to the master record of the EFC job that created it.
  • Primary Key Constraint: PER_ASSIGNMENT_BUDGET_V_EFC_PK – Enforces uniqueness on the combination of ASSIGNMENT_BUDGET_VALUE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and EFC_ACTION_ID.
  • Table: PER_ASSIGNMENT_BUDGET_VALU_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_ASSIGNMENT_BUDGET_VALU_EFC,  object_name:PER_ASSIGNMENT_BUDGET_VALU_EFC,  status:VALID,  product: PER - Human Resources ,  description: This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F table which is populated by the EFC (Euro as Functional Currency) process. ,  implementation_dba_data: HR.PER_ASSIGNMENT_BUDGET_VALU_EFC , 

  • Table: PER_ASSIGNMENT_BUDGET_VALU_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_ASSIGNMENT_BUDGET_VALU_EFC,  object_name:PER_ASSIGNMENT_BUDGET_VALU_EFC,  status:VALID,  product: PER - Human Resources ,  description: This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F table which is populated by the EFC (Euro as Functional Currency) process. ,  implementation_dba_data: HR.PER_ASSIGNMENT_BUDGET_VALU_EFC , 

  • Table: HR_EFC_ACTIONS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ACTIONS,  object_name:HR_EFC_ACTIONS,  status:VALID,  product: PER - Human Resources ,  description: Contains one row for each time the EFC conversion process or delete _EFC table data process is run. ,  implementation_dba_data: HR.HR_EFC_ACTIONS , 

  • Table: HR_EFC_ACTIONS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ACTIONS,  object_name:HR_EFC_ACTIONS,  status:VALID,  product: PER - Human Resources ,  description: Contains one row for each time the EFC conversion process or delete _EFC table data process is run. ,  implementation_dba_data: HR.HR_EFC_ACTIONS ,