RPM_FUTURE_RETAIL - Auto Purge not happening
Hi,
we are using RPM 12.0.12 version.
As per the below link, RPM_FUTURE_RETAIL table should get purged automatically when ever conflict check happens.
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=383569799219114
FUTURE_RETAIL_ID | ITEM | LOCATION | ACTION_DATE | SELLING_RETAIL | CLEAR_RETAIL |
633385106 | 101xx680 | 102 | 7/31/2009 | 4.99 | 4.99 |
1824364896 | 101xx680 | 102 | 9/27/2014 | 4.99 | 3.29 |
1842767216 | 101xx680 | 102 | 11/15/2014 | 4.99 | 1.49 |
During this Price change /clearance creation on 11/15/2014, with action date 7/31/2009 records should be automatically purged right? but it was not purged in RFR.
Is it anything related with RPM_SYSTEM_OPTIONS table? or it will purge based on any timelines?