Search Results per_work_incident_efc_pk




Overview
Explore in AI Chat

Overview

The HR.PER_WORK_INCIDENTS_EFC table is a specialized supporting object within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to support the Euro Functional Currency (EFC) conversion process. This table does not store base transactional data; instead, it acts as an audit and reference repository. It maintains a historical snapshot of National Currency Unit (NCU) and currency code values from the associated base table, PER_WORK_INCIDENTS, prior to their conversion by the EFC process. As documented, the table is exclusively populated and maintained by the automated EFC process itself, ensuring a record of original monetary values for compliance and reporting purposes.

Key Information Stored

The table contains a deliberately limited subset of columns focused on the financial attributes of a work incident. The key columns are:

  • INCIDENT_ID: The unique identifier for the work incident record, forming part of the primary key. This links the EFC snapshot back to the original incident.
  • EFC_ACTION_ID: A foreign key to HR_EFC_ACTIONS, identifying the specific EFC conversion run that created this snapshot record. It completes the primary key, allowing multiple snapshots per incident if the EFC process runs multiple times.
  • COMPENSATION_AMOUNT: The monetary compensation amount associated with the work incident, stored in its original NCU value before EFC conversion.
  • COMPENSATION_CURRENCY: The original currency code (e.g., ITL, DEM, FRF) for the compensation amount prior to conversion to Euros.
The primary key constraint PER_WORK_INCIDENT_EFC_PK, defined on the combination of INCIDENT_ID and EFC_ACTION_ID, enforces the uniqueness of this historical data.

Common Use Cases and Queries

The primary use case is audit and reconciliation reporting for financial compliance, particularly in European Union contexts where tracking pre-Euro currency transactions is required. A typical query retrieves the original currency details for incidents processed in a specific EFC run. For example, to audit all work incident compensation values converted during a particular EFC action:

SELECT wiefc.incident_id,
       wiefc.compensation_amount AS original_ncu_amount,
       wiefc.compensation_currency AS original_currency,
       hea.action_date
FROM hr.per_work_incidents_efc wiefc,
     hr.hr_efc_actions hea
WHERE wiefc.efc_action_id = hea.efc_action_id
AND hea.efc_action_id = :specific_action_id;

Another common pattern is a comparative report between original NCU values and post-conversion Euro values in the base table, joining on INCIDENT_ID, to validate the accuracy of the EFC conversion process.

Related Objects

This table maintains defined relationships with other key EBS objects, primarily through foreign key constraints:

  • Primary Key: The table is uniquely identified by the PER_WORK_INCIDENT_EFC_PK constraint on (INCIDENT_ID, EFC_ACTION_ID).
  • Foreign Key (References): The EFC_ACTION_ID column is a foreign key referencing the HR_EFC_ACTIONS table. This links each snapshot to the master record of the EFC conversion event that created it.
  • Base Table Relationship: While not enforced by a database foreign key in this snapshot table, the INCIDENT_ID inherently relates to the primary key of the base transactional table, PER_WORK_INCIDENTS. The data in PER_WORK_INCIDENTS_EFC is a historical subset of columns from this base table.
The table's dependencies are minimal; it references HR_EFC_ACTIONS and is itself referenced by its associated index, PER_WORK_INCIDENTS_EFC#.