Search Results hr_efc_rounding_errors




Overview
Explore in AI Chat

Overview

The HR_EFC_ROUNDING_ERRORS table is a technical audit table within the Oracle E-Business Suite Human Resources (PER) module, specifically for releases 12.1.1 and 12.2.2. Its primary role is to log instances where the system automatically makes adjustments to correct rounding errors that occur during the Euro Functional Currency (EFC) conversion process. When monetary values are converted between currencies, rounding discrepancies can accumulate, potentially causing imbalances in financial reports. This table provides a traceable audit trail for each corrective adjustment, ensuring data integrity and transparency for compliance and troubleshooting purposes.

Key Information Stored

The table's structure is designed to precisely identify the source and nature of each rounding error correction. Its primary and unique keys enforce data integrity for these audit records. The most critical columns include:

  • EFC_ROUNDING_ERROR_ID: The primary key, a unique identifier for each rounding error adjustment record.
  • EFC_ACTION_ID: A foreign key linking to the HR_EFC_ACTIONS table, which provides context on the broader EFC conversion run that triggered the adjustment.
  • SOURCE_ID: The identifier (typically a primary key value) of the specific row in the source table where the data was adjusted.
  • SOURCE_TABLE: The name of the application table (e.g., a payroll or costing table) where the original data resided and was corrected.
  • SOURCE_COLUMN: The specific column within the SOURCE_TABLE that held the monetary value requiring the rounding adjustment.

Common Use Cases and Queries

This table is primarily used for audit reviews, reconciliation, and diagnosing issues post-EFC conversion. A common scenario involves investigating the total impact of rounding adjustments for a specific conversion run. A sample query to achieve this would join to the HR_EFC_ACTIONS table to filter by a particular action or date range. Another critical use case is tracing adjustments back to their exact source record for validation, using the SOURCE_TABLE, SOURCE_ID, and SOURCE_COLUMN values to directly query the original application data. System administrators may also run periodic reports to monitor the volume and magnitude of rounding corrections as part of financial controls.

Related Objects

The HR_EFC_ROUNDING_ERRORS table has a direct and essential relationship with the HR_EFC_ACTIONS table via the EFC_ACTION_ID foreign key. HR_EFC_ACTIONS serves as the parent table, logging each execution of the EFC conversion process, thereby providing the overarching context (such as the conversion date and parameters) for all rounding adjustments logged in HR_EFC_ROUNDING_ERRORS. The SOURCE_TABLE and SOURCE_COLUMN values will reference various core HR and payroll tables where monetary data is stored, such as PAY_COSTS, PAY_RUN_RESULTS, or similar transaction tables, forming a link from the audit log back to the adjusted business data.

  • Table: HR_EFC_ROUNDING_ERRORS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ROUNDING_ERRORS,  object_name:HR_EFC_ROUNDING_ERRORS,  status:VALID,  product: PER - Human Resources ,  description: Holds one row for each time a rounding error adjustment has been made. ,  implementation_dba_data: HR.HR_EFC_ROUNDING_ERRORS , 

  • Table: HR_EFC_ROUNDING_ERRORS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ROUNDING_ERRORS,  object_name:HR_EFC_ROUNDING_ERRORS,  status:VALID,  product: PER - Human Resources ,  description: Holds one row for each time a rounding error adjustment has been made. ,  implementation_dba_data: HR.HR_EFC_ROUNDING_ERRORS , 

  • 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 , 

  • 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 ,