My Oracle Support Banner

Details Deleted For Ongoing Deals (Doc ID 2996515.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR :
---------------

It is observed that when an Approved Deal is opened in Edit mode and clicks on 'save and close', all the deal details are deleted. Item-loc details are deleted from DEAL_ITEM_LOC_EXPLODE causing the salesprocess batch to fail.


EXPECTED BEHAVIOR :
-----------------------
Approved Deals opened in Edit mode which were saved and closed should not have the details deleted.



STEPS TO REPRODUCE :
-----------------------
1. Create a VFP deal in RMS.
2. Approve the deal and save and close.
3. Note the details are available in DEAL_ITEM_LOC_EXPLODE (Cost event with 'ADD' also).
4. Search for this deal on 'Manage Deals' screen and open in 'EDIT' mode.
5. Though there is no activity performed and just clicked on 'save and close', there is an entry recorded with cost event type as 'REM' and details are deleted in 'DEAL_ITEM_LOC_EXPLODE'.
6. When sales are processed into RMS with the promo related to this deal, the SALESPROCESS batch aborts as there are no details in DEAL_ITEM_LOC_EXPLODE.



BUSINESS IMPACT :
-----------------------
N/A

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
Cause
Solution
References


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