PYNZREC_XML: Payroll Reconciliation (New Zealand) (XML) Showing Incorrect Values

(Doc ID 2000841.1)

Last updated on JULY 14, 2016

Applies to:

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

Symptoms

Payroll Reconciliation (New Zealand) (XML) - (PYNZREC_XML)
is showing:
(1) incorrect KiwiSaver Employer Contributions amount
(2) incorrect values under Ordinary Taxable Earnings



(1) KIWISAVER CONTRIBUTIONS - Issue
The Payroll Reconciliation (New Zealand) (XML) report is showing incorrect values in the Employer charges section with regard to KiwiSaver Employer Contributions and ESCT Deduction.

On the report, under Employer Charges, the "ESCT Deduction" amount is not deducted from the KiwiSaver Employer Contributions amount.
The KiwiSaver Employer Contributions amount remains unchanged, which means that the total for the Employer Charges section is incorrect.


(1) KIWISAVER CONTRIBUTIONS - SOE
On the SOE, it is shown, correctly, under the Employer Super Contributions section, as :

ESCT Deduction $4.51
Kiwisaver/Super Net Employer Contribution $9.15
TOTAL $13.66


(1) KIWISAVER CONTRIBUTIONS - Payroll Reconciliation Report
But, on the Payroll Reconciliation (New Zealand) (XML) report, the following is displayed

ESCT Deduction $4.51
KiwiSaver Employer Contributions $13.66 (Incorrect)
TOTAL $18.17 (Incorrect)




(2) ORDINARY TAXABLE EARNINGS - Issue
The Payroll Reconciliation (New Zealand) (XML) report is showing values for Ordinary Hours, under
"Ordinary Taxable Earnings" section, incorrectly.

Within the report, it seems that the Rate and the Amount is being calculated within the report rather than being obtained from Run Results.


(2) ORDINARY TAXABLE EARNINGS - Run Results
Three Run Results :

Element :E Ordinary Hours
Hours : 8
Rate: 14.80
Pay Value: 118.40

Element :E Ordinary Hours
Hours : 8
Rate: 14.80
Pay Value: 118.40

Element :E Ordinary Hours
Hours : 8
Rate: 14.80
Pay Value: 118.40


(2) ORDINARY TAXABLE EARNINGS - SOE
In the SOE, the Following Result is shown

Taxable Earnings
-----------------
Ordinary Hours $355.20 (Which is 118.40 x 3, this is CORRECT)


(2) ORDINARY TAXABLE EARNINGS - Payroll Reconciliation Report
On the Payroll Reconciliation (New Zealand) (XML) report, the following values are shown

Ordinary Taxable Earnings section
---------------------------------------------
Ordinary Hours
Rate: 44.40 (INCORRECT - should be 14.80, NOT 3 x 14.80)
Hours: 24 (correct)
This Period: 1065.60 (INCORRECT - should be 3 X 8 x 14.80 = 355.20, NOT 3 x 355.20 )
YTD: 355.20 (INCORRECT)



EXPECTED BEHAVIOR
We would expect the Payroll Reconciliation Report to show the same values as a the SOE

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms