For more information, please refer to this announcement explaining best practices for getting answers to questions.
HCM Extract Error
Summary:
Extract failed with below error,
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2147
ORA-01403: no data found
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2277
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2107
ORA-06512: at line 1
Content (please ensure you mask any confidential information):
If we submit the HCM Extract from Fusion application able to complete the process. However, if we run the same extract with the same parameters from ICS getting below error,
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2147