Interface Trip Stop Fails With Error(s) Occured In Oracle Pricing: Routine :QP_PREQ_PUB.Calculate_Price ORA-00001: Unique Constraint (QP.QP_PREQ_LDETS_TMP_U1) Violated Due To Duplicate Price Adjustments
(Doc ID 3007221.1)
Last updated on MARCH 01, 2024
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Interface Trip Stop errors with the following:
line details: before update
line details: before insert
Error in calculate_priceORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
error in fetch_adjustments: User-Defined Exception
error in fetch_adjustments: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
Exception Calculate_price: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
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 price line for E
error in Handle_Bulk_Mode_Per_Order User-Defined Exception
ENTER Save_API_Messages
l_errmsg User-Defined Exception
L_MSG_DATA=Error(s) occured in Oracle Pricing: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
Order Number :3370765 Line Number :
Message :Error(s) occured in Oracle Pricing: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
EXIT Save_API_Messages
error in Handle_Bulk_Mode User-Defined Exception
ship_confirm_new EXC ERROR: User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 1
rollback to om_ship_confirm
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 02/01/2024 01:19:33 PM
l_return_status ==> E
NO. OF OE MESSAGES :1
line details: before insert
Error in calculate_priceORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
error in fetch_adjustments: User-Defined Exception
error in fetch_adjustments: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
Exception Calculate_price: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
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 price line for E
error in Handle_Bulk_Mode_Per_Order User-Defined Exception
ENTER Save_API_Messages
l_errmsg User-Defined Exception
L_MSG_DATA=Error(s) occured in Oracle Pricing: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
Order Number :3370765 Line Number :
Message :Error(s) occured in Oracle Pricing: Routine :QP_PREQ_PUB.Calculate_price ORA-00001: unique constraint (QP.QP_PREQ_LDETS_TMP_U1) violated
EXIT Save_API_Messages
error in Handle_Bulk_Mode User-Defined Exception
ship_confirm_new EXC ERROR: User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 1
rollback to om_ship_confirm
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 02/01/2024 01:19:33 PM
l_return_status ==> E
NO. OF OE MESSAGES :1
STEPS
-----------------------
The issue cannot be reproduced at will as its data corruption.
1. Order Management Super User Responsibility
2. Shipping > Interfaces
3. Interface Trip Stop
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 |