Sales Orders In Are Stuck In Shipped Status And Not Able To Interface Due to Error - ORA-01400: cannot insert NULL into ("QP"."QP_PREQ_LINE_ATTRS_TMP_T"."VALUE_FROM")
(Doc ID 2595110.1)
Last updated on FEBRUARY 07, 2023
Applies to:
Oracle Advanced Pricing - Version 12.2 and laterOracle Shipping Execution - Version 12.2 and later
Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.
Symptoms
On : 12.2.x version,
When attempting to ship confirm, the interface trip stop has the following errors.
ERROR
line details: before update
line details: before insert
Error in calculate_priceORA-01400: cannot insert NULL into ("QP"."QP_PREQ_LINE_ATTRS_TMP_T"."VALUE_FROM")
error in fetch_adjustments: User-Defined Exception
error in fetch_adjustments: Routine :QP_PREQ_PUB.Calculate_price ORA-01400: cannot insert NULL into ("QP"."QP_PREQ_LINE_ATTRS_TMP_T"."VALUE_FROM")
Exception Calculate_price: Routine :QP_PREQ_PUB.Calculate_price ORA-01400: cannot insert NULL into ("QP"."QP_PREQ_LINE_ATTRS_TMP_T"."VALUE_FROM")
Exception Price Request: User-Defined Exception
LEAVING OE_MSG_PUB.ADD
EXITING PRICE_LINE WITH EXC ERROR
Setting prcing error flag for mass change
Exiting oe_order_Adj_pvt.Price_line
After Header Price
After Executing Delayed request Price line for xxxxxxx
STEPS
The issue can be reproduced at will with the following:
Ship confirm order
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 |
| Cause |
| Solution |
| References |