Multi-Buy Promotion Creates Duplicate Records in RPM_PROMO_ITEM_PAYLOAD Table (Doc ID 1557705.1)

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.

Symptoms

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.

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