My Oracle Support Banner

Invalid Value For Buy Spend Type In RPM_PROMO_OFFER_COND Table (Doc ID 2644308.1)

Last updated on MARCH 04, 2020

Applies to:

Oracle Retail Pricing Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

Invalid value for Buy Spend Type in RPM_PROMO_OFFER_COND table

Steps to reproduce:

1. Go to Create promotions.
2. Under offer section - Select a Get Buy type and select "Buy X and Get Y for Discount" as template.
3. Under Rewards section - select discount as "Amount Off"and enter amount. Select dept as merch level and enter dept id.
4. Save the promotion. Check the data in RPM_PROMO_OFFER_COND table.
5. The value for this promo offer for BUY_SPEND_TYPE column is -1. But as per the documentation the buy spend type of the condition. Valid values are: 0 - Quantity, 1 - Amount.


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.