My Oracle Support Banner

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

Symptoms

 

Problem Statement:

QuickPay or Payroll Process fails with the error below.

HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO <ASSIGNMENT_NUMBER>
APP-PAY-51118: Error was encountered when processing assignment <ASSIGNMENT_NUMBER>
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01455: converting column overflows integer datatype

SQL_NO 568
TABLE_NAME pay_latest_balances_s
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:

  1.  Submit "Quickpay".
  2.  Error occurs.

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.