Place Order from Custom Quoting Responsibility Error: "APP-236049: There is an error in order submission" Debug Log Error: "ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer too Small" (Doc ID 1465513.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Test and Prod:  12.1.3 version, FORMS User Interface

When attempting to place an order, the following error occurs.

Error

APP-236049: There is an error in order submission

 

Debug Log File error

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

Steps to Reproduce
The issue can be reproduced at will with the following steps:

  1. Responsibility: Oracle Quoting Sales Agent FORMS (custom responsibility)
  2. Navigation: Quote
  3. Query Quote
  4. Click the "place order" button 
  5. Receive error



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