Results for “hr_efc_currency_histories”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_EFC_CURRENCY_HISTORIES is a Human Resources (PER) module table in the Oracle E-Business Suite owned by the HR schema. It stores historical currency snapshot data captured during Electronic Funds Transfer (EFC) processing for payroll and payment workflows. Per the ETRM documentation, the table contains one row per NCU (National Currency Unit) currency as defined in FND_CURRENCIES at the time of EFC processing, with details of the NCU preserved for that processing run.

Functionally, this object acts as a point-in-time record of currency conversion attributes rather than a master currency definition. Because currency conversion factors and effective dates can change between payroll or EFT runs, EBS captures the state of each currency at the moment EFC is executed, ensuring that downstream calculations, reconciliations, and audit reporting can reproduce the exact conversion values applied. This is especially relevant in multi-currency payroll environments and in environments that historically supported NCU euro-conversion logic.

From a dimensional modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries a surrogate primary key (EFC_CURRENCY_HISTORY_ID) and a foreign key to HR_EFC_ACTIONS, implying it hangs off a parent EFC action entity and records descriptive, time-varying attributes rather than acting as a hub or a link. This positions it as a satellite-style history store keyed by the EFC action context.

Key Information Stored

• EFC_CURRENCY_HISTORY_ID — surrogate primary key defined by HR_EFC_CURRENCY_HISTORIES_PK; uniquely identifies each history row.
• EFC_ACTION_ID — foreign key to HR_EFC_ACTIONS; ties each currency snapshot to the specific EFC processing action that generated it.
• CURRENCY_CODE — the currency being snapshotted, corresponding to the NCU entries defined in FND_CURRENCIES.
• DERIVE_EFFECTIVE — the effective date associated with the derived conversion logic for the currency at processing time.
• DERIVE_FACTOR — the conversion factor derived for the currency during EFC processing.
• CREATION_DATE / CREATED_BY — audit fields capturing when and by whom the row was created.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — standard EBS audit columns recording the last modification context.
• CREATOR — originator identifier retained for legacy audit traceability.

The sole documented unique index, HR_EFC_CURRENCY_HISTORIES_PK, is on EFC_CURRENCY_HISTORY_ID. No separate business-key unique index is documented beyond the primary key, so the surrogate key is the authoritative identifier, while EFC_ACTION_ID plus CURRENCY_CODE effectively behave as the logical business identity for a given processing run.

Common Use Cases and Queries

The primary use cases center on audit, reconciliation, and retroactive reporting of currency conversion behavior during EFC processing. Typical patterns include retrieving all currencies associated with a given EFC action, tracing the derived effective date and factor used for a specific currency, and comparing snapshots across processing runs to detect changes in FND_CURRENCIES.

SELECT c.CURRENCY_CODE, c.DERIVE_EFFECTIVE, c.DERIVE_FACTOR
FROM   HR_EFC_CURRENCY_HISTORIES c
WHERE  c.EFC_ACTION_ID = :action_id;

SELECT c.EFC_ACTION_ID, c.CURRENCY_CODE, c.DERIVE_FACTOR,
       c.CREATION_DATE, c.LAST_UPDATE_DATE
FROM   HR_EFC_CURRENCY_HISTORIES c
WHERE  c.CURRENCY_CODE = :currency_code
ORDER BY c.CREATION_DATE DESC;

These queries support payroll audit trails, multi-currency EFT reconciliation, and historical conversion reporting where reproducing the exact factor applied at processing time is mandatory.

Related Objects

• HR_EFC_ACTIONS — parent of this table; joined via HR_EFC_CURRENCY_HISTORIES.EFC_ACTION_ID = HR_EFC_ACTIONS.EFC_ACTION_ID.
• FND_CURRENCIES — source of the currency definitions from which NCU entries are snapshotted.
• HR_EFC_CURRENCY_HISTORIES_PK — primary key index enforcing uniqueness on EFC_CURRENCY_HISTORY_ID.

These relationships make HR_EFC_ACTIONS the principal parent to record when analyzing this table, with FND_CURRENCIES providing the reference context for currency codes.