To Run the Employees Not Paid Request Set:The Employees Not Paid Request Set combines three reports to help you identify employees who have not received a paycheck in a time period you specify:
Employee Assignments Not Processed
Employees Without Payrolls
Payroll Message
To Run the Employees Not Paid Request Set:Open the Submit Processes and Reports window.
Choose Request Set and press OK.
Enter or choose Employees Not Paid in the Request Set field.
In the Program list, click in the Parameters field of each of the reports, and enter the parameters for each. For details, see the Employee Assignments Not Processed and Employees Without Payrolls report sections below or "Running the Payroll Message Report" in the Running Your Payroll Using Oracle HRMS guide.
Note: You need to enter the beginning and ending dates only once, because they automatically propagate from the Employee Assignments Not Processed parameters.
Enter any desired options, and press Submit.
The Employee Assignments Not Processed report lists, for a given payroll or consolidation set, the employees who have not received regular payments to which they are entitled. This report covers primary assignments only.
Optionally, you can run the Employee Assignments Not Processed report for a single GRE, organization, or location.
You must enter either a payroll or a consolidation set in the Parameters window. If you want to run this report specifically for a consolidation set, do not enter a payroll.
Run the Employee Assignments Not Processed report from the Submit Requests window. You can submit this report alone or as part of a Request Set.
The Employees Without Payrolls report lists any employee or ex-employee (prior to their final processing date) whose primary assignment does not include a payroll.
Run the Employees Without Payrolls report from the Submit Requests window. You can submit this report alone or as part of a Request Set.
To run the Employee Assignments Not Processed report:In the Name field, enter or select Employee Assignments Not Processed.
Click in the Parameters field and select the parameters for the report. See the Report Parameters section for more information.
Enter the printer information and number of copies that you want to print. The report is entitled Employee Assignments Not Processed.
Submit the report.
The parameters window includes 10 fields:
| Beginning Date (required) | Enter the first date you want to include in the report. The report includes information from all payroll runs and Quickpays that contain an end date on or between the dates specified. |
| Ending Date (required) | Enter the last date you want to include in the report. |
| Consolidation Set (required if not using a payroll) | Select from the List of Values to run this report for a consolidation set. If you select a payroll in the Payroll field that is associated with a consolidation set, this field automatically populates. You must choose either a payroll or a consolidation set to run the report. |
| Payroll name (required if not using a consolidation set) | Select from the List of Values to run this report for a specific payroll. You must choose either a payroll or a consolidation set to run the report. |
| Government Reporting Entity (US only) | Select from the List of Values to limit the report to a single GRE. If you leave this field empty the report will contain information for all valid GREs. |
| Organization | Select from the List of Values to limit the report to a single organization. If you leave this field empty the report will contain information for all valid organizations. |
| Location | Select from the List of Values to limit the report to a single location. If you leave this field empty the report will contain information for all valid locations. |
| Sort Options | Three fields allow you to sort the report output. See the Sort Options section for more information on how to properly use these parameters. |
You can sort the report by up to three categories, using a list of sort options. Oracle Payroll does not require that you use sort options to generate your report, but they are the best way to tailor the report to your specific needs. You can sort reports by any of seven criteria:
Assignment status
Employee name
Assignment number
GRE
Location
Organization
Payroll
If you select no sort options, Oracle Payroll uses Payroll and Employee Name to sort the report.
The sort options are hierarchical. Sort Option Two field enables only after you have made a selection in the Sort Option One field. Likewise, the Sort Option Three field enables only after you have made a selection in the Sort Option Two field.
Once you have selected any criterion as a sort option, it disappears from the LOV of the next sort option field. Once you have selected either employee name or number as a sort option, both criteria disappear from the LOV of the next sort option field.
Note: The report does not break on Employee Name or Employee Number, so choosing one of those items for Sort Option One means that your report will not be subdivided.
Example
This example shows how to use sort options to customize the report.
If you want to create a report sorted by GRE, Organization, and Location:
Enter GRE into the Sort Option One field.
Enter Organization into the Sort Option Two field.
Enter Location into the Sort Option Three field.
Using the selected Sort Options, Oracle Payroll generates the report listing the employee assignments not processed for each location alphabetically by organization within each GRE for the selected payroll or consolidation set.
Note: The sort options are nested. For example, if you change Sort Option Two from Organization to Location, Sort Option Three is automatically cleared.
The report header includes the start and end dates, the payroll or consolidation set the report covers, and the sort options, if any. The columns list Assignment Number, Employee Name, Assignment Status, Absence Type, Salary Basis, and Period End.
Note: The report displays Period End only when the Ending Date does not match the Period End date.
The report prints in landscape orientation and fits on 8.5" x 11" paper.
To run the Employees Without Payrolls report:In the Name field, enter or select Employees Without Payrolls.
Click in the Parameters field, and select a Beginning Date and an Ending Date. See the following Report Parameters section for more information.
Note: If you are running this report as part of the request set, you do not need to reenter the dates, which automatically propagate from the Employee Assignments Not Processed parameters.
Enter the printer information and number of copies that you want to print. The report is entitled Employees Without Payrolls.
Submit the report.
The parameters window includes two fields, both required.
| Beginning Date | Enter the first date you want to include in the report. The report includes information for all employees within your business group on or between the dates specified. |
| Date | Enter the last date you want to include in the report. |
The Employees Without Payrolls report automatically sorts by Employee Name. If the system finds no one who fits the criteria, the report returns the message "No Data Found." The report header includes the starting and ending dates. Its columns are Employee Name, Assignment Number, Assignment Status, and Location. The report prints in landscape orientation and fits on 8.5" x 11" paper.