Search Results per_bf_payroll_runs




Overview
Explore in AI Chat

Overview

The table PER_BF_PAYROLL_RUNS is a core data object within the Oracle E-Business Suite Human Resources (PER) module for versions 12.1.1 and 12.2.2. As indicated by its description, it serves as the master repository for tracking payroll runs that have been processed by a third-party payroll provider. This table is integral to the "Bureau Feeds" or "Third-Party Payroll Integration" functionality, enabling the EBS system to maintain a record of payroll processing events that occur externally. Its primary role is to provide a reference point for reconciling externally processed payroll data with internal employee and assignment records, ensuring data integrity across the integrated systems.

Key Information Stored

The table's structure is designed to uniquely identify and describe each external payroll processing event. The primary technical identifier is the PAYROLL_RUN_ID, a system-generated primary key. For business process identification, the table uses the combination of PAYROLL_IDENTIFIER and BUSINESS_GROUP_ID, which together form a unique key (PER_BF_PAYROLL_RUNS_UK1). This design allows an organization to track multiple payroll runs (potentially from different external providers or for different periods) within a specific business group. The BUSINESS_GROUP_ID itself is a foreign key linking the payroll run to the organization's master data in HR_ALL_ORGANIZATION_UNITS.

Common Use Cases and Queries

A primary use case is generating audit and reconciliation reports between Oracle EBS and the third-party payroll system. Administrators can query this table to list all external payroll runs processed for a given business group or within a specific date range. For instance, a common query would join PER_BF_PAYROLL_RUNS with PER_BF_PROCESSED_ASSIGNMENTS to retrieve a detailed list of all employee assignments included in a particular external payroll run, which is essential for variance analysis and error correction. Sample SQL to find all payroll runs for a business group would be: SELECT payroll_identifier, payroll_run_id FROM hr.per_bf_payroll_runs WHERE business_group_id = &bg_id ORDER BY payroll_run_id; This table is also critical for downstream processes that depend on knowing which payroll period has been finalized externally.

Related Objects

PER_BF_PAYROLL_RUNS has defined relationships with several other key tables in the HR schema, as per the provided metadata:

  • HR_ALL_ORGANIZATION_UNITS: The table is linked via the BUSINESS_GROUP_ID foreign key column. This join provides the organizational context for the payroll run.
  • PER_BF_PROCESSED_ASSIGNMENTS: This is a critical child table. The PAYROLL_RUN_ID in PER_BF_PAYROLL_RUNS is referenced as a foreign key (PER_BF_PROCESSED_ASSIGNMENTS.PAYROLL_RUN_ID) in this table. This relationship allows the system to store and track which specific employee assignments (from PER_ALL_ASSIGNMENTS_F) were included and processed in each external payroll run, forming the detailed link between the payroll event and the employee data.