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

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

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.

Example:-
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.

Changes

 

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