ASNOut Message for a Return with Line Item with Zero Shipped Quantity from SIM Fails in RMS (Doc ID 2124944.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

NOTE: The issue described in this note is observed in both SIM versions 14.0.X and 14.1.X. This note provides solution for both versions. Please apply the solution specific to your current version of SIM.

 

In Store Inventory Management (SIM) application, we find that when a Store to Warehouse transfer is dispatched with zero quantity for an item on the transfer, the ASNOut message published by SIM fails in Retail Merchandising System (RMS) with the following error:

javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit BOL_SQL.SEND_TSF.; nested exception is: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit BOL_SQL.SEND_TSF. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit BOL_SQL.SEND_TSF.
com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit BOL_SQL.SEND_TSF. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit BOL_SQL.SEND_TSF.
at com.retek.rib.binding.subscriber.impl.PlsqlSubscriberCoreServiceImpl.subscribe(PlsqlSubscriberCoreServiceImpl.java:71)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMessageSubscriberEjb.java:377)
at com.retek.rib.collab.HospitalController.performHandlerCall(HospitalController.java:382)
at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:288)
at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:190)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(RIBMessageSubscriberEjb.java:218)


Steps to Recreate:

1. In RMS, create a transfer from store to warehouse (either using Mass Return Transfer -MRT- function or manual) for two items:
    Item A: transfer qty = 2
    Item B: transfer qty = 2
2. Submit and Approve this transfer from store to warehouse
3. In SIM, this store to warehouse transfer is viewed as RETURN TO WAREHOUSE REQUEST in SIM
4. In SIM, open this RETURN TO WAREHOUSE REQUEST
5. Enter the return Qty as follow:
    Item A: enter return qty = 2
    Item B: enter return qty = 0
6. DISPATCH the return in SIM
7. Find the above error in RMS database table RIB_MESSAGE_FAILURE

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