My Oracle Support Banner

Error While Changing Serial Number On Item Serial No. Change Page: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.AHL_PRD_SERN_CHANGE_PVT_W" (Doc ID 2747241.1)

Last updated on FEBRUARY 01, 2021

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

Error while changing Serial Number on Item Serial no Change Page

ERROR
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.AHL_PRD_SERN_CHANGE_PVT_W", line 181 ORA-06512: at line 1

STEPS
-----------------------
1. Complex MRO Super User --> execution --> Search a Workorder which is on Part Number, Serial Number and Lot number which has more than 30 characters length.
2. Select Workorder and Go to Update Workorder Page, Select Item/Serial Number change option, click on Go Button and enter New Serial Number and click on Apply button.
Get the above mentioned error.



Changes

 

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
Changes
Cause
Solution
References


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