STOCK_ORD_RCV_SQL Throws "ORA-01476: divisor is equal to zero" Error
(Doc ID 2083557.1)
Last updated on MARCH 09, 2019
Applies to:
Oracle Retail Merchandising System - Version 13.2 and laterInformation in this document applies to any platform.
Symptoms
STOCK_ORD_RCV_SQL throws below error message , during receiving in different cases.
Error:
com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero devuelto por la unidad de programa STOCK_ORDER_RCV_SQL.DETAIL_PROCESSING.
Caused by: com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-01476
Steps to Reproduce:
Scenario 1:
1. Create Transfer From Warehouse to Store with one Item that is a Simple Pack and with unit_cost 0.
2. Dispatch Transfer from Warehouse Management System (WMS).
3. Receive the Advance Shipping Notice (ASN). The receipt will be in Retail Integration Bus (RIB) Hospital with an error, ORA-01476: divisor is equal to zero.
Scenario 2:
1. Create AV_COST of the component item of the pack item is 0.
2. Receive the pack item through RMSSUB_RECEIVING.CONSUME.
3. Check the Error. It shows error as "ORA-01476: divisor is equal to zero".
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 |