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 [Release 11.5]
Oracle Order Management - Version 11.5.9 to [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 30-SEP-2013


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.

Evaluate_Between: ORA-06502: PL/SQL: numeric or value error)

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

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



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