AVG_COST is Updated as Null in IITEM_LOC_SOH Table For Item Having UNIT_COST Zero

(Doc ID 2378986.1)

Last updated on MAY 11, 2018

Applies to:

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

Symptoms

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.

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