Records Getting Deleted From RPM_PROMO_ITEM_LOC_EXPL Even For Active Promos (Doc ID 2183638.1)

Last updated on APRIL 07, 2017

Applies to:

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

Symptoms

Records getting deleted from RPM_PROMO_ITEM_LOC_EXPL for active promos during conflict checking process .

Steps to Reproduce :

  1. Set PROMOTION_HIST_MONTHS in RPM_SYSTEM_OPTIONS to 1.
  2. Create a item in RMS and range it to a store.
  3. Run RPM NIL batch.
  4. Create 3 simple promos for item created in step 1 and store to which it was ranged with start date and end date similar to the below dates.
      a. For the first promo, set promo start date = '03-MAY-2016' and promo end date = '12-MAY-2017'.
      b. For the second promo,set promo start date = '05-MAY-2016' and promo end date = '12-MAY=2017'.
      c. For the third promo, set promo start dat = '07-MAY-2016' and promo end data = '12-MAY-2017'.
  5. Make all the 3 promos active . Run Priceeventexecution and PriceeventexecutionRMS batch .
  6. Advance vdate to a future date such its greater then the start date of the all the 3 promo's( Ex: 02-JUL-2016).
  7. Create another promo for the same item and store with promo start date as '02-JUL-2016' and promo end date as '12-MAY-2017' and approve it.

    Note that, there is only one record in RPM_PROMO_ITEM_LOC_EXPL and for all the other active promos the entries are deleted.
    Similar issue happens while canceling the promos, where the entries are deleted from rpm_promo_item_loc_expl table.
    Only the entry with the latest promotion is retained in RPM_PROMO_ITEM_LOC_EXPL and for the cancelled promo, there won't be any entry in RPM_PROMO_ITEM_LOC_EXPL.

Cause

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