My Oracle Support Banner

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

Last updated on MARCH 03, 2019

Applies to:

Oracle Retail Price Management - Version 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.