My Oracle Support Banner

STKUPLD Does Not Update STAKE_SKU_LOC.PHYSICAL_COUNT_QTY Properly (Doc ID 2009975.1)

Last updated on OCTOBER 31, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.2.x, we find that when the volume of stock count records to be processed is more than 4.5 times the value set in RESTART_CONTROL.COMMIT_MAX_CTR, STKUPLD is updating different values to the STAKE_SKU_LOC and STAKE_CONT tables.

Steps to Reproduce:

  1. Suppose the value of RESTART_CONTROL.COMMIT_MAX_CTR is 3000.
  2. Set up a stock count for 20 stores with about 700 items in each store (14,000 records).
  3. Execute STKXPLD, STKUPD and upload a count file using STKUPLD.
  4. Note that for some store items, STAKE_SKU_LOC and STAKE_CONT have different values.


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.