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

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

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.

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