Zone Level Promotion Is Populating Incorrect Data in RPM_PROMO_LOCATION_PAYLOAD  (Doc ID 2132896.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Retail Price Management - Version 13.2 and later
Information in this document applies to any platform.

Symptoms

Incorrect data gets populated in RPM_PROMO_LOCATION_PAYLOAD table when a promotion is created at zone level.


Steps to Recreate:

  1. Setup:  There is one Zone ID: 1, which has 98 stores overall.  There is one item: 206577, which is ranged to only 18 of the 98 stores.
  2. Now create one simple promotion for item 206577 with zone level.
  3. This item got extracted only for those 18 stores in RPM_PROMO_LOCATION_PAYLOAD for successfully ranged stores.  This is correct, and the same is updated in RPM_FUTURE_RETAIL.
  4. However, when checking in RPM_PROMO_LOCATION_PAYLOAD table, note that data was extracted for this promotion for all 98 locations in the zone level, even those not ranged.

 

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