State W-2 Magnetic Media Concurrent Request Errors Out APP-PAY-06881: Error ORA-20001: Pay Message line and log have more Details+ Exception (Doc ID 1966822.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.
REPORT:STW2 - State W-2 Magnetic Media

Symptoms


When attempting to submit the Wisconsin State W2 Magnetic Media file the following error occurs.

Error in Pre-Process check .  Assignment Marked for Retry: GRE_ID := 158
message text = Error in Pre-Process check .  Assignment Marked for Retry: GRE_ID
:= 158
message level = F,F
payroll_id text = 0
source_id text = 7,1441893
line_text = 72, Error in Pre-Process check .  Assignment Marked for Retry: GRE_I
D := 158
Error in Pre-Process check .  Error Condition detected
message text = Error in Pre-Process check .  Error Condition detected
message level = F,F
payroll_id text = 0
source_id text = 7,1441893
line_text = 55, Error in Pre-Process check .  Error Condition detected
Error in Pre-Process check .  Pay Message line  and log have more Details
message text = Error in Pre-Process check .  Pay Message line  and log have more
Details
message level = F,F
payroll_id text = 0
source_id text = 7,1441893
line_text = 73, Error in Pre-Process check .  Pay Message line  and log have mor
e 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 1888
ORA-06512: at "APPS.HR_DYNSQL", line 2415
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 287
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 593
ORA-06512: at line 1

 


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

  1. Submit the Concurrent Program > Single Request > State W2 Magnetic Media
    • Parameters
      • State
      • Year
      • Transmitter GRE Name
      • Create Audit Report
      • Fold



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