Processing of Deal Fails with Multiple Entries on DEAL_ITEM_LOC_EXPLODE table with Same Item/Location and Active Date but with No Updates on FUTURE_COST Table (Doc ID 2128689.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

If you approve a Complex Deal, then set it back to worksheet status, without leaving Deal Maintenance Window [dealmain], make date change and approve it again, then the processing of deal fails.

Steps to Recreate
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a deal and Approve save the deal.
2. Check the DEAL_ITEM_LOC_EXPLODE and FUTURE_COST tables to see if the deal has been successfully saved in the database.
3. Without closing the screen, set the deal back to worksheet and change the active date to a latter date
4. Approve the deal and click Save.
5. Check the DEAL_ITEM_LOC_EXPLODE and FUTURE_COST tables to see if the deal has been successfully saved in the database.
6. The deal(active date) has not been successfully updated in the database.
7. Click Save again and no error pops up this time.
8. Check the DEAL_ITEM_LOC_EXPLODE and FUTURE_COST tables to see if the deal has been successfully saved in the database.
9. Multiple entries in DEAL_ITEM_LOC_EXPLODE now appears for the active dates and no updates are created in future cost table.

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