Search Results hr_efc_process_components




Overview
Explore in AI Chat

Overview

The HR_EFC_PROCESS_COMPONENTS table is a core technical table within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically supporting the Enterprise Fusion Conversion (EFC) process. In the context of EBS 12.1.1 and 12.2.2, this table functions as a log and control mechanism for data migration and conversion scripts. It holds a distinct record for each individual processing script executed during a conversion run, enabling administrators to track the execution, status, and lineage of data transformation components. Its primary role is to provide an auditable trail and a structural framework for managing complex, multi-step data conversion processes from legacy or external systems into the Oracle HRMS data model.

Key Information Stored

The table's structure is designed to uniquely identify and describe each processing component within a broader conversion action. The most critical columns include the system-generated surrogate key EFC_PROCESS_COMPONENT_ID, which serves as the table's primary identifier. The EFC_ACTION_ID column is a foreign key that links the component to a specific conversion run or action defined in the HR_EFC_ACTIONS table, establishing the execution context. The PROCESS_COMPONENT_NAME column stores the logical name of the specific processing script or module being executed. Together, these columns allow the system to maintain a precise, one-to-many relationship where a single conversion action (HR_EFC_ACTIONS) can consist of multiple sequential or parallel processing components.

Common Use Cases and Queries

This table is primarily accessed for auditing, troubleshooting, and monitoring conversion batch processes. Common scenarios include generating a runbook of all scripts executed for a specific conversion to verify completeness, diagnosing failures by identifying which specific component encountered an error, and analyzing performance by correlating component IDs with timing data in related worker tables. A typical query would join to the HR_EFC_ACTIONS table to list all components for a given action:

  • SELECT comp.efc_process_component_id, comp.process_component_name, act.action_name FROM hr_efc_process_components comp, hr_efc_actions act WHERE comp.efc_action_id = act.efc_action_id AND act.efc_action_id = :p_action_id ORDER BY comp.efc_process_component_id;

Another critical use case involves tracing data processed by a specific component by joining to the HR_EFC_WORKERS table, which references this table's primary key to associate individual worker records (e.g., employee conversions) with the component that processed them.

Related Objects

The HR_EFC_PROCESS_COMPONENTS table is centrally positioned within the EFC conversion data model, with documented foreign key relationships to and from other key control tables.

  • Referenced Table (Parent): HR_EFC_ACTIONS. The EFC_ACTION_ID column in HR_EFC_PROCESS_COMPONENTS is a foreign key to the HR_EFC_ACTIONS table, defining the parent conversion run.
  • Referencing Table (Child): HR_EFC_WORKERS. The HR_EFC_WORKERS table contains a foreign key column, EFC_PROCESS_COMPONENT_ID, which references the primary key (EFC_PROCESS_COMPONENT_ID) of this table. This links each processed worker record to the specific script that handled it.

These relationships are essential for constructing a complete audit trail from the high-level conversion action (HR_EFC_ACTIONS), through the individual processing scripts (HR_EFC_PROCESS_COMPONENTS), down to the granular records of converted entities (HR_EFC_WORKERS).

  • Table: HR_EFC_PROCESS_COMPONENTS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_PROCESS_COMPONENTS,  object_name:HR_EFC_PROCESS_COMPONENTS,  status:VALID,  product: PER - Human Resources ,  description: Holds one row for each processing script in each conversion processing run. ,  implementation_dba_data: HR.HR_EFC_PROCESS_COMPONENTS , 

  • Table: HR_EFC_PROCESS_COMPONENTS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_PROCESS_COMPONENTS,  object_name:HR_EFC_PROCESS_COMPONENTS,  status:VALID,  product: PER - Human Resources ,  description: Holds one row for each processing script in each conversion processing run. ,  implementation_dba_data: HR.HR_EFC_PROCESS_COMPONENTS , 

  • Table: HR_EFC_WORKERS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_WORKERS,  object_name:HR_EFC_WORKERS,  status:VALID,  product: PER - Human Resources ,  description: Holds one row for each parallel worker instance of a processing component. ,  implementation_dba_data: HR.HR_EFC_WORKERS , 

  • Table: HR_EFC_WORKERS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_WORKERS,  object_name:HR_EFC_WORKERS,  status:VALID,  product: PER - Human Resources ,  description: Holds one row for each parallel worker instance of a processing component. ,  implementation_dba_data: HR.HR_EFC_WORKERS , 

  • Table: HR_EFC_ACTIONS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ACTIONS,  object_name:HR_EFC_ACTIONS,  status:VALID,  product: PER - Human Resources ,  description: Contains one row for each time the EFC conversion process or delete _EFC table data process is run. ,  implementation_dba_data: HR.HR_EFC_ACTIONS , 

  • Table: HR_EFC_ACTIONS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ACTIONS,  object_name:HR_EFC_ACTIONS,  status:VALID,  product: PER - Human Resources ,  description: Contains one row for each time the EFC conversion process or delete _EFC table data process is run. ,  implementation_dba_data: HR.HR_EFC_ACTIONS ,