My Oracle Support Banner

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:

  1. 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.
  2. Run saexprocsales.ksh
  3. 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

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