PACK_COMP_RESV And TSF_EXPECTED_QTY Buckets are Going Negative For Pack Item Components When Transfer Is Cancelled By TSFCLOSE Batch (Doc ID 2231058.1)

Last updated on FEBRUARY 14, 2017

Applies to:

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

Symptoms

Transfer Reserve and Expected buckets are going negative for pack item components after tsfclose batch is run.

Steps to recreate:
The issue can be reproduced at will with the following steps:

  1. Create a transfer in RMS with a pack item. Observe the STOCK_ON_HAND, TSF_RESERVED_QTY, TSF_EXPECTED_QTY, PACK_COMP_RESV, PACK_COMP_EXP buckets for pack and its component at both locations.
  2. Cancel all transfer quantity of the above transfer from back end script(using base function RMSSUB_SOSTATUS.CONSUME). Note that reserved and expected buckets corresponding to this transfer are cleared.
  3. Change the UNIT_OPTIONS of AUTO_CLOSE_DAYS such that TSFCLOSE batch picks the transfer in it next run.
  4. Run TSFCLOSE batch.
  5. Note that the transfer status changes to 'D'. Reserved and Expected buckets for the pack item component are reduced again.

 

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