SIM Bulk Price Processing Program Does Not Update Promotion Status When the Promotion Is Deleted in RPM (Doc ID 1623208.1)

Last updated on OCTOBER 27, 2016

Applies to:

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

Symptoms

In Store Inventory Management (SIM) 13.2.x, we find that when a future dated and approved promotion is deleted or put back to 'worksheet' status in the Retail Price Management (RPM) application, the deleted promotion does not get processed correctly in SIM Bulk Price Processing program.


Steps to Reproduce:

  1. Create a simple promotion in RPM for 1 item with future start and end dates.  Approve the promotion.
  2. Run RPM batches PromotionPriceChangePublishBatch and promPriceChangePublishExport.sh, and import interface file (PRMPC_*.pub).
  3. Run SIM batch PromotionPriceChange.sh to import the promotion information into SIM.
  4. Query RK_PRICE_CHANGE table.  The promotion should be created in the table with status = 1 (Pending), since it is future dated.
  5. Purge the RPM Payload tables (or run the purgePayloadsBatch.sh batch).
  6. Edit the simple promotion in RPM for the promo created in step 1 and put it back to 'worksheet' status.  Note that this will populate the payload tables with a delete message (MULTIBUYPROMODEL).
  7. Run RPM batches PromotionPriceChangePublishBatch and promPriceChangePublishExport.sh, and import interface file (PRMPC_*.pub).
  8. Notice the file will have FPDEL records and that it has 8 columns in it.
  9. Run SIM batch PromotionPriceChange.sh to import the promotion delete information into SIM.
  10. Query RK_PRICE_CHANGE table. The promotion did not update at all.  The status is still "1" - Pending, instead of "9" or Deleted.

 

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