Fusion Global HR: Character String Buffer too Small Error When Passing Multiple Comma Separated Person Numbers in Single Parameter of HCM Extract: "A system error ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "
(Doc ID 2589621.1)
Last updated on AUGUST 03, 2020
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and laterOracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.13.19.07.0. The note has been reviewed and is current for release 11.13.20.07.0.
Symptoms
When attempting to pass multiple comma separated person numbers in single parameter of HCM extract, the following error occurs.
ERROR
-----------------------
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1554"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When passing 3 -4 input values HCM extract is giving the expected result
2. But when passing 60-70 person numbers, the below error occurs:
"A system error ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1554"
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 |