Promotion Modification/Update Message Sends Wrong Start Date When Overlapped With Price Change. (Doc ID 1466670.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Retail Price Management - Version 13.1.3 and later
Information in this document applies to any platform.
Checked for relevance on 06-October-2016

Goal

When a price change is created in the middle of a simple promotion, the main tables of Retail Price Management (RPM) are updated correctly but the Promotion UPD message sent for promotion, is sent with start date of the original start date of the promotion instead of sending the Price Change effective date as the start date of the Mod message.

Steps to Recreate :
1. Create a promotion on item1/loc1 from vdate to vdate +5
2. Create a Price Change - Fixed Price on same item1/loc1 with effective date of vdate +3
3. Run RPMtooprospublish and Rpmtoorpospublushexport batch
4. Verify the promo mod message generated

Start date of the mod message is expected to be the Price Change start date but it has start date of the promotion instead. Why ? 

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