Deal Income Calculated on Forecasted Values Rather Than on Actuals (Doc ID 2052391.1)

Last updated on SEPTEMBER 11, 2015

Applies to:

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

Symptoms

In Oracle Retail Merchandising System (RMS) 13.2.x, deal income appears to be calculated on forecasted values rather than on actuals.


Steps to Reproduce:

  1. Create a Bill Back Rebate Deal for a particular item supplier and all locations. Set threshold from 1 to 99999999 with a discount of 14% (percent off).
  2. In Deal Income screen provide the baseline turnover value and budget turnover values.
  3. Run FCTHREADEXEC and FCEXEC batches.
  4. Move VDATE.
  5. Create a purchase order, then ship and receive it so that the receipt date falls on the active date of the deal.
  6. Move VDATE to end of week for first reporting period.
  7. Run DEALINC PRE and DEALINC.
  8. Run DEALFCT PRE and DEALFCT batch and make sure the data is updated in DEAL_ACTUALS_FORECAST table.
  9. Do not do any receiving in second reporting period.
  10. Create a PO.  Ship and receive in third reporting period.
  11. Execute the DEALINC PRE and DEALINC batches.
  12. In DEAL_ACTUALS_ITEM_LOC notice that actual income is incorrectly calculated, as the income value is considering the forecasted value instead of actual receivings.

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