My Oracle Support Banner

Payroll Reconciliation Reports Do Not Correctly Filter By Payroll (Doc ID 2235651.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle HRMS (Australia) - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Australian Payroll

Payroll Reconciliation Reports do not correctly filter by payroll

When running reports:
Payroll Reconciliation Summary XML. or
Payroll Reconciliation Detail Report

Including the parameter Payroll, where an employee has changed payrolls during the period of the report, the payments made from both the original payroll and new payroll are incorrectly included in the report.

Payroll Reconciliation Reports should correctly filter by payroll

The issue can be reproduced at will with the following steps:
1. Login to HRMS Manager
2.Employee A, changes from payroll 1 to payroll 2 effective 8/8/2016
3.Payments are:
Payroll 1, paid 5/8/2016 = $1000
Payroll 2, paid 19/8/2016 = $2000
4.When either report above is run for the period 1/8/2016 to 31/8/2016 including parameter payroll 2, $3000 is being returned for the employee. We would expect that only $2000 be returned for the employee, as it is only this amount that has been paid under payroll 2.

This issue is causing significant extra effort when reconciling payrolls, as these 'extra' payments need to be accounted for.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.