STOCK_ORD_RCV_SQL Throws "ORA-01476: divisor is equal to zero" Error

(Doc ID 2083557.1)

Last updated on MARCH 15, 2018

Applies to:

Oracle Retail Merchandising System - Version 13.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".

Changes

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