For Deals Created With Active Date Before the Create Date of Items, Future Cost Does Not Reflect Deal Condition

(Doc ID 2152864.1)

Last updated on NOVEMBER 10, 2016

Applies to:

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


For deals created with active date before the create date of items included in the deal, FUTURE_COST table is not updated accordingly with the value of deals.

Steps to Recreate:

  1. Create supplier S1
  2. Create Item I1
  3. Range item for location L1
  4. Create a deal with active date prior with item /supplier creation date
  5. Activate the deal.  Notice that FUTURE_COST table does not reflect deal condition
  6. Range Item for new location L2. Notice that FUTURE_COST does reflect deal condition
  7. Close previously created deal and create new deal with active date as system date
  8. Notice that FUTURE_COST does reflect correctly deal cost


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