State W2 Warning Message On The SSN Beginning With A '8', and NULL value for A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER at line 344 of MMRF_EMPLOYER_RECORD (Doc ID 1631003.1)

Last updated on DECEMBER 06, 2016

Applies to:

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

Symptoms

State W2 warning message on the SSN beginning with a '8',

Also there was a warning message on the SSN beginning with a '8', its our understanding that the SSA starting using the number 8 in 2011, we viewed this information strictly as a warning an not an issue that would of caused the program to complete with error.

WARNING in RW record for Employee 237868. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 237868. Invalid SSN. SSN should not begin with 8
WARNING in RW record for Employee 229791. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 229791. Invalid SSN. SSN should not begin with 8
WARNING in RW record for Employee 228754. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 228754. Invalid SSN. SSN should not begin with 8
WARNING in RW record for Employee 231227. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 231227. Invalid SSN. SSN should not begin with 8

Verified the issue in the log file as noted below from an OWC:

LOG FILE
-----------------------

See the following error:

PL/SQL Output
-------------------------------------------------------------------------
-------------------------------------------------------------------------
WARNING in RW record for Employee 237868. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 237868. Invalid SSN. SSN should not begin with 8
WARNING in RW record for Employee 229791. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 229791. Invalid SSN. SSN should not begin with 8
WARNING in RW record for Employee 228754. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 228754. Invalid SSN. SSN should not begin with 8
WARNING in RW record for Employee 231227. Invalid SSN. SSN should not begin with 8
WARNING in RS record for Employee 231227. Invalid SSN. SSN should not begin with 8

WARNING in RW record record for Employee . No Address found for Employee number
WARNING in RS record record for Employee . No Address found for Employee number

CONTEXT:-

JURISDICTION_CODE = 34-000-0000

ASSIGNMENT_ID = -1

DATE_EARNED = 2013/12/31 00:00:00

BUSINESS_GROUP_ID = 0

PAYROLL_ACTION_ID = 9472302

TAX_UNIT_ID = 0

NO_OF_CONTEXTS = 7

NULL value for A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER at line 344 of MMRF_EMPLOYER_RECORD

Cause:        A SQL SELECT statement, obtained from the application dictionary,
returned a column whose value was NULL.

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