Get Error QP_PREQ_GRP.HANDLE_BREAK ORA-06502 numeric or value error On Entering Sales Order For Discount Price On Item (Doc ID 338835.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.0.6 [Release 11.5 to 12.0]
Information in this document applies to any platform.
Checked for relevance on 26-SEP-2014


Symptoms

When we get to the line item and select the item and save or go to the next line we get the following error.
ONT_PRICING_ERROR (ERR_TEXT=Routine: QP_PREQ_GRP.GET_ELIGIBLE_PRICE_BREAK:
Routine:QP_PREQ_GRP.HANDLE_BREAK: ORA-06502: numeric or value error)
Order does not save.

Also you see the following in the OM debug log file created from the Sales Order form ..

Routine: QP_PREQ_GRP.GET_ELIGIBLE_PRICE_BREAK:

Routine: QP_PREQ_GRP.HANDLE_BREAK: ORA-06502:PL/SQL: numeric or value 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