Reconciliation and Control allows users to ensure reconciliation between processes. The basic principle in Oracle Labor Distribution is to ensure that amounts and records are accounted for. This means that there are ways to ensure that the amount distributed and transferred between one process or application and the next are equal and that all of the records are accounted for in the process.
For each of the processes, appropriate control structures are maintained and reports and inquiries are available to confirm the reconciliation. When a problem exists with the reconciliation or when exceptions exist, users can view a report describing the problem.
Reconciliation reports are generated for the following payroll sources:
The Reconciliation and Control process generates the following reports for payrolls from Oracle and Non-Oracle sources:
Reconciliation Between Payroll Sublines Report and Distribution Lines
Reconciliation Between Distribution Lines Report and Summarized Distributions
As a result of the Import Payroll Transactions process, the sum of the amounts of the payroll sublines must equal the sum of the amounts of the payroll lines coming from the payroll report. The amounts summarized by employee, assignment, and element should match between the payroll lines and payroll sublines.
If the reconciliation report indicates errors and the Create Distribution Lines process has not been run, users can roll back the Oracle payroll or the Non-Oracle payroll batch to correct the errors.
For information on rolling back an Oracle payroll, see Import Payroll Transactions Procedures.
For information on rolling back a non-Oracle payroll batch, see Rolling Back Non-Oracle Payroll Procedure.
As a result of the Create Distribution Lines process, the sum of the dollar amounts of the distribution lines for any one set of payroll sublines must equal the sum of the dollar amounts of those payroll sublines in total and by employee, assignment, and element.
If the reconciliation report indicates error and the Summarize and Transfer Payroll Distributions process has not been run, users can roll back the distribution lines to correct the errors.
For information on rolling back distribution lines, see Rolling Back Distribution Lines Procedure.
As a result of the Summarize and Transfer Payroll Distributions process, the sum of the amounts of the summarized lines for any one set of distribution lines must equal the sum of the amounts of those distribution lines in total and by employee, assignment, and charging instructions.
The Reconciliation and Control process generates the following report for pre-generated distributions:
Reconciliation Between Pre-generated Distribution Lines and Report Summarized Distributions
As a result of the Summarize and Transfer Payroll Distributions process, the sum of the amounts of the summarized lines for any one set of pre-generated distribution lines must equal the sum of the amounts of those pre-generated distribution lines in total and by employee, assignment, and charging instructions.
To create payroll sublines, perform the following steps.
In Labor Distribution, navigate to the Submit Request window as follows:
Processes & Reports - Run
The Submit a New Request pop-up window appears.
Select the Single Request radio button.
Click OK.
The Submit Request window appears.
In the Name field, select one of the following:
Reconciliation between distribution lines and summary
Reconciliation between pre-generated distribution lines and summary lines
Reconciliation between payroll lines and sublines
Reconciliation between sublines and distribution lines
The Parameters pop-up window appears.
In the Source Type field, select a source type from the list of values.
In the Source Code field, select a source code from the list of values.
In the Time Period field, select a time period from the list of values.
If the source type is not Oracle, in the Batch Name field, users must select a batch name from the list of values.
To apply the parameters, click OK.
In the Submit Request window, click Submit.
The Requests window appears.
To view the report file, select the appropriate Request ID and click View Output.
Close the window.