My Oracle Support Banner

Push Visit into Production Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package AHL_PRD_WORKORDER_PVT Procedure PROCESS_JOBS" (Doc ID 1352824.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Jan-2016***

Symptoms

When attempting to Push a Visit into Production the following error occurs.


ERROR
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package AHL_PRD_WORKORDER_PVT Procedure PROCESS_JOBS


STEPS
1. (R) Complex MRO responsibility
2. From Planning module create an MR which has an Operation attached whose Description is longer than 240 chars and contains Junk (non-English) character(s).
3. Add the MR into a Visit and attempt to Push the Visit into Production
4. The step is failing with error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package AHL_PRD_WORKORDER_PVT Procedure PROCESS_JOBS"

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.