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:

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 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

BUSINESS IMPACT
-----------------------
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

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.