Year End W2 Exception Error APP-PAY-06881: Error ORA-01840: input value not long enough for date format
(Doc ID 2817910.1)
Last updated on AUGUST 21, 2024
Applies to:
Oracle HRMS (US) - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, US Payroll Year End
When attempting to run the W2 Exception request set the following error occurs.
From log file
ERROR
-----------------------
SQL_NO 1642
TABLE_NAME pay_population_ranges_pkg.perform_range_creation
APP-PAY-06881: Error ORA-01840: input value not long enough for date format
ORA-06512: at "APPS.HR_DYNSQL", line 1924
ORA-06512: at "APPS.PAY_YREND_REPORTS_PKG", line 103
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APPS.HR_DYNSQL", line 1913
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
has occurred in table pay_population_ranges_pkg.perform_range_creation at location 1642
The set completed normally with outcome Error.
The outcome was determined by the final stage, W2 Exception.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
US Super HRMS Manager responsibility
- Ran the Year End Preprocess - completed successful
- Under Processes and Reports > Request Set run the W2 exception request set
- This is ending in error
- Currently in the second iteration testing of Release 12.2.10 upgrade from 12.1
- This completed successful first iteration
Changes
Upgrade from 12.1 to 12.2
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 |