Promotions and Clearances in RPM Not Purging RPM_FUTURE_RETAIL Table (Doc ID 1439939.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Price Management - Version 12.0.11.3 to 12.0.11.5 [Release 12.0]
Information in this document applies to any platform.
Checked for relevance 23-Oct-2013

Symptoms

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.

Cause

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