Employee W2 Report Errors: "REP-1401: 'c_fed_num_rowformula': Fatal PL/SQL error occurred. ORA-06502: PL/SQL: numeric or value error" (Doc ID 2920335.1)

Last updated on AUGUST 21, 2024

Applies to:

Symptoms

The Employee W2 Report concurrent process is completing in error with several Payroll Worker Processes showing the following in the log file:

ERROR
-----------------------
MSG-00001: tmp004:
REP-1401: 'c_fed_num_rowformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp004:
REP-1401: 'c_fed_num_rowformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error

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

From US HRMS Manager responsibility (or equivalent), run "Employee W2 Report"

Navigate: Processes and Reports > Submit Processes and Reports

Changes

Cause

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