Search Results pqh_budget_details_efc

Overview

The HR_EFC_ACTIONS table is a core audit and control table within the Oracle E-Business Suite Human Resources (PER) module for versions 12.1.1 and 12.2.2. It is central to the Enterprise Fusion Currency (EFC) functionality, which handles the conversion of monetary data from transaction currencies to a global reporting currency. The table serves as a master log, containing one record for each execution of either the EFC conversion process or the process to purge historical EFC data. Each row acts as a unique identifier for a specific conversion or deletion run, enabling data lineage, audit trails, and the grouping of all converted records generated during that specific operation.

Key Information Stored

While the provided metadata does not list all columns, the primary and unique keys define its critical structure. The EFC_ACTION_ID column is the system-generated primary key (PK: HR_EFC_ACTIONS_PK) that uniquely identifies each process run. The MATCHING_EFC_ACTION_ID column forms a unique key (UK01), which is crucial for linking related conversion actions, such as matching an original conversion with a subsequent correction or deletion run. Typical columns in such an audit table would also include timestamps for process start and completion, the user who submitted the request, the process type (e.g., 'CONVERSION', 'DELETE'), the effective date for conversions, and status flags indicating success or error.

Common Use Cases and Queries

The primary use case is auditing and troubleshooting the EFC conversion process. Administrators query this table to understand the history of currency conversions, identify when specific reporting currency data was generated, and diagnose failed processes. A common query pattern involves joining HR_EFC_ACTIONS to one of its many detail tables to filter converted data by a specific run. For example, to find all budget details converted in a particular action, one would join to PQH_BUDGET_DETAILS_EFC (the table referenced in the user's search) or similar EFC staging tables. A sample query to audit recent conversion runs would be: SELECT efc_action_id, action_type, effective_date, requested_by, status FROM hr_efc_actions WHERE TRUNC(creation_date) = SYSDATE ORDER BY creation_date DESC;. This table is also essential for purging operations, as the MATCHING_EFC_ACTION_ID helps ensure data integrity when deleting records from a prior conversion.

Related Objects

The HR_EFC_ACTIONS table has a foundational relationship with numerous EFC staging tables across the HR and Payroll modules, as evidenced by its extensive foreign key relationships. Each of these detail tables stores the currency-converted data and references the master action that created it via the EFC_ACTION_ID column. Key related objects include:

• HR_EFC_PROCESS_COMPONENTS and HR_EFC_WORKERS: For process execution details.
• HR_SUMMARY_EFC and PER_ASSIGNMENT_BUDGET_VALU_EFC: For summarized and assignment-level budget data.
• PER_PAY_PROPOSALS_EFC and PER_PAY_PROPOSAL_COMPONENT_EFC: For compensation data.
• PER_BUDGET_VALUES_EFC and PQH_BDGT_POOL_REALLOCTIONS_EFC: For budget pool and allocation data.
• PER_ABSENCE_ATTENDANCES_EFC, PER_PERIODS_OF_SERVICE_EFC, and PER_WORK_INCIDENTS_EFC: For various HR transactional data.

This structure ensures every converted record can be traced back to its source conversion batch, maintaining critical financial auditability.