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



Symptoms

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

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.