The Summarize and Transfer Payroll Distributions concurrent process reads and summarizes the distribution lines created from the Create Distribution Lines process and transfers these lines to Oracle Grants Accounting, Oracle Projects, and Oracle General Ledger for posting.
This section describes the Summarize and Transfer Payroll Distributions process.
Note: If the Create Distribution Lines process was run with auto-population enabled, the Summarize and Transfer Payroll Distributions process uses the auto-populated expenditure type or natural account in the distribution lines table.
The Summarize and Transfer Payroll Distributions process includes the following parts:
The user submits a request to the concurrent manager and Labor Distribution selects the records for summarization and transfer. Summarize and Transfer Payroll Distributions reads the following tables to select records for summarization and transfer:
Summarize and Transfer Payroll Distributions selects all previously unprocessed records and batches the records by payroll. Each batch and record is marked with a status indicating the state of processing that the batch and record are in. This ensures that previously summarized and transferred records are not transferred more than once.
Summarize and Transfer Payroll Distributions reads the Pre-generated Distribution Lines table to select all previously unprocessed records and batches the records by reference identifiers. Each batch and record is marked with a status identifying the state of processing that each batch and record is in. This ensures that previously summarized and transferred records are not transferred more than once.
For lines that are to be transferred to Grants Accounting or Projects, Labor Distribution summarizes the distribution lines and the pre-generated distribution lines at the employee, assignment, project, task, award, expenditure type, expenditure organization, and effective dates levels. The award level applies to Grants Accounting only.
For lines that are to be transferred to General Ledger, Labor Distribution summarizes the distribution lines by employee, assignment, General Ledger accounting flexfields, and effective dates.
All summarized distribution lines are posted to the Distribution Lines Summary table.
If General Ledger override date is specified for a batch, the Summarize and Transfer Payroll Distributions process uses this date as the effective date in posting General Ledger transactions. If this date is not specified, the effective date is based on the distribution dates on the distribution lines.
Processing of employee assignment with zero work day allows summarization and transfer of distribution lines, for employees with zero work day situations, irrespective of employee assignment status.
The following rules apply:
If an employee has a non-active status and has a schedule charging to Oracle General Ledger, Labor Distribution does not change the posting date. General Ledger does not validate whether an employee has an active or non-active employee assignment status.
If an employee has a non-active assignment status and has a schedule charging to Grants Accounting or Projects, Labor Distribution looks for the employee assignment's last active date and stores this date as the GMS Override Date. Grants Accounting or Projects then accepts the transfer of distribution lines with a non-active employee assignment status.
For information on employee assignments with zero work day situations, seeEmployee Assignments with Zero Work Day.
Users can customize and execute a prenamed procedure to update or populate the Distribution Lines Summary table with additional information to be transferred to Grants Accounting, Projects, or General Ledger.
Labor Distribution transfers the summarized distribution lines from the Distribution Lines Summary table to Grants Accounting, Projects, and General Ledger and initiates the journal import programs and the transaction import programs.
Labor Distribution provides control reports to assist the user with reconciling the following:
Payroll information imported
Distribution lines created and summarized
Transfer of the lines to the Grants Accounting, Projects, and General Ledger interface tables
For information on distribution reports, see Reports Procedures.
The Summarize and Transfer Payroll Distributions and the Use Default GL Posting Override Date profile options must be set.
To set up system profile options, see System Administration Setup.
To summarize distribution lines and transfer, 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 PSP: Summarize and Transfer Payroll Distributions from the list of values.
Click OK.
The Parameters pop-up window appears.
Note: If Create Distribution Lines was run with auto-population enabled, Summarize and Transfer Payroll Distributions uses the expenditure type and natural account auto-populated values.
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 Payroll Name field, select a payroll name from the list of values.
In the Time period field, select a time period from the list of values.
In the Batch name field, 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 log file, select the appropriate Request ID and click View Log.
Close the window.
Note: Each time the Summarize and Transfer Payroll Distributions procedure is run, Labor Distribution updates the appropriate tables in Oracle Projects.
If the Summarize and Transfer Payroll Distributions process fails due to database problems, suspense account problems, or reversal account problems.
View the process's log to determine the cause of the failure.
Correct the errors in the database and/or suspense or reversal account.
Rerun the Summarize and Transfer Payroll Distributions process.