My Oracle Support Banner

Daily Purge Does Not Delete Data from RPM_ZONE and RPM_ITEM_ZONE_PRICE Tables (Doc ID 2848252.1)

Last updated on FEBRUARY 15, 2023

Applies to:

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


You observe data was removed from RPM_ZONE but remains in RPM_ZONE_FUTURE_RETAIL and RPM_ITEM_ZONE_PRICE after deleting a zone in Pricing.

Steps to Reproduce
1. Pick a zone which does not have stores under it (RPM_ZONE_LOCATION empty for the zone), no price change and clearances (RPM_PRICE_CHANGE and RPM_CLEARANCE tables empty for this zone id). But the zone should have records in RPM_ZONE_FUTURE_RETAIL and RPM_ITEM_ZONE_PRICE.

2. Delete this zone from UI and check if the records get deleted from RPM_ZONE, RPM_ZONE_FUTURE_RETAIL and RPM_ITEM_ZONE_PRICE.




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.