My Oracle Support Banner

DOCCLOSE Batch Not Clearing TSF_RESERVED_QTY And TSF_EXPECTED_QTY Even After Closing the Transfer (Doc ID 2619890.1)

Last updated on DECEMBER 16, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.6 and later
Information in this document applies to any platform.

Symptoms

DOCCLOSE batch not clearing TSF_RESERVED_QTY And TSF_EXPECTED_QTY in ITEM_LOC_SOH Table.

Steps To Recreate:

Case 1: Partially shipped , Fully Received.

  1. Create a warehouse to store transfer with TSF_QTY : 50.
  2. Perform shipment. SHIP_QTY : 20.
  3. Perform Receiving. RECEIVED_QTY : 20.
  4. Run DOCCLOSE batch.
  5. Transfer is closed however TSF_RESERVED_QTY And TSF_EXPECTED_QTY in ITEM_LOC_SOH Table is not been cleared.

Case 2: Partially Shipped, Partially Received.

  1. Create a warehouse to store  transfer TSF_QTY : 50.
  2. Perfrom shipment. SHIP_QTY : 20.
  3. Perform Receiving. RECEIVED_QTY : 10.
  4. Run DOCCLOSE batch.
  5. Transfer is closed however TSF_RESERVED_QTY And TSF_EXPECTED_QTY in ITEM_LOC_SOH Table is not been cleared.

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.