My Oracle Support Banner

Retro-Notifications Report (Enhanced) - PDF Error ORA-01426: numeric overflow (Doc ID 1919326.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.


On : 12.1.3 version, RetroPay Issue

When attempting to run "Retro-Notifications Report (Enhanced) - PDF"
the following error occurs.

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-01426: numeric overflow
ORA-06512: at "APPS.PAY_ARCHIVE", line 1211
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

The issue can be reproduced at will with the following steps:
1. run retro notification enhanced pdf



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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.