My Oracle Support Banner

EPY: EFW2 RS Record Contains Incorrect Amounts for Philadelphia Under Specific Conditions When Run On OS390 (Doc ID 1997532.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 and later
Information in this document applies to any platform.


When running on OS390, multiple RS records are created for Philadelphia amounts generated by the delivered SQR, TAX960LC, when an employee is in multiple tax locations within the year.


Employee lives in PSD 090101 and works in Philadelphia part of the year.
Employee moves to Philadelphia later in the year.

There are two local tax rows each for wages and taxes on the W-2.

Resident Jurisdiction Work Jurisdiction  Wages Tax Amount
090101 510101 430.86 15.06
510101 510101 1872.07 73.39
    2302.93 88.45

The total amounts are displayed on the PHILA file twice in the RS records.  The totals on the PDF report are also doubled.


To view full details, 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 a vibrant support community of peers and Oracle experts.