Search Results hr_efc_currency_histories




Overview
Explore in AI Chat

Overview

The HR_EFC_CURRENCY_HISTORIES table is a historical data repository within Oracle E-Business Suite (EBS) Human Resources (HR). Its primary role is to support the Euro Functional Currency (EFC) conversion process, a critical feature for organizations operating in European countries that adopted the Euro. The table captures a point-in-time snapshot of Non-Euro Currency Unit (NCU) definitions as they existed in the master FND_CURRENCIES table at the moment an EFC conversion was executed. This historical record is essential for auditability, compliance, and troubleshooting, ensuring a verifiable trail of the currency states used during financial data conversions.

Key Information Stored

The table stores one row for each NCU currency processed during an EFC run. While the full column list is not detailed in the provided metadata, the structure typically includes the following key fields inferred from its purpose and relationships. The primary key, EFC_CURRENCY_HISTORY_ID, uniquely identifies each historical record. The foreign key column, EFC_ACTION_ID, links the record to a specific processing run in the HR_EFC_ACTIONS table. Other columns would capture the essential attributes of the currency from FND_CURRENCIES at that time, such as the currency code, name, symbol, and likely the conversion rate or precision details relevant to the EFC process.

Common Use Cases and Queries

This table is primarily accessed for audit reports and historical analysis related to Euro conversions. Common scenarios include generating a report of all currencies and their defined attributes as of a specific EFC processing date, or reconciling converted data by verifying the exact currency information used. A typical query would join to HR_EFC_ACTIONS to provide context on the run.

Sample Query Pattern:
SELECT hch.*, ha.action_date
FROM hr.hr_efc_currency_histories hch,
hr.hr_efc_actions ha
WHERE hch.efc_action_id = ha.efc_action_id
AND ha.action_date BETWEEN :p_start_date AND :p_end_date
ORDER BY ha.action_date, hch.currency_code;

Related Objects

The table has defined relationships with other core EFC objects, forming part of the conversion framework's data model.

  • HR_EFC_ACTIONS: This is the primary parent table. Each record in HR_EFC_CURRENCY_HISTORIES is associated with a specific EFC processing run via the foreign key HR_EFC_CURRENCY_HISTORIES.EFC_ACTION_ID referencing HR_EFC_ACTIONS.
  • FND_CURRENCIES: Although not a formal foreign key constraint documented in the snippet, this table is the direct source of the historical data. HR_EFC_CURRENCY_HISTORIES denormalizes and preserves a snapshot of the relevant rows from FND_CURRENCIES.
  • Table: HR_EFC_CURRENCY_HISTORIES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_CURRENCY_HISTORIES,  object_name:HR_EFC_CURRENCY_HISTORIES,  status:VALID,  product: PER - Human Resources ,  description: Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with details of the NCU. ,  implementation_dba_data: HR.HR_EFC_CURRENCY_HISTORIES , 

  • Table: HR_EFC_CURRENCY_HISTORIES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_CURRENCY_HISTORIES,  object_name:HR_EFC_CURRENCY_HISTORIES,  status:VALID,  product: PER - Human Resources ,  description: Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with details of the NCU. ,  implementation_dba_data: HR.HR_EFC_CURRENCY_HISTORIES , 

  • 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 ,