Receive Error ONT_PRICING_ERROR When Tabbing Out Of Quantity Field On Sales Order Form

(Doc ID 393979.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Advanced Pricing - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Oracle Order Management - Version 11.5.9 to 11.5.10.3 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders
Checked for relevance on 30-SEP-2013



Symptoms

On 11.5.9 in Production:
When attempting to enter an order line using a specific price list, upon tabbing out of the Qty
field at line level the following error occurs.

ERROR
ONT_PRICING_ERROR(ERR_TEST=ROUTINE:QP_PREQ_GRP.LIST_HEADER_SEARCH
Evaluate_Between: ORA-06502: PL/SQL: numeric or value error)


STEPS
The issue can be reproduced at will with the following steps:
1. Via OM Super User responsibility.
2. Navigate Orders Returns, Sales Orders
3. Create a new sales order for specific price list and enter customer, order type, price list,
    go to Lines tab, enter item number, enter quantity, tab - error occurs


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot enter a sales order line for this price list.


.

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