Skip to main content

Error: 'ORA-06502: PL/SQL: numeric or value error: number precision too large'

A negate was input in leave details in the Maintain Leave Without Pay screen and has caused the PAY140 to fail.

O
Written by Onyema Onyejekwe
Updated over 2 months ago

If you enter a negate in the leave details field on the Maintain Leave Without Pay screen, you may encounter the following error:

**Start UnHandled Exception

SOURCEREF: s37000_insert_day_history

EMPNO: XXXXXX

ERRNO: -6502

ERRMESS: ORA-06502: PL/SQL: numeric or value error: number precision too large.**

This error can cause the PAY140 file to fail. To troubleshoot the issue, check the `number_of_units` in the log file. If this number exceeds 999, it will indeed cause the PAY140 to fail.

Here are the steps to resolve the issue:

1. Retrieve the PAY140.trcXXXX file, where XXXX represents the pay group.

2. Review the ERRDATA row, as the system only permits values up to 999.

If the negate value is greater than 999, it is recommended to split the negate into two parts. For instance, negate half of the amount in one period and the other half in a subsequent period. This approach is necessary due to user access rights.

Did this answer your question?