My Oracle Support Banner

Federal Magnetic Media File For W-2 Error APPS.PAY_POPULATION_RANGES_PKG (Doc ID 2501055.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12.2.4 version, US Payroll Year End

When attempting to run the federal W2 Magnetic Media
the following error occurs.

ERROR
-----------------------
able=pay_population_ranges_pkg.perform_range_creation
sqlno=1642
ORA-20001: Please correct the profile option value or run Employer Rearchive to
reset the archived value.+ Exception
ORA-06512: at "APPS.HR_DYNSQL", line 1924
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", line 593
ORA-06512: at line 1

Oracle error occurred
Table=pay_core_utils.pop_message
sqlno=1541
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PAY_CORE_UTILS", line 890
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Year End Preprocess
2. Run the Employee W2 PDF
3. Run the Federal W2 Magnetic Media



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.