Incorrect Total Retail in TRAN_DATA Table After Stock Variance Posting (Doc ID 1936457.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.7 [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 a stock count for a warehouse (WH) is made, and if the retail cost is changed for some reason during the stock count, STKVAR posts the variance to the TRAN_DATA table using the old retail value.


Steps to Reproduce:

  1. Initiate a stock count for WH.
  2. Take snapshot of qty and retail.
  3. Perform a price change for a few items to change the retail value.
  4. Upload stkupld file to populate qty and complete the steps of the stock count.
  5. During variance posting, notice the total retail value in TRAN_DATA.  The value is populated with the old retail value.

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