My Oracle Support Banner

New York State Periodic Wage Listing (SPWL) Report for Quarter 3 Does Not Balance To State Tax Remittance Report (Doc ID 2202297.1)

Last updated on NOVEMBER 11, 2021

Applies to:

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


On : 12.1.3 version, State Periodic Wage Listing Enhanced (SPWL)

The State income Tax (SIT) Wage reported in the .a01 of the New York (NY) State Q3 Periodic Wage Listing Enhanced Report does not balance to State Tax Remittance Report

The State income tax (SIT) on the .a01 and the State Remittance report have a discrepancy of over $16,000.00


Expect New York (NY) State Q3 Quarterly Period Listing Enhanced Report to match with State Tax Remittance Report

The issue can be reproduced at will with the following steps:

1. Submit Process and Reports > Single Request > State Periodic Wage Listing (Enhanced) with following parameters
State: NY
Period: Quarter 3 2016
Report output: Single GRE

Format: EFW2

2. Submit the State Tax Remittance report showing the discrepancy

3. Submit the Employee Periodic Detail report in order to validate the employee's assignment balances which is causing the difference.

The issue has the following business impact:
Due to this issue, cannot file the Quarterly State Periodic Wage Listing (Enhanced) tax for the State of New York (NY).


 Employee does not have State Unemployment wages (SUI) for Quarter 3.  Only State of New York State income tax (SIT) Year-to-Date (YTD) wages


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.