Payroll Register Report

The report provides an audit trail of a payroll run including hours, earnings, and deductions by payroll statutory unit (PSU) and tax reporting unit (TRU).

Use the report for verification, validation, and audit of your payroll calculations.

The US Simplified Payroll Cycle flow generates this report automatically, but you can run it manually.

To run this report:

  1. From My Client Groups, click Payroll.

  2. Click Submit a Flow.

  3. Select your US legislative data group (LDG).

  4. Search for and select Periodic Payroll Register Report.

Before You Start

You must have successfully completed archival of your periodic payroll data. This usually occurs during your payroll flow. For further info, see Archive Periodic Payroll Results for the US in the Help Center.

Report Parameters

Scope

Control the results of the report by setting its scope.

What you set

What it does

Summary

Provides a summary of the total amounts paid for the selected PSUs and TRUs for each payroll period, categorized by the balance category.

Detail

In addition to the Summary report, it includes the complete details for each employee. Use this for payroll balancing and reconciliation and to compare the payment values to previous periods.

For further info, see Oracle Cloud Human Capital Management for United States: Payroll Reconciliation (2086251.1) on My Oracle Support.

Process Start Date

Use this field to set the first effective date of the payroll process to include in the report. The report includes all processes with an effective date on or after this date.

Process End Date

Use this field to set the last effective date of the payroll process to include in the report. For payroll runs, this is its payroll run date. The report includes all processes with an effective date on or before this date.

Payroll

Use this field to limit the results to a single payroll definition. Leave blank to report all of them.

Consolidation Group

Use this field to limit the results to a consolidation group. Leave blank to report all of them.

For further info, see Consolidation Groups for the US in the Help Center.

Payroll Statutory Unit

Use this field to limit the results to a specific PSU. Leave blank to report all of them.

Tax Reporting Unit

Use this field to limit the results to a specific TRU. Leave blank to report all of them.

Person

Use this field to limit the results to a single person.

Payroll Relationship Group

Use this field to verify deduction balances for persons belonging to a specific payroll relationship group.

Note: Use the Object Groups task to define a payroll relationship group before you can use it here.

Person Page Break

If you select Yes, the report generates with details per person per page. This field isn't available for the Summary report.

Process Configuration Group

Use this field to verify deduction balances for persons belonging to a specific payroll relationship group.

Note: Use the Object Groups task to define a payroll relationship group before you can use it here.

Balances Reported

Use this field to run this report for payment balances, nonpayment balances, or both.

Select this

To do this

Payment only

Includes balances included in the payments process.

Nonpayment only

Includes balances that aren't included in the payments process.

Field is blank

Includes all balances.

This field is disabled if you set Latest Process YTD Total Only to Yes, and all balances are included in the report.

For further info, see Report Payment and Nonpayment Balances in the Help Center.

Report Category

If you have defined a report category for delivery of output in multiple formats, select it here.

For further info, see Delivery Options for Extract-Based Payroll Reports in the Help Center.

Run Mode

Use to control whether the report retains or discards the transient data it creates when producing the output file.

Select Debug only to investigate an issue with the report output or when instructed by Oracle Support.

The Normal option discards the temporary data.

Display All Hours

Select Yes to include hours from supplemental earnings and other element classifications. Select No to include only hours from regular or standard earnings and absence earnings.

For further info, see Display All Hours in Payroll Reports in the Help Center.

Report Results

The report provides payroll details for matching persons, filtered by the specified time frame and the selected parameters. The results of the report depend on the scope value you selected when you ran the report.

Report name

What it contains

Summary

Provides sections on:

  • Report parameters and sort order

  • Balance categories

  • Balances

  • Balances by PSU and TRU

  • Balances by payroll and pay period

Detail

Provides sections on:

  • Report parameters and sort order

  • Balance categories

  • Balances

  • Balances by PSU and TRU

  • Balance details for a person

Use this for payroll balancing and reconciliation and to compare the payment values to previous periods.

For further info, see Oracle Cloud Human Capital Management for United States: Payroll Reconciliation (2086251.1) on My Oracle Support.