Coupons Apply Get Item Multiple Times When It Should Provide Only One Get Item (Doc ID 461779.1)

Last updated on JUNE 25, 2015

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders
FORM:QPXEVPHS.FMB - Event Phases
QPXEVPHS
OEXOEORD

Symptoms

Find when one enters an order and enter a coupon number at the header level for a get item, the coupon is applied multiple times.  When one enters one line on the order and the get item applies. So far so good.  But every time another new order line is entered another get item is added to the order.  Plus, the order line for the get item doesn't appear on the order. I have to re-query to see the new get item order line.


Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create promotional modifier for the get item upon coupon redemption.
Responsibility: oracle pricing manager
Navigate to: Modifier > modifier setup
currency: USD
active
automatic

list line no: 923577
level: line
modifier type: coupon issue
auto
phase: list line adjustment
prod attr: item number
prod attr value: 99888
prec: 220

list line no: 923563
level: group of lines
modifier type: promotion goods
prod attr: ALL_ITEMS
prod attr value: ALL
prec: 315
volume type: item quantity
break type: point
operator: between
uom: EA
value from: 0
value to: 9999999999

additional buy items:
<null>

get item:
item number = 999999
get quantity = 1
get price = -50
application method: Amount
value = 0

qualifiers :
grouping no = 2
modifier list, qualifier attribute = Restricted
value = Yes

grouping no = 3
modifier list, qualifier attribute = Restricted
value = Yes

grouping no =69659
modifier list, qualifier attribute = Coupon Number
value = 92357760082

grouping no =69760
modifier list, qualifier attribute = Coupon Number
value = 92357760628

grouping no =69762
modifier list, qualifier attribute = Coupon Number
value = 92357760642

grouping no =69763
modifier list, qualifier attribute = Coupon Number
value = 92357760649

grouping no =69765
modifier list, qualifier attribute = Coupon Number
value = 92357760663

grouping no =69766
modifier list, qualifier attribute = Coupon Number
value = 92357760670



2. Create sales order with multiple lines.
Responsibility: OM super user (or equivalent)
Navigate to: Orders, Returns > Sales orders

3. Save the order.
Get item is applied multiple times on the sales order.
--One must re-query to bring in all the additional get items.

Changes

 Stopped working correctly after the 11.5.10.2 upgrade.

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