Documents of Records Creation Ends in Error After Final Approval “ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small”
(Doc ID 2808812.1)
Last updated on SEPTEMBER 22, 2021
Applies to:Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
After transaction for Document of Records is approved
the following error occurs.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The issue can be reproduced at will with the following steps:
1. Using Employee Self-Service responsibility -> go to Documents of Records function -> click on Create and provide all needed information
2. Request is sent to approval
3. Approver approve the request
4. After approval, transaction goes into error -> ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error can be seen in notification received by approver after approval.
Also, same error can be seen in uploaded wfstat.log and Event ORA trace.
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