My Oracle Support Banner

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 OCTOBER 08, 2019

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Oracle 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

1st 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 5067745




2nd 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 5073284

STEPS
The issue can be reproduced at will with the following steps:
1. Ship confirm order

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


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