Results for “pay_payroll_actions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_PAYROLL_ACTIONS is the central transaction table in the Oracle E-Business Suite Payroll (PAY) module. Owned by the HR schema and validated in both EBS 12.1.1 and 12.2.2, it holds information about every payroll process executed within the enterprise, including payroll runs, QuickPay runs, reversals, balance adjustments, prepayments, and third-party payment processes. Each row represents a discrete payroll action, capturing the configuration, status, and timing of a single execution event.

From a dimensional modeling perspective, the documented foreign-key structure suggests a satellite-leaning classification. The table is anchored by the surrogate primary key PAYROLL_ACTION_ID but carries numerous descriptive and contextual attributes—status, run type, dates, and report parameters—that behave like satellite payload rather than strict hub keys. It nonetheless functions as a hub in practice, because a broad set of dependent tables (payroll run results, chunk status, assignment actions, and cost allocation output) reference it by PAYROLL_ACTION_ID.

Key Information Stored

The primary key is PAYROLL_ACTION_ID, generated through the PAY_PAYROLL_ACTIONS_PK unique index. This surrogate key is the join point for virtually all payroll run results and cost allocation data. Business-key candidates are limited; the documented unique indexes include PAY_PAYROLL_ACTIONS_PK and a system LOB index (SYS_IL0000042506C00071$$), confirming that PAYROLL_ACTION_ID is the operative identifier.

The most significant columns include:

• ACTION_TYPE — classifies the process (e.g., payroll run, reversal, balance adjustment).
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, defining the enterprise group context.
• PAYROLL_ID, PAYROLL_TYPE_ID, RUN_TYPE_ID — identify the payroll, its type, and the specific run type executed.
• ACTION_STATUS and ACTION_POPULATION_STATUS — track process and population progress.
• EFFECTIVE_DATE, START_DATE, END_DATE, DATE_EARNED — drive the accounting and earnings period of the run.
• TIME_PERIOD_ID — foreign key to PER_TIME_PERIODS, tying the action to a payroll period.
• CONSOLIDATION_SET_ID, ELEMENT_SET_ID, ASSIGNMENT_SET_ID, BACKPAY_SET_ID, BALANCE_SET_ID — define the population and processing rules applied.
• PAYMENT_TYPE_ID, ORG_PAYMENT_METHOD_ID — specify payment method and instrument handling for prepayments.
• REQUEST_ID — links the action to its concurrent request for traceability.
• COST_ALLOCATION_KEYFLEX_ID — the cost allocation flexfield used to distribute run results.
• TARGET_PAYROLL_ACTION_ID — references the source action for reversals and re-runs.
• LAST_UPDATE_DATE, CREATED_BY, OBJECT_VERSION_NUMBER — standard audit and optimistic-locking columns.

Common Use Cases and Queries

Typical usage centres on identifying payroll runs, auditing status, and tracing downstream results. A frequent pattern joins this table to PAY_ASSIGNMENT_ACTIONS and PAY_RUN_BALANCES to report run-level totals:

• Locating all completed payroll runs for a business group and period: filter on ACTION_TYPE, ACTION_STATUS, and TIME_PERIOD_ID.
• Reconciling costing entries by joining COST_ALLOCATION_KEYFLEX_ID to PAY_COST_ALLOCATION_KEYFLEX.
• Tracing reversal linkage via TARGET_PAYROLL_ACTION_ID.
• Monitoring chunk-level progress through PAY_CHUNK_STATUS and PAY_TEMP_OBJECT_ACTIONS.
• Auditing concurrent program execution by linking REQUEST_ID to FND_CONCURRENT_REQUESTS.

A representative query returns run headers by period. Because ACTION_STATUS values are internal codes, joins to PAY_LOOKUPS or the seeded action-type lookup are recommended for readable output.

Related Objects

The table is heavily referenced. The most significant dependents and parents include:

• PAY_ASSIGNMENT_ACTIONS.PAYROLL_ACTION_ID — assignment-level results of each run.
• PAY_RUN_BALANCES.PAYROLL_ACTION_ID — balance values produced by the action.
• PAY_CHUNK_STATUS.PAYROLL_ACTION_ID — processing chunk progress.
• PAY_POPULATION_RANGES.PAYROLL_ACTION_ID — population selection ranges.
• PAY_CONTRIBUTING_PAYMENTS, PAY_PRE_PAYMENTS — payment and prepayment output.
• PSP_PAYROLL_CONTROLS, PSP_ENC_LINES, PSP_ENC_SUMMARY_LINES — third-party payment controls and encumbrance lines.
• PAY_REPORT_TOTALS, PAY_BALANCE_BATCH_LINES, PAY_TEMP_OBJECT_ACTIONS — reporting and batching artifacts.

Parent references include HR_ALL_ORGANIZATION_UNITS, PER_TIME_PERIODS, PAY_CONSOLIDATION_SETS, PAY_ELEMENT_SETS, PAY_ASSIGNMENT_SETS, PAY_PAYMENT_TYPES, PAY_BACKPAY_SETS, PAY_BALANCE_SETS, and PAY_COST_ALLOCATION_KEYFLEX. These relationships make PAY_PAYROLL_ACTIONS the anchor for payroll run analysis and cost allocation reporting across the EBS Payroll module.