TSF_EXPECTED and TSF_RESERVED Have Negative Values in ITEM_LOC_SOH Table (Doc ID 1583710.1)

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.

Symptoms

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.

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