TSF_EXPECTED_QTY Is Incorrect For Catch Weight Items (Doc ID 1997228.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

The value in ITEM_LOC_SOH.TSF_EXPECTED_QTY grows quickly and does not get cleared down correctly. Calculation in BOL_SQL.UPD_TO_ITEM_LOC appear to be incorrect.
 
Steps to reproduce:

1. Start out with 0 values
2. NOTE: Average weight > pack_qty,
3. Set a SOH
4. Create a transfer from WH to Store
5. Approve – do not ship
6. Create another transfer from WH to Store
7. Approve – do not ship
8. Ship 1st Transfer (Notes: Store setup to auto receive)
9. Ship 2nd Transfer (Notes: Store setup to auto receive)
 
Actual result : TSF_EXPECTED_QTY has not been reduced back to 0
Expected result :TSF_EXPECTED_QTY should be reduced back to 0

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