My Oracle Support Banner

The Qty_Ordered Extracted by Edidlord Is Wrong When Several Discounts Exists for the Same Item (Doc ID 2004756.1)

Last updated on MARCH 05, 2019

Applies to:

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


The QTY_ORDERED extracted by edidlord batch is wrong when several discounts exists for the same item. EDIDLORD is multiplying the QTY_ORDERED by the number of discount lines for a specific PO/item.

Item 'X' have a qty_ordered of 15 units and 3 discounts lines for the same item 'X' on ordloc_discount table.
The qty extracted will be 45 units instead of 15 units.

The issue can be reproduced at will with the following steps:

1. Create a PO with items which have discount because they are linked to some deal.
2. Approve the PO.
3. Run edidlord batch.


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.