Promotions and Clearances in RPM Not Purging RPM_FUTURE_RETAIL Table
Last updated on FEBRUARY 02, 2018
Applies to:Oracle Retail Price Management - Version 22.214.171.124 to 126.96.36.199 [Release 12.0]
Information in this document applies to any platform.
In Retail Price Management (RPM) when users approve the Promotions and Clearances, the RPM_FUTURE_RETAIL tables are not getting purged.
Steps to Reproduce:
1. Login to RPM.
2. Set the promotion history days to 30 in RPM_SYSTEM_OPTIONS table.
3. Create a price change for an item I1 at location L1 on Vdate.
4. Create a promotion P1 for Vdate+1 and ending on Vdate+3.
5. Advance the Vdate by 45 days and create a promotion P2 for Vdate.
6. Approve the promotion.
Note: The records for promotion P1 are not purged.
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