QuickPay/Payroll Fails with APP-PAY-06881/ORA-01455 converting column overflows integer datatype has occurred in table pay_latest_balances_s
(Doc ID 2513749.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Payroll - Version 12.1 to 12.1 HRMS RUP10 [Release 12.0 to 12.1]
Oracle Payroll - Version 12.2 to 12.2 HRMS RUP11 [Release 12.2]
Information in this document applies to any platform.
This note provides a brief overview of
QuickPay or Payroll Process fails with the error below.
APP-PAY-51118: Error was encountered when processing assignment <ASSIGNMENT_NUMBER>
SQLERRMC ORA-01455: converting column overflows integer datatype
APP-PAY-06881: Error ORA-01455: converting column overflows integer datatype
has occurred in table pay_latest_balances_s at location 568
Cause: an oracle error has occurred. The failure was reported on
table pay_latest_balances_s at location 568 with the error text ORA-01455:
converting column overflows integer datatype
Action: Please contact your support representative.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Submit "Quickpay".
- Error occurs.
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