"PL/SQL: Numeric Or Value Error: Character String Buffer Too Small" When creating receipt with Waybill Number more than 20 Characters
(Doc ID 2922271.1)
Last updated on JANUARY 19, 2023
Applies to:
Oracle iProcurement - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.7 version, Desktop Rcv/Returns/Correction
When attempting to create receipt with waybill number greater than 20 characters,
the following error occurs.
ERROR
-----------------------
'Your receipt could not be created successfully due to an unexpected error. Please contact your system administrator with the following information for further assistance. "PL/SQL: numeric or value error: character string buffer too small" '
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to iProcurement > Receipts > Receiving
2. Create Receipt and pass waybill number greater than 20 chars
3. Click on Submit
4. Error message appears on the page
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 |
References |