Multi-Buy Promotion Creates Duplicate Records in RPM_PROMO_ITEM_PAYLOAD Table
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Retail Price Management - Version 13.2.5 to 13.2.6 [Release 13.2]
Information in this document applies to any platform.
In Oracle Retail Price Management (RPM) 13.2.x, when a promotion is created using the Multi-Buy Discount functionality, duplicate records exist in the RPM_PROMO_ITEM_PAYLOAD table.
Steps to Reproduce:
1. Log in to Retail Price Management (RPM).
2. Navigate to Promotions -> Create Promotion and create a multi-buy promotion with the below details:
BuyList1 : Qty = 1; Item1, BuyList2: Qty = 1; Item2
Apply Reward to = Each
Buy List Reward = Percent Off - 10%
3. Approve the promotion.
4. Check the table RPM_PROMO_ITEM_PAYLOAD.
Notice that duplicate records exist.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms