Search Results hr_efc_rounding_errors




Overview
Explore in AI Chat

Overview

HR_EFC_ROUNDING_ERRORS is a transactional table in the HR schema of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the PER (Human Resources) product family. As documented in ETRM, the table "holds one row for each time a rounding error adjustment has been made." It therefore functions as an audit and detail ledger that captures the specific currency rounding discrepancies detected and corrected during payroll-related EFC (External Financial Computation) processing. Because rounding rules applied to monetary amounts can generate fractional remainders, this table records each adjustment so that the correction is traceable back to its originating action and source record.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is satellite-leaning. In other words, the table is best understood as a descriptive satellite attached to a parent business entity — here, the EFC action represented by HR_EFC_ACTIONS — rather than an independent hub or a pure link between two hubs. Each row supplies context (the rounding amount and source location) about an adjustment event tied to that action.

Key Information Stored

The documented physical schema contains 11 columns. The most significant are:

The distinction between surrogate and business keys matters here: EFC_ROUNDING_ERROR_ID is the technical identifier, while the UK01 composite (action, source ID, source table, source column) is the natural business key that guarantees no duplicate adjustment is recorded for the same source element within an action.

Common Use Cases and Queries

Typical scenarios include reconciling payroll rounding adjustments, auditing which source columns generate the most rounding errors, and investigating discrepancies surfaced during EFC runs. A representative query joins to the parent action:

  • List all rounding errors for a given action: SELECT * FROM hr.hr_efc_rounding_errors WHERE efc_action_id = :action_id;
  • Aggregate the total adjustment value by source: SELECT source_table, source_column, SUM(rounding_amount) FROM hr.hr_efc_rounding_errors GROUP BY source_table, source_column;
  • Trace an adjustment back to its action: SELECT a.*, r.rounding_amount FROM hr.hr_efc_actions a, hr.hr_efc_rounding_errors r WHERE a.efc_action_id = r.efc_action_id;

These patterns support reconciliation reporting and root-cause analysis of systematic rounding behavior.

Related Objects

The principal related object is the parent action table referenced by the documented foreign key:

  • HR_EFC_ACTIONS — Joined via HR_EFC_ROUNDING_ERRORS.EFC_ACTION_ID = HR_EFC_ACTIONS.EFC_ACTION_ID. This is the only foreign key documented in the ETRM metadata.

Because the metadata identifies only this single foreign-key relationship, additional dependencies on external-financial-computation tables and APIs should be confirmed against the specific ETRM 12.2.2 schema before reliance. The HR_EFC_ROUNDING_ERRORS_PK and HR_EFC_ROUNDING_ERRORS_UK01 unique indexes govern integrity for the primary and business keys respectively.