My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.