My Oracle Support Banner

NAM Revenue Stage : Consignment Late Sales Inserting Consignment Items Into Stake_sku_loc (Doc ID 2787337.1)

Last updated on FEBRUARY 16, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.


Consignment Late Sales is inserting consignment items into stake_sku_loc after processing the sales.
Steps to recreate :

  1. Create a stock count for a store at a Division level . Ensure there are some item_soh_soh entries for consignment items at this store.
  2. Explode the stock count. Consignment items will not get exploded into stake_sku_loc table.
  3. Process late sales for a few consignment items for this store in RMS. Date needs to be prior to the stock count date.
  4. Observe consignment items are gets inserted into stake_Sku_loc which is not expected.


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.