ORA-06502 when calling HR Organization API due to VARCHAR2 length
Environment: Oracle Applications Manager Version 12.2.6
Module: HRMS (Human Resource)
Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Context: The error occurs when calling the HR Organization API.
While calling API HR_ORGANIZATION_API.UPDATE_ORGANIZATION in Oracle E-Business Suite, the process fails with: ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
The error occurs inside HR_ORU_SHD.API_UPDATING, which selects data from HR_ALL_ORGANIZATION_UNITS.
Column ATTRIBUTE10 is defined as VARCHAR2(150 CHAR). For the problematic organization:
length(attribute10) = 87
lengthb(attribute10) = 166
Because the value contains multibyte characters, the byte length exceeds the buffer size expected by a variable inside the internal API, which causes