My Oracle Support Banner

Impacts Of Item Re-classification On Merch Hierarchy Level Promotions (Doc ID 1900568.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Retail Price Management - Version 13.2.5 and later
Information in this document applies to any platform.
Checked for relevance on 31-May-2016


When a Promotion is Active or in Approved status is created at a Merch hierarchy and zone level and then item(s) or all items from that merch hierarchy is moved to another Merchandise hierarchy through reclassification prior to beginning of the promotion or during the Promotion , then the expected behavior from RPM is that the promotion should be removed for those skus. But it is noticed that in Retail Price Management (RPM) after running ItemReclassification batch in RPM only table RPM_PROMO_ITEM_LOC_EXPL and RPM_FUTURE_RETAIL were updated with the item(s) new Merch Hierarchy, however the table RPM_PROMO_DTL_MERCH_NODE still contained the older hierarchy and RPM UI displayed the old Hierarchy (with which the promo was created) for the Promotion.

What is the Expected behavior here for Merch Level promo after a reclass is done for all items in the Merch hier or some items in the Merch hier ?


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.