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 FEBRUARY 03, 2019

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

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.