Search Results pay_payroll_actions




Overview
Explore in AI Chat

Overview

The PAY_PAYROLL_ACTIONS table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It functions as the master control table for recording and tracking every payroll process execution. Each row represents a discrete instance of a payroll activity, such as a payroll run, a prepayments process, or a cost calculation. The table assigns a unique identifier (PAYROLL_ACTION_ID) to each process, which is then used throughout the payroll schema to link generated results—like run balances, payment instructions, and costing details—back to the specific process that created them. Its role is fundamental to the auditability, traceability, and integrity of payroll processing in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is PAYROLL_ACTION_ID, which uniquely identifies each process. Critical foreign key columns define the scope and parameters of the payroll action. These include BUSINESS_GROUP_ID for the organizational context, TIME_PERIOD_ID to link to the specific payroll period being processed, and CONSOLIDATION_SET_ID for grouping multiple runs. The table also stores IDs for sets that limit processing scope: ASSIGNMENT_SET_ID for employee assignments, ELEMENT_SET_ID for payroll elements, and BACKPAY_SET_ID for retroactive pay calculations. Additional columns typically capture the action type (e.g., 'R' for Run, 'P' for Prepayments), status, effective date, and the date the action was performed, providing a complete operational record.

Common Use Cases and Queries

A primary use case is auditing and reporting on payroll process history. For instance, to list all completed payroll runs for a specific business group and time period, a query would join PAY_PAYROLL_ACTIONS with PER_TIME_PERIODS. Another critical scenario is troubleshooting or analyzing results, where the PAYROLL_ACTION_ID from this table is used to retrieve corresponding employee-level results from tables like PAY_RUN_BALANCES. Technical consultants often query this table to find the controlling action ID for a given payroll run before executing data fixes or detailed analyses. A sample query pattern is:

  • SELECT payroll_action_id, action_type, effective_date
  • FROM pay_payroll_actions
  • WHERE business_group_id = &bg_id
  • AND action_type = 'R'
  • AND time_period_id = (SELECT time_period_id FROM per_time_periods WHERE period_name = 'JAN-2024');

Related Objects

Based on the documented foreign key relationships, PAY_PAYROLL_ACTIONS has extensive dependencies. It is the parent table for several key payroll result tables, meaning its PAYROLL_ACTION_ID column is referenced as a foreign key in:

Conversely, it references numerous setup and control tables as a child table via its foreign keys. Key documented parent tables include: