The Import Payroll Transactions concurrent process imports Oracle Payroll lines and preformats them for the distribution process.
This section describes the Import Payroll Transactions process.
The Import Payroll Transactions process includes the following tasks:
To select a payroll to be imported, users run the Import Payroll Transactions concurrent process.
Oracle Labor Distribution imports payroll reversals, balance adjustments, and retroactive payments when you import a regular payroll run. You only need to run the PSP: Import Payroll Transactions once to import a regular payroll along with other payroll actions for reversals, balance adjustments and retroactive payments that you costed together in Oracle Payroll.
In addition, you can distribute and transfer all the imported transactions (using the PSP: Create Distribution Lines process and PSP: Summarize and Transfer Payroll Distribution process) in a single run.
When you import reversals, retroactive payments, and balance adjustments, Oracle Labor Distribution will apply the labor schedule as of the original period for the imported transactions.
Zero work day situations occur when an employee assignment is suspended or terminated during a previous payroll period and the assignment is inactive during the payroll period being imported into Labor Distribution. Zero work day situations also occur when an employee is hired in a payroll period on a non-business day and there are no more business days in that payroll period after the hire date.
Processing of Employee Assignments with zero work day allows the import of Oracle payroll for employees with zero work day situations, irrespective of employee assignment status, active or non-active, as long as the employee's final termination process in HRMS has not been completed.
For all elements, Oracle Labor Distribution distributes the pay amount evenly across the payroll period with one exception, the Regular Salary element. Because salary is typically the largest pay amount and salary information is directly available in Oracle Human Resources, Labor Distribution performs a special calculation for Regular Salary. This special calculation enables Labor Distribution to adjust daily pay amounts to account for salary increases. The balance amount is used for this special calculation for Regular Salary to account for any pay amount differences from pay that results from salary alone.
The balance amount, if any, is distributed evenly across the payroll period through incorporation in the daily rate. Balance amounts are created only for the element Regular Salary, which is a seeded element value in Human Resources.
If a salaried employee is on a biweekly payroll and is paid $1,000 on the element Regular Salary, the daily rate is $100. If, in the next payroll period, the employee has a pay increase to $1,000 per week, the employee is paid $1,500 with a daily rate of $100 for the first week and $200 for the second week.
If a user performs a manual override for that payroll and pays Regular Salary of $1,800, the balance amount would equal $300 and the daily rate would be $130 for the first week and $230 for the second week.
Labor Distribution splits each employee, assignment, and element payroll line into sublines based on dates of interest. The dates of interest are as follows:
date of salary or wage change
date of FTE change
date employment begins
date employment ends
date employee status becomes active
date employee status becomes inactive
date assignment begins
date assignment ends
organization change date
date job changes
date position changes
element effective date begin
element effective date end
assignment status
The sublines cover all the days between the payroll begin date and payroll end date. Each day within the payroll period can be covered by only one subline. Labor Distribution populates the subline begin date and subline end date for each subline.
Labor Distribution determines a daily rate for each subline and populates the appropriate subline field. Daily rates are used to calculate distribution amounts for a particular employee assignment, element, payroll, and day.
The daily rate is calculated as follows:
For each element, except for Regular Salary, the daily rate equals the amount of the payroll run for the selected element and employee assignment divided by the number of working days in the payroll period where a working day equals a day in which the employee assignment is active.
For Regular Salary, the daily rate equals the daily rate based on salary plus the balance amount, divided by the number of working days in the payroll period.
Daily rates are used to calculate distribution amounts for a particular employee assignment, element, payroll, and day.
All sublines are stored in a table where the Create Distribution Lines process can access them.
Note: Import Payroll Transactions picks up payroll transactions in Human Resources on the basis of Date Earned. When the user runs the Import Payroll Transactions process, the user enters the payroll name and the pay period name. Labor Distribution gets the Date Earned for the selected payroll and pay period combination.
The Rollback Imported HRMS Payroll process rolls back a payroll imported from Oracle Human Resource Management Systems to rectify errors after the Import Payroll Transactions process is run but before Create Distribution Lines is run. This process reduces the need to create distribution adjustments to a great extent.
After a payroll is rolled back, users can reimport the same payroll. This process can be repeated several times.
The following rules apply to the Rollback Imported HRMS Payroll process.
The Rollback Imported HRMS Payroll rolls back imported payrolls only for undistributed payrolls.
If the Create Distribution Lines process has been run, users must first roll back the distribution lines and then roll back the payroll.
Note: If users attempt to roll back an imported payroll after running Create Distribution Lines, a message appears advising the user to roll back the distribution lines first.
For information on rolling back distribution lines, see Rolling Back Distribution Lines Procedure.
If the Summarize and Transfer Payroll Distributions process has been run, the imported payroll cannot be rolled back. A message appears advising users that a rollback is not allowed.
If the user runs the Reconciliation Report between Payroll Lines and Sublines after running Import Payroll Transactions, any errors relating to the creation of sublines, such as assignments and elements, are reported. Users can roll back the imported payroll and make changes to data in Human Resources or Labor Distribution.
For information on running Reconciliation Report between Payroll Lines and Sublines, see Generating Reconciliation and Control Reports Procedure.
If the user runs the Reconciliation Report between Payroll Sublines and Distribution Lines after running Create Distribution Lines, the user can identify distribution lines that are not targeted for the correct transfer destination. To rectify the distributions, the user rolls back the distribution lines and the imported payroll, makes changes to labor schedules, and reruns the two processes. This rollback process is essential to preclude making adjustments in Distribution Adjustments for a large amount of distribution lines.
For information on running Reconciliation Report between Payroll Sublines and Distribution Lines, see Generating Reconciliation and Control Reports Procedure.
When you run the PSP: Import Payroll Transaction from HRMS process, the process generates a log that enables you to track the time periods of the payroll transactions that Oracle Labor Distribution imports. You can use the log file help to determine the correct time period for which Labor Distribution processes need to run. The log of the PSP: Import Transaction from HRMS process displays the details of the imported time period.
| Time Period | Payroll Action | Assignment Count |
| 1 2007 Calendar Month | Run | 100 |
| ... 10 2006 Calendar Month | Balance Adjustments | 10 |
| ... 9 2006 Calendar Month | Retro Pay | 5 |
If the payroll transactions that the process imports contains past payroll time periods, then these entries will appear indented below the latest payroll time period. When you run the PSP: Create Distribution Lines process and the PSP: Summarize and Transfer Payroll Distribution processes for the latest payroll time period, the processes will also process the past imported payroll periods.
Oracle Payroll Costing must be run, costed, and transferred to Oracle General Ledger before initiating the Import Payroll Transactions procedure.
For information on payroll runs, see Payroll Runs and Processes, Oracle HRMS Payroll Processing Management Guide.
To import payroll transactions, 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: Import Payroll Transactions from HRMS from the list of values.
Click OK.
The Parameters pop-up window appears.
In the Payroll Name field, select a payroll from the list of values.
Note: Users select the period name corresponding to the payroll run they want to import.
In the Period Name field, select a payroll period type from the list of values.
Note: The period type corresponds to the payroll period types in Oracle Human Resources. Users select the period type corresponding to the payroll run they want to import.
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.
To roll back payroll imported from Human Resource Management Systems, 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: Rollback Imported HRMS Payroll from the list of values.
Click OK.
The Parameters pop-up window appears.
In the Payroll Name field, select a payroll name from the list of values.
In the Period Name field, select a period 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.