My Oracle Support Banner

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:

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


On : 12.2.4 version, US Payroll Year End

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

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

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


 New Database delivered in Year End Phase 1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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