A Negative Transaction Recalculates WAC To The Higher Side

(Doc ID 2341630.1)

Last updated on DECEMBER 22, 2017

Applies to:

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

Symptoms

A negative transaction recalculates Weighted Average Cost (WAC) to the higher value in ITEM_LOC_SOH.

Steps to reproduce :
Prerequisite : Create an item/location whose WAC is positive ( Ex: 14.9).
1. Create a negative transaction and load the STAGE_EXT_TRAN_DATA using Trandataload.ksh
2. Ensure that STAGE_EXT_TRAN_DATA.WAC_RECALC_IND = 'Y' and the units are negative units Ex "-2".
3. Run the Trandataprocess.ksh
4. Even though the transaction is -2 the WAC is increased in ITEM_LOS_SOH to 15.02.

Changes

 

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