Promotions and Clearances in RPM Not Purging RPM_FUTURE_RETAIL Table

(Doc ID 1439939.1)

Last updated on FEBRUARY 02, 2018

Applies to:

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