Payment Register Report

Use this report for the verification, reconciliation, and audit of payment distributions.

Note: This report doesn't include payments made to third parties. Such payments are listed on the Third-Party Payment Register.

You can generate the report manually or as a part of the payroll process.

To run this report:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your legislative data group (LDG).

4. Search for and select Payment 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 in the Help Center.

Report Parameters

Scope

Control the results of the report by specifying its scope.

What you set	What it does
Summary	Provides a summary of the total amounts paid by payment category, payment type, status, and payment method.
Detail	In addition to the Summary report, it includes the complete details for each employee. Use this validate payments for each employee, including the payment amount, bank, and check info.

Process Start Date

Use this field to specify 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 specify 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.

Payment Process

Use this field to limit the results to a specific payroll or QuickPay run.

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.

Payroll Statutory Unit

Use this field to limit the results to a specific payroll statutory unit (PSU).

Leave blank to report all of them.

Tax Reporting Unit

Use this field to limit the results to a specific tax reporting unit (TRU).

Leave blank to report all of them.

Payroll Relationship Group

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

Person

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

Payment Type

Use this field to limit the results to a specific payment type.

Leave blank to report all of them.

Payment Method

Use this field to limit the results to a specific payment type.

Leave blank to report all of them.

Location

Use this field to limit the results to a specific location.

Payment Status

Select the status you want to report on.

What you select	What it means
Canceled and can't be reissued	You have marked the payment as Void, rolled back the prepayment process, and reversed the calculation of the payroll run results.
Paid	You processed and issued the payment without error.
Paid externally	You processed the payment was processed but generated it externally. This includes hand-written checks for terminated employees.
Unpaid	You processed the payment was processed, but it was incomplete or experienced errors during payment.
Void	You marked the payment as Void, but it's eligible for reissue. This includes replacing a lost payroll check.

Note: You can configure these statuses in the PAY_STATUS lookup. For further info, see Payment Statuses in the Help Center.

Leave blank to report all of them.

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.

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 the Debug option only to investigate an issue with the report output or when instructed by Oracle Support.

The Normal option discards the temporary transient data.

Report Results

The report provides details of the selected payment status for matching persons, filtered by the specified time frame and other parameters.

Report name	What it contains
Summary	Provides sections on: Report parameters and sort order Summary of payments
Detail	Provides sections on: Report parameters and sort order Summary of payments Details of payments Use this validate payments for each employee, including the payment amount, bank, and check info.