Results for “hr_efc_actions”

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

Overview

HR_EFC_ACTIONS is a PER (Human Resources) module table in the HR schema of Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. The table contains one row for each execution of the EFC conversion process or the delete _EFC table data process. EFC refers to the Euro/Funding Conversion (Enhanced Financial Conversions) utilities that were introduced for migration and reconciliation of large legislative or currency-driven payroll and HR data sets. Every run of the conversion or purge program is registered here, providing the audit anchor and grouping key for the entire family of _EFC staging and converted tables.

Functionally, the table behaves as a control or run-registry object. It records what type of action was performed, its progress and completion status, the business group context, sequence information, and timing metadata. From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is a hub. The surrogate primary key, EFC_ACTION_ID, is referenced by the majority of _EFC tables across HR, PER, PQH, PAY, and PQP product prefixes, which is precisely the behavior expected of a hub distributing its key to dependent satellites and links. This classification is a modeling suggestion rather than a physical constraint.

Key Information Stored

The table is documented with 14 columns. The most significant are:

• EFC_ACTION_ID — Surrogate primary key (index HR_EFC_ACTIONS_PK). It is the value propagated to every dependent _EFC table.
• MATCHING_EFC_ACTION_ID — Business-key candidate (unique index HR_EFC_ACTIONS_UK01). It links a conversion action to a corresponding delete or complementary action, supporting reconciliation between runs.
• EFC_ACTION_TYPE — Identifies whether the row represents an EFC conversion process run or a delete _EFC table data run.
• EFC_ACTION_STATUS — The final or current disposition of the action (for example, successful, failed, or pending).
• EFC_PROGRESS_STATUS — Milestone-level progress indicator for long-running conversions.
• BUSINESS_GROUP_ID — The HR business group (security organization) context in which the action was executed.
• ACTION_SEQUENCE — Ordering value that distinguishes multiple actions within the same logical processing cycle.
• START_DATE and FINISH_DATE — Execution timestamps used to derive runtime duration and overlap windows.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard EBS WHO columns providing the audit trail.

Note that the surrogate key (EFC_ACTION_ID) and the business-key candidate (MATCHING_EFC_ACTION_ID) are distinct concepts: the former uniquely identifies a run, the latter relates runs to one another.

Common Use Cases and Queries

The primary use cases are conversion monitoring, purge auditing, and downstream data lineage. Typical queries include:

• Current and recent runs: SELECT efc_action_id, efc_action_type, efc_action_status, efc_progress_status, start_date, finish_date FROM hr.hr_efc_actions WHERE business_group_id = :p_bg_id ORDER BY start_date DESC;
• Runtime and failure analysis: SELECT efc_action_id, efc_action_type, (finish_date - start_date) * 86400 AS elapsed_seconds FROM hr.hr_efc_actions WHERE efc_action_status = 'ERROR';
• Lineage for a specific staging row: join any _EFC table (for example, PQH_WORKSHEET_DETAILS_EFC) back to HR_EFC_ACTIONS on EFC_ACTION_ID to determine which conversion run produced the record.
• Paired action reconciliation: self-join on MATCHING_EFC_ACTION_ID to compare conversion and delete runs.

These patterns are especially relevant when users search for PQH_WORKSHEET_DETAILS_EFC, because that table carries EFC_ACTION_ID and therefore cannot be interpreted without the controlling row in HR_EFC_ACTIONS.

Related Objects

HR_EFC_ACTIONS is referenced by a large set of dependent _EFC tables through the EFC_ACTION_ID foreign key. The most significant include:

• PQH_WORKSHEET_DETAILS_EFC (EFC_ACTION_ID) — Budget worksheet detail rows for the conversion run.
• PQH_BUDGETS_EFC, PQH_BUDGET_DETAILS_EFC, PQH_BUDGET_PERIODS_EFC, PQH_BUDGET_VERSIONS_EFC, PQH_BUDGET_SETS_EFC — Public-sector budgeting conversion data referenced through the same key.
• PQH_WORKSHEET_PERIODS_EFC and PQH_WORKSHEET_BUDGET_SETS_EFC — Worksheet period and budget set staging rows.
• HR_EFC_PROCESS_COMPONENTS and HR_EFC_WORKERS — Component-level execution detail and worker population for each action.
• HR_EFC_ROUNDING_ERRORS and HR_EFC_CURRENCY_HISTORIES — Conversion error and currency history tracking tied to the run.
• PER_PAY_PROPOSALS_EFC and PER_PAY_PROPOSAL_COMPONENT_EFC — Payroll proposal conversion records.
• PER_BF_BALANCE_AMOUNTS_EFC, PER_BF_BALANCE_TYPES_EFC, and PER_BF_PAYMENT_DETAILS_EFC — Balance and payment detail conversion tables.
• HR_SUMMARY_EFC and HR_ORGANIZATION_INFORMATIO_EFC — Summary and organization information conversion output.

Any query or concurrent program that consumes an _EFC table should join HR_EFC_ACTIONS on EFC_ACTION_ID to filter by run status and action type, ensuring only completed and validated conversion runs are reported.