Cannot Book Order: Error ORA-6502: Character Buffer Too Small (Doc ID 374545.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Order Management - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
OEXOEORD
***Checked for relevance on -5-May-2015***


Symptoms

The user cannot book an order


ERROR

Order is not eligible for booking. Check workflow status for this order.

The workflow status gives the following:

Activity Error Details
Activity Book
Result Exception
Error Name -6502
Error Message ORA-06502: PL/SQL: numeric or value error: character string
buffer too small
Error Stack Wf_Engine_Util.Function_Call(OE_BOOK_WF.BOOK_ORDER, OEOH, 3787173,
71014, RUN)

STEPS

1. Go to OM SuperUser Responsibility
2. Navigate to Order, Returns > Sales Orders
3. Try to book an order

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms