US Gross To Net Report Completes In Error APP-PAY-06881, ORA-06502, ORA-06512 When Using 3 Sort Options (Doc ID 1970382.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, US Payroll Reports - General

When attempting to submit the US Gross To Net Report with 3 sort options after year end patches the following error occurs.

ERROR
-----------------------
SQL_NO 1101
TABLE_NAME pay_archive.arch_initialise
APP-PAY-06881: Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PAY_ARCHIVE", line 554
ORA-06512: at line 3
has occurred in table pay_archive.arch_initialise at location 1101

Cause: an oracle error has occurred. The failure was reported on table pay_archive.arch_initialise at location 1101 with the error text ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PAY_ARCHIVE", line 554
ORA-06512: at line 3
.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. running the US Gross two report
2. using the parameters of: January 22nd, GRE is blank and payroll is entered, choose multiple sorts



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms