My Oracle Support Banner

RPM Purge Job Is Not Purging Tables (Doc ID 2901824.1)

Last updated on MARCH 12, 2024

Applies to:

Oracle Retail Pricing Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

On : 19.3.002 version, batches, Non production

ACTUAL BEHAVIOR
---------------
RPM Purge Job is not purging any data. The batch completed successfully , but data is not deleted from tables.
Retention period is set to 1 month for Price changes and Clearances, but no data is deleted.

EXPECTED BEHAVIOR
-----------------------
Old price events should be deleted.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Created 333k clearance and 122k price change events in RPM using Induction
2. Changed the Vdate in Period table manually.
3. Run the RPM Purge Job .

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Old data is pilled up and can generate performance degradation.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.