INVENTORY: Negative Tsf_reserved_qty & Tsf_expected_qty (Doc ID 3006336.1)

Last updated on FEBRUARY 26, 2024

Applies to:

Symptoms

Seeing negative tsf_reserved_qty & tsf_expected_qty in ITEM_LOC_SOH. This is causing incorrect quantities in replenishment and allocations.

Some investigations have highlighted one potential cause. Using the below SQL, it can be seen the QTY_DISTRO is 0, whilst the QTY_TRANSFERRED is populated this could be the cause of the negative TSF_EXPECTED_QTY. 1924 is the source DC

select ah.item, ils.stock_on_hand, ils.tsf_reserved_qty ,ad.*
from alloc_header ah, alloc_detail ad, item_loc_soh ils
where ah.alloc_no = ad.alloc_no
and ah.item = ils.item
and ah.wh = ils.loc
and ah.item in (select item from item_loc_soh where tsf_reserved_qty < 0 and item = '[the item number]')
and ah.wh = '[the warehouse number]'

The second SQL is similar to the above, but the QTY_DISTRO is also negative. 1924 is the source DC

select ah.item, ils.stock_on_hand, ils.tsf_reserved_qty ,ad.*
from alloc_header ah, alloc_detail ad, item_loc_soh ils
where ah.alloc_no = ad.alloc_no
and ah.item = ils.item
and ah.wh = ils.loc
and ah.item in (select item from item_loc_soh where tsf_reserved_qty < 0 and item = '[the item number]')
and ah.wh = '[the warehouse number]'

Changes

 No Changes were made

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.