TSFCLOSE Does Not Close Partially Received Transfers After AUTO_CLOSE_DAYS Have Elapsed

(Doc ID 1923963.1)

Last updated on JANUARY 18, 2018

Applies to:

Oracle Retail Merchandising System - Version 13.2.7 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.2.x, the TSFCLOSE (transfer close) batch is not updating RESERVED and EXPECTED QTY in ITEM_LOC_SOH table.

Steps to Reproduce:

  2. Create a warehouse (WH) to Store transfer for item X and quantity 10 units.
  3. Partially ship the transfer of only 8 units.
  4. Receive the 8 shipped units.
  5. Run DTESYS.
  6. Run TSFCLOSE.
  7. Notice that the ITEM_LOC_SOH table is not updated.
  8. Create an item, and verify that stock on hand in ITEM_LOC_SOH exists for WH and STORE.
  9. Created externally-generated (EG) transfer from PHYSICAL WH to STORE.
  10. See ITEM_LOC_SOH; TSF_RESERVE_QTY for WH is updated to transfer qty.
  11. Run TSFCLOSE batch after setting WS_AUTO_CLOSE_DAYS to 1 and increasing the VDATE by 1 day. 
    TSFHEAD has status as D, but ITEM_LOC_SOH.TSF_RESERVE_QTY still shows same as Transfer qty.  It should decrease.
  12. Create EG transfer to store and from store and ship the transfer.  Do not receive.
  13. Run TSFCLOSE for the above created transfer, satisfying all the pre-requisite conditions for TSFCLOSE to pick the transfer. 
  14. Check ITEM_LOC_SOH table for the item; it is not updated.


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