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

Last updated on MAY 31, 2016

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

Goal

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 ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms