My Oracle Support Banner

Pack Item Is Not Updating Stock On Hand After Completion Of Stock Count (Doc ID 2538144.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

Store pack inventory - pack item is not updating Stock on Hand(SOH) after completion of stock count.

Steps to reproduce:

Case 1:

  1. Create a component item in RMS.
  2. Create a Simple pack item in RMS - with "store pack inventory". The component created at line 1 is assigned to the pack.
  3. Both item location information flows down to SIM.
  4. Create Third party stock count for the pack item.
  5. Upload the count file through batch - stock_count_line_item table updated the counted quantity as per file.
  6. Confirm authorization.
  7. No change in pack item inventory in store_item_stock table. However the stock count is completed.

Case 2.

  1. Create a comp item in RMS.
  2. Create a Simple pack item in RMS - with "store pack inventory". the comp created at line 1 s assigned to the pack.
  3. Both item location information flows down to SIM.
  4. Create unguided stock count for the pack item in SIM UI.
  5. Enter the count quantity in UI - stock_count_line_item table updated the counted quantity as per file.
  6. Confirm authorization.
  7. No change in pack item inventory in store_item_stock table. however the stock count is completed.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.