LAST_RECEIVED_DAY in RK_STORE_ITEM_SOH Table Is Getting Updated While Performing an Inventory Adjustment (Doc ID 2206756.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

LAST_RECEIVED_DAY in RK_STORE_ITEM_SOH is getting updated while performing an Inventory Adjustment.


Steps to Reproduce:

  1. Select an item which has LAST_RECEIVED_DAY as null in RK_STORE_ITEM_SOH.
  2. Create inventory adjustment in Store Inventory Management (SIM) for the item.
  3. The LAST_RECEIVED_DAY is column is getting updated with today's date.  This field is not expected to be updated for an inventory adjustment.

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