My Oracle Support Banner

Records are not Purged from RPM_PROMO_ITEM_LOC_EXPL even though the Items are Purged From RMS (Doc ID 2410806.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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


In RPM 14.0.2, Records are not deleted from RPM_PROMO_ITEM_LOC_EXPL when the items are purged from RMS when the style items are not ranged.

Steps to reproduce:

1) Create a level 2 item in RMS. Range only the SKU's and do not range the style item.
2) Run RPM NewItemLocBatch.
3) Create a promo for the parent item.
4) Once the promo ends delete the items from RMS.
5) Run ItemLocDeleteBatch.
6) Note that the records are deleted from RPM_FUTURE_RETAIL but are still present in RPM_PROMO_ITEM_LOC_EXPL.


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.