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.

Symptoms

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.

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