My Oracle Support Banner

STATUS Does not get Updated in PRICE_CHANGE_WORKSHEET Table. (Doc ID 2424745.1)

Last updated on JULY 25, 2018

Applies to:

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

Symptoms

 In Store Inventory Management (SIM) application, find that when an approved price change (Promotion ) is put back into "Worksheet" status in Retail Price Management (RPM) application, the price change  status does not change in SIM

Steps To Recreate:
  1. Create a future dated promotion and approve it. 
  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. Promo action_type status will 1(create) in price_change_worksheet table. And the item_price table gets updated with the price
  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 in file. Please check the format of this record as mentioned in 14.1 SIM Operations guide.
  9. Run SIM batch PromotionPriceChange.sh to import the promotion delete information into SIM.
  10. Query price_change_worksheet table in SIM, notice that promotion action_type status is still 1 and not changed to 3(Delete).  And item_price table’s status also remains approved.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.