Convert Quote To Order Error - Failed in SET_PRAMETERS procedure (Doc ID 1990750.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


When attempting to convert a Quote to an Order, the following error occurs.

Error


Failed in SET_PRAMETERS procedure
APP-236112: Error messages from Order Management
APP_236113: Error in Line: 1.0 :Error: Failed in SET_PRAMETERS procedure
APP-236049: There is an error in order submission.

 

Log files show the following :-

ZX_TAXWARE_TAX_SERVICE_PKG.SET_PARAMETERS Failed in setting the parameters
ZX_TAXWARE_TAX_SERVICE_PKG.SET_PARAMETERS Error is :-6502ORA-06502: PL/SQL: numeric or value error: character string buffer too small



Steps


1. Navigate to Customer Service/eBusiness Center/
2. Query by Organization and customer number/click on the Quote Tab/
3. Select the quote to be converted and click on Details to open the quote/
4. When the quote is open, click on Place Order/ Get 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