Incorrect Sign on TOTAL_RETAIL Amount Column in TRAN_DATA_HISTORY Table for Tran Code 11 And 13 Transactions
Last updated on MARCH 24, 2017
Applies to:Oracle Retail Merchandising System - Version 126.96.36.199 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 Retail Merchandising System (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.
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