Search Results hr_efc_actions_pk




Overview
Explore in AI Chat

Overview

The HR_EFC_ACTIONS table is a core audit and control table within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for the Euro Functional Currency (EFC) feature. It serves as a master log, recording each execution of the EFC conversion process or the delete EFC table data process. Its primary role is to track the lifecycle of currency conversion operations, enabling administrators to monitor process status, sequence, and history. This table is critical for maintaining data integrity during and after the conversion of transactional data from a legacy currency to the Euro, ensuring actions are traceable and auditable across releases 12.1.1 and 12.2.2.

Key Information Stored

The table's columns capture the identity, type, status, and context of each EFC action. The surrogate primary key, EFC_ACTION_ID, uniquely identifies each run. Critical descriptive columns include EFC_ACTION_TYPE and EFC_ACTION_STATUS, which are based on lookup types to categorize the process (e.g., conversion, deletion) and its outcome. The EFC_PROGRESS_STATUS provides granular state tracking. The BUSINESS_GROUP_ID and ACTION_SEQUENCE columns define the organizational scope and the order of operations for that business group. Temporal control is maintained via START_DATE and FINISH_DATE. A self-referencing relationship is established through MATCHING_EFC_ACTION_ID, which links a deletion action record back to its original conversion record. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the audit trail.

Common Use Cases and Queries

Primary use cases involve auditing conversion history and troubleshooting failed processes. System administrators query this table to verify the completion status of a conversion job, identify the sequence of actions for a specific business group, or determine if a deletion has been performed. A common diagnostic query checks for incomplete or failed actions:

SELECT efc_action_id, efc_action_type, efc_action_status, efc_progress_status, business_group_id, start_date, finish_date FROM hr_efc_actions WHERE finish_date IS NULL OR efc_action_status != 'COMPLETED' ORDER BY start_date DESC;

To analyze the full lifecycle, a self-join using MATCHING_EFC_ACTION_ID can correlate conversion and deletion events:

SELECT conv.efc_action_id AS conv_id, conv.start_date AS conv_start, del.efc_action_id AS del_id, del.start_date AS del_start FROM hr_efc_actions conv LEFT JOIN hr_efc_actions del ON conv.efc_action_id = del.matching_efc_action_id WHERE conv.efc_action_type = 'CONVERSION';

Related Objects

The HR_EFC_ACTIONS table is a central parent table, with its primary key (EFC_ACTION_ID) referenced by a wide array of EFC staging and history tables. This relationship ensures every piece of converted data can be traced to a specific conversion action. Key documented foreign key relationships include:

These dependencies underscore the table's role as the foundational control point for all EFC-related data modifications across HR, Payroll, and Budgeting modules.