Incorrect Units and Total Retail Posted in Transactions of Multiple Discount Lines
(Doc ID 2822625.1)
Last updated on NOVEMBER 19, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.
When a sale contains multiple sales lines for the same item and one of the lines has multiple discount lines, the are 2 sales records created in TRAN_DATA but the record with the multiple discount lines has an incorrect UNITS and incorrect TOTAL_RETAIL.
Steps To Recreate:
- Load a sale containing multiple sales lines with the same item (i.e. same ITEM on 2 or more SA_TRAN_ITEM records) with each having quantity 1. Make sure one of the lines in SA_TRAN_ITEM has multiple discount lines in SA_TRAN_DISC.
- Run saexprocsales.ksh
- Notice that 2 sales records (TRAN_CODE = 1) are created in TRAN_DATA, but the UNITS and TOTAL_RETAIL on the line with discounts is incorrect.
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