When submitting the Single Request > Federal W-2 Magnetic Media Job Ends with Multple Errors: in Pre-Process Check- . EIN or Tax Unit Name Missing EIN for GRE:= 12345 and SQLERRMC ORA-20001: Pay Message line and log have more Details+ Exception (Doc ID 2925578.1)

Last updated on MARCH 27, 2023

Applies to:

Symptoms

On : 12.2 HRMS RUP16 version, US Payroll Year End

When attempting to Submit the Single Request > Federal W-2 Magnetic Media the following error occurs.

ERROR

-----------------------

WARNING in Pre-Process check . Please Archive GRE With ID := 123

WARNING in Pre-Process check . Please Archive GRE With ID := 456

WARNING in Pre-Process check . Please Archive GRE With ID := 789

Error in Pre-Process Check- . EIN or Tax Unit Name Missing

Error in Pre-Process check . EIN for GRE:= 839 Not Set

Error in Pre-Process check . Error Condition detected

Error in Pre-Process check . Pay Message line and log have more Details

HR_6881_HRPROC_ORA_ERR

SQLERRMC ORA-20001: Pay Message line and log have more Details+ Exception

ORA-06512: at "APPS.HR_DYNSQL", line 1924

ORA-06512: at "APPS.HR_UTILITY", line 970

ORA-06512: at "APPS.PAY_US_MMREF_REPORTING", line 1196

ORA-06512: at "APPS.PAY_US_MMREF_REPORTING", line 1314

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1721

ORA-06512: at "APPS.HR_DYNSQL", line 1913

ORA-06512: at "APPS.HR_DYNSQL", line 2451

ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 287

ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG",

SQL_NO 1642

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. Using the US SUPER HRMS Navigator or Equivalent
2. Submit the Single Request > Year End Pre Process (YEPP) for all GRE's.
3. Submit the Single Request > Federal W-2 Magnetic Media.
4. Observe the Error.

Changes

  Government Reporting Entity (GRE) missing an Employer ID Number (EIN)

Cause

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