STATUS Does not get Updated in PRICE_CHANGE_WORKSHEET Table.
(Doc ID 2424745.1)
Last updated on FEBRUARY 26, 2019
Applies to:
Oracle Retail Store Inventory Management - Version 14.1 and laterInformation 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:
- Create a future dated promotion and approve it.
- Run RPM batches PromotionPriceChangePublishBatch and promPriceChangePublishExport.sh, and import interface file (PRMPC_*.pub).
- Run SIM batch PromotionPriceChange.sh to import the promotion information into SIM.
- Promo action_type status will 1(create) in price_change_worksheet table. And the item_price table gets updated with the price
- Purge the RPM Payload tables (or run the purgePayloadsBatch.sh batch).
- 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) .
- Run RPM batches PromotionPriceChangePublishBatch and promPriceChangePublishExport.sh, and import interface file (PRMPC_*.pub).
- Notice the file will have FPDEL records in file. Please check the format of this record as mentioned in 14.1 SIM Operations guide.
- Run SIM batch PromotionPriceChange.sh to import the promotion delete information into SIM.
- 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.
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |