UK Gender Pay Gap Archiver Process Failing With ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2283557.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

Gender Pay Gap Archiver failing when grade name length exceeds 30 characters

When running concurrent process Gender Pay Gap Archiver, it completed in error:

Error

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: An error encountered was - ORA-06502: PL/SQL: numeric or val
ue error: character string buffer too small
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: An error encountered was - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
 has occurred in table pay_archive.process_employee at location 1108

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

Action: Please contact your support representative.


Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Run "Gender Pay Gap Archiver" process

Changes

 Patch 25572677: GENDER PAY GAP REPORT has been previously applied since it provides the new concurrent program Gender Pay Gap Archiver.

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