My Oracle Support Banner

Fusion Global HR : HCM Extract - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.PAY_PROC_LOGGING" (Doc ID 2763609.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Symptoms

Multiple HCM Extracts fail with below error exceptions, reported in the HCM Extract/ESS Job output file and the error can also be seen in HCM Extract Process Diagnostics Report.

Below error seen on <ESS_JOB>.txt

Name PAY_PAYPROC_UNKNOWN_ERR

Token1 null
Token2 null
Token3 null
A system error occurred during processing. Contact your help desk.
Out } PayMessage.handleMessage
In { PayMessage.handleMessage
In { PayUtils.getActionParameter
In { ParameterCache.getValue
Out } ParameterCache.getValue

Parameter Name = MESSAGE_NAMES Parameter Value =
Out } PayUtils.getActionParameter

Set Token 1
Set Token 2
Set Token 3
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 82
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2340
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1975
ORA-06512: at line 1

Below error seen from Extracts Process Diagnostics Report

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 82 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2340 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1975 ORA-06512: at line 1 A system error occurred during processing. Contact your help desk. Name HR_6881_HRPROC_ORA_ERR Token2 ORA-06502: PL/SQL: numeric or value error: character string buffer too small A system error ORA-06502: PL/SQL: numeric or value error: character string buffer too small

  

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.