STAKE_SKU_LOC Table Is Not Updated For Late Posted Shipment

(Doc ID 2306498.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.6 and later
Information in this document applies to any platform.

Symptoms

Late posted shipment is not affecting in progress stock counts.

 

Steps to reproduce:

  1. Create a stock count for store with Amount and Unit type and at dept level  (stock count date=vdate+1)
  2.  Take the system snapshot on stocktake date (vdate+1)
  3.  Check the STAKE_SKU_LOC
  4.  Create 1 transfer from external system for one item that is not ranged to the location, but is part of dept used for Stock count.
     ASNOut message is sent for dispatching the transfer for same date as stocktake_date.

    Notice that non range item was ranged to the location (item_loc and item_loc_soh, tran_data is populated) no updates in STAKE_SKU_LOC 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