My Oracle Support Banner

The WAC Is Recalculated On Both From And To Location While Posting SL (Doc ID 2997176.1)

Last updated on JANUARY 10, 2024

Applies to:

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

Symptoms

Thare are two behaviors observed in which WAC is recalculated incorrectly when reconciling a transfer, if any transactions performed on the items on the transfer during the period of shipping and reconciling.

STEPS TO REPRODUCE :

I have noticed this pattern on 2 systems setup :


1.When system option TSF_AUTO_CLOSE_ST/WH is set to Y, and below steps are executed :

  i. Create a transfer with 2 items at least (attached proof of ST-ST)
  ii. Ship the transfer completely
  iii. Perform any transaction which will update WAC on to_loc (line AV Cost Change)
  iv. Receive 1 item from SIM
  v. Observe that the remaining item is reconciled automatically, WAC is recalculated on both from and to_location (to_loc recalculated WAC is not even related)
  vi. Receive the remaining Item at a later stage, see again WAC is recalculated on the to_loc. On both location stock reconciliation of (Open stock value and transactions) against closing stock value doesnt match.

2. When system option TSF_AUTO_CLOSE_ST/WH is set to N, docclose with SL is enabled, and below steps are executed :

  i. Create a transfer with 2 items at least (attached proof of ST-ST)
  ii. Ship the transfer completely
  iii. Perform any transaction which will update WAC on to_loc (line AV Cost Change)
  iv. Receive 1 item from SIM
  v. Run the docclose to close the transfer, SL is posted for the remaining item. WAC is recalculated on both from and to_location (to_loc recalculated WAC is not even related)

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.