My Oracle Support Banner

In-transit Goes Negative When Receiving Against A Closed Transfer (Doc ID 2450319.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.


RMS In-transit Qty in ITEM_LOC_SOH  goes negative when receiving against a closed transfer.

Steps to reproduce: 

1. Set the WH->ST and ST->ST parameters to 1 day.
2. Create a transfer with two items for a store to store transfer. Item a – 3 units Item B – 1 unit. This could be a WH to Store transfer as well.
3. In SIM, fully ship both items. For item A, ship the 3 units in different cartons (i.e. Item A Carton 001 Ship 1, Item A Carton 002 Ship 1, Item A Carton 003 Ship 1).
4. In RMS close the transfer or alternatively advance VDATE and run the TSFCLOSE(Transfer Close)/DOCCLOSE(Document Close) jobs to close the transfer.
5. The in-transit qty for both items is set to zero and there are negative transaction code 22 records written TRAN_DATA for all items on the transfer.
6. Now go back to SIM or WMS and fully receive Item A.
7. Note that the in-transit goes negative, three additional negative transaction code 22 records are written and the Transaction Code 44 records are written for the receipt. The amount of negative Tran code 22 records written equals how much the in-transit goes negative.





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.