Search Results per_pay_proposal_compon_efc_pk

Overview

The table PER_PAY_PROPOSAL_COMPONENT_EFC is a core data object within the Oracle E-Business Suite (EBS) Payroll module (PAY). It functions as a junction or intersection table, establishing and managing the relationship between salary proposal components and specific EFC (Element Entry, FastFormula, and Compensation Workbench) actions. Its primary role is to define which compensation components are subject to which automated payroll calculation or validation actions during the salary proposal and change process. This table is critical for ensuring that compensation changes initiated in HR systems are correctly processed and validated by the underlying payroll rules engine in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical foreign key columns. The COMPONENT_ID column references a unique salary proposal component, such as a salary, bonus, or allowance element. The EFC_ACTION_ID column references a specific EFC action that must be executed for that component. The table does not store transactional data like amounts or dates; instead, it stores the essential configuration mapping that links compensation components to their required payroll processing logic. This mapping ensures that when a component is modified in a proposal, the associated actions for formula calculation, element entry, or workbench validation are triggered.

Common Use Cases and Queries

This table is primarily accessed for configuration validation, troubleshooting payroll proposal errors, and generating audit reports on the setup of compensation workflows. A common operational query involves listing all EFC actions associated with a specific salary component to verify setup completeness. For example:

• Configuration Audit: SELECT component_id, efc_action_id FROM hr.per_pay_proposal_component_efc WHERE component_id = <ID>;
• Impact Analysis: Identifying all components affected by a particular EFC action change, which is crucial during system upgrades or patch applications.
• Troubleshooting: When a salary proposal fails to process or validate correctly, administrators may query this table to ensure the necessary action mappings exist for the components being changed.

Related Objects

As a junction table, PER_PAY_PROPOSAL_COMPONENT_EFC has defined foreign key relationships that link two key entities in the payroll proposal architecture. The provided metadata specifies its primary key constraint (PER_PAY_PROPOSAL_COMPON_EFC_PK), which enforces the uniqueness of the (COMPONENT_ID, EFC_ACTION_ID) pair. This implies foreign key constraints referencing the primary keys of the parent tables for these columns.

• Parent Table for COMPONENT_ID: Likely PER_PAY_PROPOSAL_COMPONENTS or a similar table that defines valid salary components.
• Parent Table for EFC_ACTION_ID: Likely a table such as PER_EFC_ACTIONS or PAY_EFC_ACTIONS that catalogues the available payroll calculation and validation actions.

This table is integral to the workflow where data flows from the Compensation Workbench or HR forms (PER_PAY_PROPOSALS) through defined components and their associated actions, ultimately driving the creation or update of element entries in the payroll tables.