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 19, 2018

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 Processor 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 processor was run before the Year end patches were applied which deliver the Database delivered

The issue has the following business impact:
Due to this issue, users cannot submit the Federal W2 Magnetic Media as the database item is missing


 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.