Tsf Buckets Misaligned when Shipment Is Done for a Closed Transfer (Doc ID 2211177.1)

Last updated on DECEMBER 07, 2016

Applies to:

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

Symptoms


TSFBUCKETS in ITEM_LOC_SOH and TSFDETAIL are misaligned when the TSF is closed and the status is changed to "D" and then shipment and picking is done .

Steps to Reproduce:

  1. Create an externally generated transfer via RIB.
  2. Verify the tables TSFHEAD, TSFDETAIL and ITEM_LOC_SOH.
  3. Increase the vdate such that VDATE > TSF_CREATE_DATE + WS_AUTO_CLOSE_DAYS.
  4. Run the TSFCLOSE, DOCCLOSE PRE and DOCCLOSE Batches.
  5. Verify the tables TSFHEAD, TSFDETAIL and ITEM_LOC_SOH.  Note the status in the TSFHEAD will be "D" and the TSF_RESERVED_QTY and TSF_EXPECTED_QTY is changed to 0.
  6. See that EC_TABLE_THD_AIUDR was enabled and no RIB message was sent to downstream stating the TSFHEAD is changed to "DELETED".
  7. Do a picking for this transfer.
  8. Create a shipment for this transfer.
Ideally once the transfer is closed/deleted by the tsfclose/docclose batch the information should be sent to the downstream and
should delete or make the transfer inactive by EC_TABLE_THD_AIUDR which is not done. Due to which when RWMS sends the Picking and shipment message to RMS for the closed transfer the data
is consumed and the buckets in TSFHEAD and ITEM_LOC_SOH are Misaligned .

Changes

 

Cause

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