My Oracle Support Banner

Third Quarter State Periodic Wage Listing Enhanced (SPWL) File Format Not Accepted By State of Illinois Department of State Unemployment (IDES) (Doc ID 2827973.1)

Last updated on JUNE 10, 2024

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)

When attempting to submit the 3rd Quarter Illinois State Periodic Wage Listing the following error occurs.


Import Error message
One or more rows in IDES_Wages_3rd_Qtr_2021.txt contains 1 columns. Each row of the import file must have 5 columns

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

1. Using the US Super HRMS Manager Responsibility
2. Navigate to > Processes and Reports > State Periodic Wage Listing (Enhanced) > IL > Period October 2021 > Format - State Specific Format
3. Process completes successfully, no error on the Oracle EBS Payroll application side
4. Observe error message when attempting to submit to the State of Illinois Department of State Unemployment (IDES)


 Filing the SPWL for Quarterly vs. Monthly Monthly


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.