Error 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' Received When Submitting A Material Return Debrief Line (Doc ID 2949675.1)

Last updated on MAY 22, 2023

Applies to:

Symptoms

When submitting a material return debrief line with a serial number with more than 25 characters, the following error occurs:

ERROR
--------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

STEPS
--------
The issue can be reproduced at will with the following steps:
1. Log in with Field Service Manager responsibility.
2. Navigate to Service Requests/Create Service Requests.
3. Create a new service request and task.
4. In Tasks tab click Debrief Button.
5. Enter a material return debrief line with a serial number with more than 25 characters.
6. Submit the debrief.

Changes

Cause

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