My Oracle Support Banner

Duplicate Reversal TRAN_DATA Records for Tran Code 22 for Late Transfer Shipment or Allocation (Doc ID 1914996.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.8 [Release 13.2]
Oracle Retail Merchandising System - Version 12.0.1 to [Release 12.0]
Information in this document applies to any platform.


When a late transfer/allocation shipment message (for a pack item) is posted to Oracle Retail Merchandising System (RMS) such that a stock count already exists against the shipping warehouse (WH), the TRAN_DATA table has two records with TRAN_CODE '22' for the same item-warehouse combination.

Steps to Reproduce:

1. Prepare a transfer or an allocation and approve, but do not ship yet.
2. Create a stock count at WH.
3. Continue the stock count until count adjustment (stkvar.pc).
4. Capture TRAN_DATA.
5. Ship the transfer or the allocation by simulating a late shipment (e.g., ship date before stock count date).
6. Capture TRAN_DATA, and notice the reversal TRAN_CODE 22.


To view full details, 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 a vibrant support community of peers and Oracle experts.