Sales Order Line Error(s) occurred in Oracle Pricing: ORA-01400: cannot insert NULL into ("QP"."QP_LIMIT_TRANSACTIONS"."PRICE_REQUEST_CODE")
(Doc ID 2745187.1)
Last updated on JANUARY 20, 2021
Applies to:
Oracle Order Management - Version 12 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.3 version, Pricing, Discounting & Charges
When attempting to enter a Line on a Sales Order, the following error occurs.
ERROR
Error(s) occurred in Oracle Pricing: ORA-01400: cannot insert NULL into
("QP"."QP_LIMIT_TRANSACTIONS"."PRICE_REQUEST_CODE")
STEPS
The issue can be reproduced at will with the following steps:
1. Via the Order Management Responsibility.
2. Navigate: Orders, Returns > Sales Orders
3. Sales Order form, Line Items for Order , attempt to add line, and the error is returned.
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 |
References |