State Quarterly Wage Listing Enhanced Error: Data PER_ADR_REGION_2 not found at line 209 of ICESA_SUPPLEMENTAL (Doc ID 1932738.1)

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.

Symptoms

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.

ERROR
-----------------------
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.

STEPS
-----------------------
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




Changes

 Employee address was end dated as of July and no new address entered

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