Zone Level Promotion Is Populating Incorrect Data in RPM_PROMO_LOCATION_PAYLOAD
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.
Incorrect data gets populated in RPM_PROMO_LOCATION_PAYLOAD table when a promotion is created at zone level.
Steps to Recreate:
- 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.
- Now create one simple promotion for item 206577 with zone level.
- 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.
- 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.
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