My Oracle Support Banner

Negative Tsf_reserved_qty And Tsf_expected_qty (Doc ID 2868895.1)

Last updated on JANUARY 26, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

Negative tsf_reserved_qty and tsf_expected_qty for some item / locs.
Should not exist negative values for tsf_reserved_qty and tsf_expected_qty in database.

Steps to reproduce:


1. Create PO for 100, fully allocated.
2. Receive 50. po_rcvd_qty = 50. tsf_reserved_qty = 50
3. Don't ship allocation. Qty_allocated = 100, qty_transferred = 0.
4. Send 'SD' message for 100 qty. Note the tsf_reserved qty = 50 - 100 = -50.

Changes

 

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