My Oracle Support Banner

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 JANUARY 25, 2021

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.0 [Release 11.5 to 12.0]
Oracle Order Management - Version 11.5.10.0 to 12.0.0 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.