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 MARCH 24, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.1.5.1 and later
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
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.

 

Cause

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 hundreds of Community platforms