When Book A Sales Order Shows Pricing Error QP_QPREQ_GRP.PRICE_REQUEST This Attribute is Defined as Numeric but Pass as Non-Numeric

(Doc ID 1300385.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders


Symptoms


=== ODM Issue Clarification ===

On : 12.1.1 version, Pricing, Discounting & Charges

When attempting to book a sales order,the following error occurs.

ERROR
-----------------------
Error(s) occured in Oracle Pricing: Exceptionin QP_QPREQ_GRP.PRICE_REQUEST This Attribute(with Context: CGP_CO and Attribute: CGP_CO) is defined as numeric but pass as non-numeric/Errored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: OM Superuser
2. Navigate to: Orders, Returns > Sales Order
3. Attempt to book a sales order for a customer that does not use pricing attribute CGP_CO

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot book some sales orders.

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