My Oracle Support Banner

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

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