My Oracle Support Banner

Receiving Message with Zero Av_cost Fails with ORA-01476 by STOCK_ORDER_RCV_SQL.DETAIL_PROCESSING (Doc ID 2278810.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Retail Integration Bus - Version 13.2.7 and later
Information in this document applies to any platform.


Shipments that contained an item with zero av_cost caused Receiving messages to fail in the RMS RIB hospital (RIHA).

ORA-01476 divisor is equal to zero returned by program unit STOCK_ORDER_RCV_SQL.DETAIL_PROCESSING

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Create a warehouse to store transfer for an item.
2. Make sure this item has an av_cost = 0 on the ITEM_LOC_SOH table at the warehouse.
3. Create the Advance Shipping Notice (ASN).
4. Receive the ASN for the store in Store Inventory Management (SIM).
5. The resulting Receiving message fails in the RMS RIB hospital.




To view full details, 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 a vibrant support community of peers and Oracle experts.