RPM Is Not Updating the Start Date of a Simple Promotion If a Permanent Price Change Happens During the Promotional Period (Doc ID 1203336.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

Oracle Retail Price Management - Version 13.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 21-Oct-2013

Goal

Why does Retail Price Management (RPM) not update the start date of a promotion when a permanent price change goes into effect during the promotional period?

Example:

1. Setup steps:

Sign on to RPM

Navigate: Promotions => Create Promotion
   Promotion ID: 1041
     start date: 3/7/2009
     end date: 3/29/2009
   Component: 941
     type: Simple
     item: 100080036
     location: 5002
     25% off
Apply to: Regular and Clearance
Approve Promotion

Navigate: Price Change => Create Price Change
  Effective Date: 3/15/2009
    fixed price: 45.99
    item: 100080036
    location: 5002
  Price Change: 841 created
 Approve Price Change




2. Check table data:

select action_date, selling_retail, simple_promo_retail, on_simple_promo_ind, price_change_id, pc_change_amount
from rpm_future_retail
where item = '100080036'
and location = '5002'
 


action_date   selling_retail   simple_promo_retail   on_simple_promo_ind   price_change_id   pc_change_amount
2/9/2009      53.00            53.00                 0
3/7/2009      53.00            39.75                 1
3/15/2009     45.99            34.49                 1                     841               45.99
3/30/2009     45.99            45.99                 0



select promo_dtl_payload_id, price_event_payload_id, promo_id, promo_comp_id, promo_dtl_id, start_date, end_date
from RPM_PROMO_DTL_PAYLOAD
where promo_id = '1041'

promo_dtl_payload_id   price_event_payload_id   promo_id   promo_comp_id   promo_dtl_id   start_date   end_date
1341                   1141                     1041       941             1482           3/7/2009     3/29/2009
1342                   1144                     1041       941             1482           3/7/2009     3/29/2009



select *
from rpm_price_event_payload
where price_event_payload_id in ('1141','1144')


price_event_payload_id   transaction_id   rib_family   rib_type           publish_status
1141                     1181             PrmPrcChg    MULTIBUYPROMOCRE   0
1144                     1182             PrmPrcChg    MULTIBUYPROMOMOD   0




3. Run promotionPriceChangePublishBatch and promotionPriceChangePublishExport



4. Review PRMPC_<datestamp>.pub:

TMBPE|2739|CRE
TPDTL|2740|1041|941|RSB SVU Test||RSB SVU test|1|1482|20090307|20090329|1|
TLLST|2741|5002|S
TPGRP|2742|1482
TGLIST|2743|1482||
TLITM|2744|100080036
TPDSC|2745|0|||-25||2|1
TPILSR|2746|100080036|39.75|EA|5002
TMBPE|2747|MOD
TPDTL|2748|1041|941|RSB SVU Test||RSB SVU test|1|1482|20090307|20090329|1|
TLLST|2749|5002|S
TPGRP|2750|1482
TGLIST|2751|1482||
TLITM|2752|100080036
TPDSC|2753|0|||-25||2|1
TPILSR|2754|100080036|34.49|EA|5002
TTAIL|2755




Observe MOD message shows start date as 20090307 (3/7/2009), which is the start date of the promotion.

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