Old Records Not Getting Purged From RPM_FUTURE_RETAIL Table (Doc ID 1599139.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Retail Price Management - Version 13.1.3.4 and later
Information in this document applies to any platform.
checked for relevance on 20-November-2013

Symptoms

RPM_PROMO_ITEM_LOC_EXPL and RPM_FUTURE_RETAIL tables are not getting purged for old records.

Steps to Recreate :
1. Ensure that an item/location has many old price events in RPM_FUTURE_RETAIL table(older than 10 months from vdate).
2. Now, create a simple promotion for this item/location combination on vdate+1.
3. Approve the promotions so that it does the conflict checking.
4. Observe that both tables RPM_FUTURE_RETAIL and RPM_PROMO_ITEM_LOC_EXPL contains the old records even if the PROMOTION_HIST_MONTHS and CLEARANCE_HIST_MONTHS have been set to 10 months.

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