Updating Few Items From Approved To Worksheet State Deletes Complete Promotion In XStore (Doc ID 3040315.1)

Last updated on AUGUST 08, 2024

Applies to:

Symptoms

On : 16.0.3 version, RPM Interfaces/Integration

ACTUAL BEHAVIOR
---------------
Updating few items from Approved to Worksheet state deletes complete promotion in XStore

When bringing items from Approved state back to Worksheet; RPM generates MULTIBUYPROMODEL type payload message.
This message is extracted as FPDEL record, which in-turn deletes complete promotion at XStore.

EXPECTED BEHAVIOR
-----------------------
For only the Worksheet promo details to get deleted in XStore and not complete promotion.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create simple promotion in RPM application with start date > vdate + 2 for around 3 item-diffs (MERCH_TYPE = 4) at any location or zone
2. Approve the promotion, notice MULTIBUYPROMOCRE message being populated in price event payload table.
3. Edit the Promotion, in Detail Maintenance tab select few promo details and change status to Worksheet. Click on Update > Done.
4. Notice MULTIBUYPROMODEL message in price event payload table.
5. Run promotionPriceChangePublishBatch.sh batch
6. Run promotionPriceChangePublishExport.sh batch to generate RPMPC dat file
7. Consume the file at Xstore.
8. Notice the 1 approved record in RPM is not present in Xstore DB.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.