Periodic Payroll Activity Report for the US
Run the Periodic Payroll Activity Report for payroll verification, validation, and auditing purposes. Use it to view and reconcile the payroll balances info with the data archived by the periodic payroll archive process.
This report provides a high-level summary of all relationship-level balances across various balance categories, payroll statutory units (PSUs), and tax reporting units (TRUs). Use the Periodic Payroll Activity report to verify:
-
Balance adjustments for all employees within a given time period
-
Gross earning calculations
-
Reversals within a given time period
-
Balance initialization for a selected employee or all employees for a given time period
-
Payroll or QuickPay runs for a given time period
To run this report:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group.
-
Search for and select Periodic Payroll Activity Report.
Report Parameters
The parameter values determine which records to include in the report. For example, run this report for a specific consolidation group or payroll relationship group. You must predefine these groups before you can use them.
Scope
Control the results of the report by setting its scope.
What you set |
What it does |
---|---|
Summary |
Provides a summary of payroll relationship-level balances across all workers by balance category, balance type, TRU, and payroll activity. |
Detail |
Provides the detail of each payroll relationship-level balance for every worker in every payroll activity. |
Process Start Date
Select the first effective date of the payroll process to include in the report. Reports all processes with an effective date equal to or later than this date.
Process End Date
Select the last effective date of the payroll process to include in the report. Reports all processes with an effective date equal to or earlier than this date.
For payroll runs, the process end date is the payroll run date.
For offset payrolls, the effective date of the payroll or QuickPay run could be after the end date of the payroll period. In such cases, make sure your process end date is on or after the effective date of the process you want to include.
Payroll
Select the name of the payroll.
Process Type
The options that you can select are:
-
Balance adjustment
-
Balance initialization
-
Calculate gross earning
-
Payroll calculation
-
QuickPay
-
Reversal
Consolidation Group
Use this field to run the report against a consolidation group. If you don't select a value, the report uses the default consolidation group assigned to the payroll.
For further info, see Consolidation Groups for the US in the Help Center.
Payroll Statutory Unit
To include all employees in a PSU in your report results, select it here.
Leave blank to run against all PSUs.
Tax Reporting Unit
To include all employees in a TRU in your report results, select it here.
Leave blank to run against all TRUs.
Location
Use this field to view the balance results for employees who have at least one assignment for the selected location. The balance values might not correspond to the location parameter only. It is also dependent on the dimensions and the other associated contexts.
Department
To include all employees in a specific department, select it here.
Leave blank to run against all departments.
Payroll Relationship Group
Select the payroll relationship group name, if you have defined one. Payroll relationship groups limit the persons processed for payroll, data entry, and reporting. For example, you can create a group to process the report for terminated employees.
Use the Object Groups task to define the payroll relationship group before you can select it here.
Person
Select the person number to view the balances of an individual employee.
Leave blank to generate the report for all active employees. This field is disabled for the summary report.
Person Page Break
Select Yes to generate the report with details per person per page. This field is disabled for the summary report.
Hide Records with Zero Value
If you select Yes, balances with 0 values aren't displayed in the report.
Process Configuration Group
Select the process configuration group if you have defined one. Use a process configuration group to provide sets of processing parameters, primarily related to logging and performance. If you don't select a process configuration group, the report uses the parameters in the default group for the selected payroll.
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. |
Blank |
Includes all balances. |
This field is disabled if you set Latest Process YTD Total Only to Yes. This includes all balances 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 for the US 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. If you select No, the report includes 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 details of payroll balance results 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.
You can view the archived info in the Payroll Register.
Report name |
What it contains |
---|---|
Summary Report |
The summary report has these sections:
This report is included when you set Latest Process YTD Total Only to No or left blank. It returns one of the following, depending on the Balances Reported parameter.
|
Detail Report |
The detail report includes the three summary sections, followed by a fourth for employee-level balances. It's separated by payment and nonpayment balances.
|
- Configure Information Balances in the Payroll Balance Report
- Dynamic Payroll Relationship Group Support for the Periodic Payroll Activity Report for the US
- Latest Process Year-to-Date and Periodic Balances Reporting
- Report Payment and Nonpayment Balances
- Year-to-Date Balances in Reports
- Payroll Activity Reports