My Oracle Support Banner

"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 later
Information in this document applies to any platform.


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.

'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" '

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.