Federal W2 Magnetic Media Error Message Text = Data A_W2_QSEHRA_AMOUNT_PER_GRE_YTD Not Found A (Doc ID 2350993.1)

Last updated on JANUARY 11, 2021

Applies to:

Symptoms

On : 12.2.4 version, US Payroll Year End

When attempting to submit the Federal W-2 Magnetic Media the following error occurs.

ERROR
-----------------------
Data A_W2_QSEHRA_AMOUNT_PER_GRE_YTD not found at line 548 of MMRF_EW_WAGE_RECORD


Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.


  In { pyxipmt
message text = Data A_W2_QSEHRA_AMOUNT_PER_GRE_YTD not found at line 548 of MMRF
_EW_WAGE_RECORD


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Year End Pre Process (YEPP) was submitted
2. Year End Phase 1 and Year End Phase 2 patch were applied on January 14th
3. Hrglobal was run on January 14th
4  The Year End Pre Process (YEPP) was run before the Year end patches were applied which deliver the Database delivered

Changes

 New Database delivered in Year End Phase 1

Cause

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