The 1099R Exception Register identifies employees who have negative box 1 totals on the Form 1099-R, or have a zero box 1 total on the Form 1099-R but have other negative 1099-R box totals. This report lists all balances reported on the 1099R Information Return.
Run the 1099R Exception Register for a single GRE or an assignment set (but not a dynamic assignment set). If you run this report for an assignment set, only those employees in the selected GRE appear on the report. You can configure the 1099R Exception Register to display the 1099-R box totals for all selected employees in the report, or you can display 1099-R box details for individual employees in the report, as well as the report totals.
The 1099R magnetic report or paper 1099R does not include employees identified by the 1099R Exception Register. You have to manually generate 1099-Rs for these employees and amend the magnetic files.
Note: You must run the Year End Pre-Process for the GRE before you can run the 1099R Exception Register report.
Organize the 1099R Exception Register according to user-defined criteria or sort options. Oracle Payroll does not require that you use sort options to generate your 1099R Exception Register, but they are the best way to customize the report to your specific needs. You sort the report by any three of the following options:
Employee Name
Location
Organization
Social Security Number
Note: You cannot choose to sort by Social Security Number and then Employee Name. If you select Social Security Number as a sort option, Employee Name does not appear in the List of Values for the remaining sort options.
Example
The following is an example of how to use sort options to customize the 1099R Exception Register.
To create a 1099R Exception Register sorted by Organization, Location, and Employee Name:
Enter Organization into the Sort Option One field.
Enter Location into the Sort Option Two field.
Enter Employee Name into the Sort Option Three field.
Using these Sort Options, Oracle Payroll generates the report listing each employee by location within each organization for the selected GRE.
Note: The sort options are nested. Using the previous example, if you change Sort Option Two from Location to Employee Name, Sort Option Three automatically clears.
When printed, the 1099R Exception Register inserts a page break between each selected sort option, with the exception of Employee Name or Social Security Number.
Example
If you choose Organization, Location, and Employee Name as sort options, the report contains a page break every time the Organization or the Location changes. The report does not have page breaks between the individual employees.
The following parameters exist for the 1099R Exception Register:
| Reporting Year (required) | Enter the four digit calendar year. |
| Government Reporting Entity (required) | Select the GRE. Only GREs that you have archived using the Year End Pre-Process for the specified Reporting Year appear in the list. GREs for retirees do not appear in the list. |
| Totals Only (required) | Select Yes to show only the W-2 box totals for all selected employees in the report ; individual employees are not included in the report. Select No to show 1099-R box totals in the report for selected individual employees, as well as the totals for these employees. |
| Assignment Set (optional) | Select an assignment set to generate an exception report for only those employees.
Note: This report does not support dynamic assignment sets. |
| Sort Options (optional) | Use the three fields for sort options to sort your report results. You cannot select Sort Options if you have set the Totals Only parameter to Yes. If you do not select any sort options, the report uses Employee Name as the default. |
You print the 1099R Exception Register using the selected parameters in landscape format to fit on 8.5" x 11" paper.
The values for boxes 1 through 6 of form 1099-R always appear on the report. The values for all other 1099-R boxes appear on the report only if they are non-zero values. This report format is the same as the 1099R Register report.
The report then lists the following information:
Total Employees Successfully Processed
Total Employees who receive a printed 1099-R.
Total Employees with Zero or Negative Wages (box 1)
Total Employees Errored in Year End Pre-Process
Total Employees Marked for Retry of Year End Pre-Process