Old Records Not Getting Purged From RPM_FUTURE_RETAIL Table
(Doc ID 1599139.1)
Last updated on AUGUST 13, 2018
Applies to:Oracle Retail Price Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
checked for relevance on 20-November-2013
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!