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.

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

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