My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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 = January 5

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 January 7
5.Run tsfclose and docclose batch.
6.Check ITEM_LOC_SOH table, TSF_EXPECTED and TSF_RESERVED have negative values.

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
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.