Incorrect Sign on TOTAL_RETAIL Amount Column in TRAN_DATA_HISTORY Table for Tran Code 11 And 13 Transactions
(Doc ID 1674400.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle Retail Merchandising System - Version 188.8.131.52 and later
Information in this document applies to any platform.
This article will be updated as official patch information becomes available.
Negative tran code 11 and 13 transactions are posting to TRAN_DATA_HISTORY with the incorrect sign on the TOTAL_RETAIL amount.
Values are being posted with negative units (correct) and positive total retail amounts (incorrect).
Steps To Recreate:
1. Create and fully ship a transfer in RMS between two locations for an item with a different retail price at each location.
2. Under-receive the transfer at the destination location.
3. Run the Docclose.pc program to close the transfer.
4. Tran_code 11 or tran_code 13 record is written to TRAN_DATA with a negative units value, but with positive TOTAL_RETAIL value.
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