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 laterInformation 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 |