TSF_EXPECTED and TSF_RESERVED Have Negative Values in ITEM_LOC_SOH Table
Last updated on JULY 21, 2017
Applies to:Oracle Retail Merchandising System - Version 13.0.5 to 13.0.7 [Release 13.0]
Information in this document applies to any platform.
TSF_EXPECTED and TSF_RESERVED have negative values in ITEM_LOC_SOH table after running docclose batch.
Steps to Reproduce:
Set VDATE = April 5, 2013.
1.Create a manual transfer from a warehouse (WH) to a store (quantity = 100) for a regular item.
2.Ship 50 units only.
3.Receive 100 units even if 50 units were shipped.
4.Change VDATE to April 7, 2013.
5.Run tsfclose and docclose batch.
6.Check ITEM_LOC_SOH table, TSF_EXPECTED and TSF_RESERVED have negative values.
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