Last updated on APRIL 11, 2017
Applies to:Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.
12.1.3 version, State Quarterly Wage Listings Enhanced (SPWL)
When attempting to submit the Tennessee State Quarterly wage listing Enhanced report the following error occurs.
JURISDICTION_CODE = 43-000-0000
BUSINESS_GROUP_ID = 123
TRANSFER_ASS_ACTION_ID = 59740299
ASSIGNMENT_ACTION_ID = 59740299
ASSIGNMENT_ID = 2730
DATE_EARNED = 2014/07/30 00:00:00
NO_OF_CONTEXTS = 9
Data PER_ADR_REGION_2 not found at line 209 of ICESA_SUPPLEMENTAL
Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.
The issue can be reproduced at will with the following steps:
1. Accrued State Quarterly Unemployment wages for the quarter
2. Submitted the State Quarterly Wage listing Enhanced with parameters of third quarter for the State of Tennessee for all GRE's parameter
Employee address was end dated as of July and no new address entered
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms