Federal W-2 Magnetic Media Concurrent Request Errors Out "NULL value for A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER at line 385 of MMRF_SUB MITTER_RECORD (Doc ID 1487609.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms


When attempting to submit the Federal W2 Magnetic Media file the following error occurs.

"NULL value for A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER at line 385 of MMRF_SUBMITTER_RECORD
Cause: A SQL SELECT statement, obtained from the application dictionary, returned a column whose value was NULL"

 


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

  1. Submit the Concurrent Program > Single Request > Year End Pre Processor (YEPP) for the one Government Reporting Entity (GRE)
  2. Parameters used: Year: 2012 GRE: YE Vision
  3. Submit the Concurrent Program > Single Request > Federal W2 Magnetic Media
    • Parameters
      • Year
      • GRE Name



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