EPY: ORA-01438 - Value Larger Than Specified Precision Allowed For This Column
(Doc ID 2530262.1)
Last updated on AUGUST 24, 2021
Applies to:PeopleSoft Enterprise HCM Payroll for North America - Version 8.9 and later
Information in this document applies to any platform.
This document was previously published as Doc ID 1590890.1
When processing retro pay, an "ORA-01438: value larger than specified precision allowed for this column error" occurs.
The key factors for replicating the issue are as follows:
1. The retro additional earnings code is setup with Amount Only, and Effect on FLSA is Amounts Only;
2. Regular earnings are in the Other Earnings section;
3. Pay period has multiple FLSA periods (ex, Bi-weekly paygroup with weekly FLSA period).
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