My Oracle Support Banner

UNLIMITED_IND Is Not Populating As Expected (Doc ID 3070685.1)

Last updated on FEBRUARY 05, 2025

Applies to:

Oracle Retail Pricing Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

On : 19.3 version, Pricing - Promotions

When RPM_PROMO_OFFER_REWARD.QTY_TO_DISC is null, you observe RPM_PROMO_OFFER_REWARD.UNLIMITED_IND is also null.
This should get populated as 1 when qty_to_disc is null and as 0 when qty_to_disc is not null.


The issue can be reproduced at will with the following steps:
  1. create buy/get promotion
  2. Buy item as Quantity of 2 of an item x,
  3. Get item y with apply discount as null
  4. Reward List as Fixed Price .
  5. Attach a location and approve the promotion



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.