My Oracle Support Banner

RIB Receipts Issue | ORA-01476: Divisor Is Equal To Zero (Doc ID 2775878.1)

Last updated on MAY 26, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms


RIB is throwing the below error for Receipts

javax.ejb.EJBException: Error while calling Injector Service.: Client received SOAP Fault from server: EJB Exception: : java.lang.RuntimeException: Exception calling plsql inject. Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit DISTRIBUTION_SQL.DISTRIBUTE_ORDRCV_ADJ.
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.invokeInjectForMessageType(PlsqlApplicationMessageInjectorServiceBean.java:181)

Steps to recreaet:
1. Choose a PO which has never been received.
2. Send a RIB message with <receipt_xactn_type>A for one item and choose unit qty as -1.
3. See the below error message in RIHA-RMS.

javax.ejb.EJBException: Error while calling Injector Service.: Client received SOAP Fault from server: EJB Exception: : java.lang.RuntimeException: Exception calling plsql inject. Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit DISTRIBUTION_SQL.DISTRIBUTE_ORDRCV_ADJ.



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.