E1: 07S: Tennessee SUI (R89078343) Space Between Employee Last Name and Suffix Causes Error (Doc ID 2813308.1)

Last updated on OCTOBER 11, 2021

Applies to:

Symptoms

When uploading the Tennessee SUI quarterly file to the State, an error is given on records that have the employee's last name followed by a space then a suffix; for example: Smith Jr, Eric  The file must be manually corrected by removing any spaces in the last name field and then it can be uploaded successfully.

STEPS:
  1. Find a Tennessee employee who's last name is followed by a space and a suffix in their Alpha Name E.g: Smith Jr
  2. Create the TN SUI flat file by running the R07810 (Weeks Worked) in Final, R078300 (Prepare Data for SUI Reporting) and after Selecting TN State from the P074001R (Report Setup), run the R89078343 (Tennessee SUI Magnetic Media (43)) and review the produced flat file.
  3. The space between the employee's last name and suffix is causing the error: "The Employee's Last Name Contains Numeric Characters, Comma, Period, or one or more Spaces on Line '#'.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.