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

Last updated on JULY 21, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information 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".

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms