My Oracle Support Banner

Unit Cost and Average Cost Appear as Null or 0 In ITEM_LOC_SOH Table (Doc ID 1906051.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Retail Merchandising System - Version to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.1.x, Unit Cost and Average Cost appear as NULL or 0 in the ITEM_LOC_SOH table when adding a supplier.

Steps to Reproduce:

  1. Create an item with item type as 'Regular' and with Orderable Indicator - No, Sellable Indicator - Yes, Inventory Indicator - No.
  2. Fill all the mandatory fields except the Supplier link.
  3. Range the item to the locations.
  4. Approve the item and click OK.
  5. Make a note of the ITEM_LOC_SOH table values for unit cost and average cost.  They will be 0 or null.
  6. Go back to the same item created in step 1 and associate the supplier.
  7. In the Item Supplier Country screen, assign the unit cost.
  8. Commit all changes.
  9. Now review the ITEM_SUPP_COUNTRY table and ITEM_LOC_SOH tables.  Note that the unit cost exists only in ITEM_SUPP_COUNTRY table.


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.