SOH Not Updated In SIM And RMS When A Stock Count With 900 Discrepant Items Is Authorized (Doc ID 853694.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 12 to 13.1 [Release 12.0 to 13.1]
Information in this document applies to any platform.
This note is applicable to all versions of SIM from 12.0.x to 13.1.x and can occur while performing any Transaction online or during the execution of batches.


Symptoms

In Store Inventory Management (SIM) system, when a Stock Count containing more than 900 discrepant item is authorized, the inventory adjustments are not created. The Stock On Hand (SOH) is not updated in SIM and also in Retail Merchandising System (RMS). However, the Stock Count is marked as "authorized".

Steps To Reproduce:

  1. Create Product Group for a dept which contains 3000 items 
  2. Create Product Group Schedule
  3. Execute "ExtractStockCount.sh" batch
  4. Take snapshot for the Stock Count
  5. Update Stock Count's counted quantity
  6. Check discrepant items and ensure that a minimum of 900 discrepant items exist
  7. Authorize Stock Count 
  8. Observe that the Stock Count status gets updated, but no inventory adjustments are created
  9. Also observe that the SOH for the discrepant items is not updated
  10. Check the relevant Retail Integration Bus (RIB) e-ways and notice that no inventory adjustment messages were published to RMS
  11. This issue prevents users from authorizing Stock Counts containing multiple discrepant items

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