My Oracle Support Banner

WSHINTERFACE: Open Shipping Transaction Error in calculate_price ORA-01476: Divisor is Equal to Zero, Prevents Inventory Close (Doc ID 746259.1)

Last updated on JULY 14, 2021

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Shipping Execution - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:WSHINTERFACE - Interface Trip Stop

Symptoms


Inventory Period Close issue with Order Number = <XXXXXX>

Order Number = <XXXXX> has 4 lines however the issue is with line 2.1 in an AWAITING_SHIPPING status and the associated Delivery for this line shows that the Delivery is Shipped , however not Interfaced to OM nor INV.  Therefore unable to execute "interface trip stop" on the delivery line.  Delivery status at "Shipped", with Next Step at "Run Interface".  Manually running Trip Stop provides a batch error

Error in calculate_priceORA-01476: divisor is equal to zero
error in fetch_adjustments: User-Defined Exception
error in fetch_adjustments: Routine :QP_PREQ_PUB.Calculate_price ORA-01476: divisor is equal to zero
Exception Calculate_price: Routine :QP_PREQ_PUB.Calculate_price ORA-01476: divisor is equal to zero
Exception Price Request: User-Defined Exception
LEAVING OE_MSG_PUB.ADD
EXITING PRICE_LINE WITH EXC ERROR
Exiting oe_order_Adj_pvt.Price_line
After price line for E
error in Handle_Bulk_Mode_Per_Order User-Defined Exception
error in Handle_Bulk_Mode User-Defined Exception
ship_confirm_new EXC ERROR: User-Defined Exception
LEAVING OE_MSG_PUB.COUNT_AND_GET 1
rollback to om_ship_confirm
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> <DATE>
l_return_status ==> E
NO. OF OE MESSAGES :1
no. of OE messages :1
Calling program unit OE_MSG_PUB.GET
ONT_PRICING_ERROR (ERR_TEXT=Routine :QP_PREQ_PUB.Calculate_price ORA-01476: divisor is equal to
zero)
Error msg: ONT_PRICING_ERROR (ERR_TEXT=Routine :QP_PREQ_PUB.Calculate_price ORA-
01476: divisor is equal to zero)
ERROR
Rollback to savepoint l_interface_om
No DCP Error
Inside Loop WSH_DCP_PVT.G_INIT_MSG_COUNT ==> 0
before deleting tables ==> 2
current index ==> 1
next index ==> is NULL
l_loop_count ==> 1
l_error_count ==> 1
l_warn_count ==> 0
Process Order Error
Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_STOP_TO_OM (<DATE>, .24 seconds)
Process_Stop_To_OM l_return_status ==> E
l_num_om_api_call ==> 1
l_num_om_errors ==> 1
l_num_om_warnings ==> 0
l_non_bulk_count ==> 0
l_num_errors ==> 0
l_num_warnings ==> 0
Entering WSH_UTIL_CORE.GET_MESSAGES (WSHUTCOB.pls 115.120.11510.13) (<DATE>)
P_INIT_MSG_LIST ==> N
Exiting WSH_UTIL_CORE.GET_MESSAGES (10/28/2008 08:35:11 AM, .01 seconds)
fnd_api.g_exc_error exception has occured.
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM - EXCEPTION:fnd_api.g_exc_error (<DATE>, .26 seconds)
Interface_Stop_To_OM l_return_status ==> E
Calling TRANSFER_SERIAL_NUMBERS FOR xxxxx
Entering WSH_SHIP_CONFIRM_ACTIONS.FILTER_STOPS_FROM_BATCH (WSHDDSHB.pls 115.310.11510.3)
(10/28/2008 08:35:11 AM)
p_batch_id ==> 469546
Failed to interface stop to OM ==> XXXXX
x_return_status ==> S
l_err_stops.count ==> 1
x_stop_tab.count ==> 1
l_all_stops_count ==> 1
x_num_stops_removed ==> 1
Exiting WSH_SHIP_CONFIRM_ACTIONS.FILTER_STOPS_FROM_BATCH (<DATE>, 0 seconds)
Failed to interface Batch 469546 to Order Management because API interface_header_to_OM failed
e_Interface_Stop_To_OM exception has occured.
x_completion_status ==> WARNING
Exiting WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP - EXCEPTION:e_Interface_Stop_To_OM
(<DATE>, .26 seconds)
INTERFACETRIPSTOP: RESULT OF OM INTERFACING BATCH_ID 469546 = WARNING
Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3)
(<DATE>)
p_num_stops ==> 1
p_batch_id ==> is NULL
X_MASTER_STATUS ==> NORMAL
P_API_STATUS ==> WARNING
X_NORMAL_COUNT ==> 0
X_WARNING_COUNT ==> 0
X_INTERFACED_COUNT ==> 0
X_MASTER_STATUS ==> WARNING
P_API_STATUS ==> WARNING
X_NORMAL_COUNT ==> 0
X_WARNING_COUNT ==> 1
X_INTERFACED_COUNT ==> 0
Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (<DATE>, .01 seconds)
Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3)
(10/28/2008 08:35:11 AM)
p_num_stops ==> 0
p_batch_id ==> is NULL
X_MASTER_STATUS ==> WARNING
P_API_STATUS ==> WARNING
X_NORMAL_COUNT ==> 0
X_WARNING_COUNT ==> 1
X_INTERFACED_COUNT ==> 0
X_MASTER_STATUS ==> WARNING
P_API_STATUS ==> WARNING
X_NORMAL_COUNT ==> 0
X_WARNING_COUNT ==> 1
X_INTERFACED_COUNT ==> 0
Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (<DATE>, 0 seconds)
l_api_completion_status ==> WARNING
l_previous_interface ==> TRUE
l_dsno_stop_tab.COUNT ==> 1
l_api_completion_status ==> WARNING

 

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

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