My Oracle Support Banner

Ohio State W-2 Magnetic Media Errors With ORA-01722 ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 473 (Doc ID 2501489.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12.1.3 HRMS RUP 11 version, in all instances,

When attempting to run the State W-2 Magnetic Media process,
the following error occurs.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01722: invalid number
ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 473
ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1

SQL_NO 1642
TABLE_NAME pay_population_ranges_pkg.perform_range_creation
APP-PAY-06881: Error ORA-01722: invalid number
ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 473
ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1
has occurred in table pay_population_ranges_pkg.perform_range_creation at location 1642

Cause: an oracle error has occurred. The failure was reported on table pay_population_ranges_pkg.perform_range_creation at location 1642 with the error text ORA-01722: invalid number
ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 473
ORA-06512: at "APPS_APPLMGR.PAY_POPULATION_RANGES_PKG", line 599
ORA-06512: at line 1


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

1. Run the State W-2 Magnetic Media process
2. Observe the error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get output from the State W-2 Magnetic Media process

Changes

 

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
Changes
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.