Incorrect WAC Calculation For Reconciliation SL Type (Doc ID 2972556.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Symptoms

The WAC calculation for the SL transfer treatment reconciliation is using the current WAC of the sending location and not the original cost on the transfer.

Steps To Reproduce:

1. Set the TSF_CLOSE_OVERDUE to ‘Y’.
2. Set the TSF_FORCE_CLSE_IND to ‘SL’.
3. Set the WS_AUTO_CLOSE_DAYS to 1.
4. Make sure the WH and Store have current Soh > 0.
5. Create and ship a transfer from a WH to a Store and receive no merchandise.
6. Note the WAC at the store and the WH.
7. Change the WAC at the WH using the average cost adjustment form to a very different value.
8. Change the vdate to be 2 days later than the transfer ship date above.
9. Run tsfclose, docclose pre and docclose.

Note: WAC at the sending and receiving location is updated using the current WAC at the WH and not the cost of the transfer at the time of the original shipment.

Cause

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