My Oracle Support Banner

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 DECEMBER 04, 2019

Applies to:

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


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

Steps to Recreate:

  1. Create a transfer in Retail Merchandising System(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.I personally acknowledge I have thoroughly reviewed this document and confirm it does not contain any CI or PI information





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

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