My Oracle Support Banner

How to Purge the Expired Clearances after RFR Purge Job Deletes RFR Records? (Doc ID 2775919.1)

Last updated on MAY 18, 2021

Applies to:

Oracle Retail Price Management - Version 16.0.1 and later
Information in this document applies to any platform.


When you keep the items on clearance for a long time, say clearance start date = 01-Mar-2020 and reset date is 1 year away, i.e., 28-Feb-2021. CLEAR_HISTORY months = 3.

Some promos started/ended/started/ended between 01-Mar-2020 and now, so there are multiple timelines between 01-Mar-2020 and 28-Jul-2020.

Expired Clearance Purge will not purge the RPM_CLEARANCE and RPM_CLEARANCE_RESET as the reset date is not reached yet.

When it comes to the RPM_FUTURE_RETAIL purge job, it will purge the RFR record since the timeline for 01-Mar-2020 is history retention months. Since the RFR record is deleted, RPMFutureRetailPurge batch, even after clearance reset is executed and retention is passed, RPM_CLEARANCE RPM_CLEARANCE_RESET is not deleted as there is no record in RPM_FUTURE_RETAIL.

How to purge the expired Clearances in this case?


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.