AVG_COST is Updated as Null in IITEM_LOC_SOH Table For Item Having UNIT_COST Zero
Last updated on APRIL 09, 2018
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.
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