STOCK_ORD_RCV_SQL Throws "ORA-01476: divisor is equal to zero" Error (Doc ID 2083557.1)

Last updated on APRIL 15, 2021

Applies to:

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".

Cause

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