Receive Error ONT_PRICING_ERROR When Tabbing Out Of Quantity Field On Sales Order Form
Last updated on JULY 14, 2016
Applies to:Oracle Advanced Pricing - Version 11.5.9 to 22.214.171.124 [Release 11.5]
Oracle Order Management - Version 11.5.9 to 126.96.36.199 [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
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