PACK_COMP_RESV And TSF_EXPECTED_QTY Buckets are Going Negative For Pack Item Components When Transfer Is Cancelled By TSFCLOSE Batch
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.
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:
- 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.
- 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.
- Change the UNIT_OPTIONS of AUTO_CLOSE_DAYS such that TSFCLOSE batch picks the transfer in it next run.
- Run TSFCLOSE batch.
- Note that the transfer status changes to 'D'. Reserved and Expected buckets for the pack item component are reduced again.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms