My Oracle Support Banner

US Federal W-2 Magnetic Media (FEDW2) Completes in Error HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-01722: invalid number ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5717 (Doc ID 3062409.1)

Last updated on DECEMBER 05, 2024

Applies to:

Oracle HRMS (US) - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit the 2024 Federal W-2 Magnetic Media file the following error occurs:

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR

SQLERRMC ORA-01722: invalid number

ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5717

ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5164

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

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

ORA-06512: at line 1

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

ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5154

ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5673

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

1. Applied all Mandatory US Legislative Patches

2. Using the US SUPER HRMS Manager Responsibility or Equivalent.

3. Submit Process and Reports>Single Request>Federal W-2 Magnetic Media.

4. Observe the error.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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