My Oracle Support Banner

AVG_COST is Updated as Null in IITEM_LOC_SOH Table For Item Having UNIT_COST Zero (Doc ID 2378986.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.


AVG_COST column is updated as null in ITEM_LOC_SOH table for item having UNIT_COST zero.

Steps To Recreate:

1. Create an item having UNIT_COST zero and do not range the item to any of the locations.
2. Create a Purchase order directly for that item for any location without initially ranging the item to the location for which PO is being raise for.
3. Save the PO and query the ITEM_LOC_SOH table for the item-loc combination for which PO is raised.
4. Notice that the AVG_COST will come as null in this scenario.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.