My Oracle Support Banner

STAKE_SKU_LOC Table Is Not Updated For Late Posted Shipment (Doc ID 2306498.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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


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




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

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