Old Records Not Getting Purged From RPM_FUTURE_RETAIL Table
Last updated on MARCH 08, 2017
Applies to:Oracle Retail Price Management - Version 220.127.116.11 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.
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