Search Results efc_worker_id

Overview

The HR_EFC_WORKERS table is a core technical table within the Oracle E-Business Suite Human Resources (PER) module, specifically designed to support parallel processing. It functions as a registry for managing concurrent execution threads, or "workers," for a given processing component. Each row in this table represents a single, distinct worker instance spawned to execute a portion of a larger, parallelized task. Its primary role is to enable scalable and efficient batch processing within HR, allowing long-running operations—such as mass payroll calculations, benefits processing, or data conversions—to be divided and processed simultaneously across multiple worker processes. This architecture is critical for performance in large-scale EBS implementations, particularly in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is focused on worker identification, status, and relationship management. The primary identifier is the EFC_WORKER_ID, a system-generated unique key. Crucially, each worker is linked to its parent processing component via the EFC_PROCESS_COMPONENT_ID foreign key and to a specific action via EFC_ACTION_ID. The WORKER_NUMBER column provides a sequential identifier for the worker within its parent component, enabling ordered execution or result aggregation. While the provided metadata does not list all columns, typical supporting columns in such a table would include status flags (e.g., PENDING, RUNNING, COMPLETE, ERROR), timestamps for start and completion, and potentially a reference to the session or process ID.

Common Use Cases and Queries

This table is primarily accessed for monitoring, troubleshooting, and managing parallel processes. System administrators and technical consultants use it to assess the health and progress of batch jobs. Common queries include checking the status of all workers for a specific process component to identify stalled or failed threads, or summarizing completion rates. For example, to monitor active workers for a specific component, a query might be: SELECT WORKER_NUMBER, STATUS, START_DATE FROM HR_EFC_WORKERS WHERE EFC_PROCESS_COMPONENT_ID = :p_comp_id ORDER BY WORKER_NUMBER;. Another critical use case is auditing and cleanup; the table's relationship with HR_EFC_WORKER_AUDITS allows for a historical trace of worker execution, which is essential for diagnosing failures or performance bottlenecks in complex HR batch operations.

Related Objects

The HR_EFC_WORKERS table sits at the center of a small network of related technical tables that manage the parallel processing framework.

• HR_EFC_PROCESS_COMPONENTS: The parent table. HR_EFC_WORKERS.EFC_PROCESS_COMPONENT_ID is a foreign key to this table, defining which high-level component the worker belongs to.
• HR_EFC_ACTIONS: Provides context for the specific action being performed. HR_EFC_WORKERS.EFC_ACTION_ID is a foreign key to this table.
• HR_EFC_WORKER_AUDITS: A child table that logs detailed audit trails for each worker. It references HR_EFC_WORKERS via the foreign key column HR_EFC_WORKER_AUDITS.EFC_WORKER_ID.

These relationships form a hierarchical model: a Process Component contains one or more Workers, each associated with an Action, and each Worker can have multiple Audit records.