DEALINC Performance Issue for Bill Back Rebate (BBR) Based Deals (Doc ID 1509274.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

In Oracle Retail Merchandising System (RMS), there is a DEALINC performance issue for bill back rebate (BBR) based deals.

Steps to Reproduce:

  1. Create a BBR deal at the company level such that thousands of item/locs are created by DEALEX.
  2. Process turnover for the deal. 
  3. Run DEALACT batches and observe records are created as needed on DEAL_ACTUALS_ITEM_LOC.
  4. Run DEALINC.  Observe performance is fine as only records with turnover are processed.
  5. During the second reporting period, process no transactions.  At the end of the second week, run DEALINC PRE.  Note that all item/loc combinations have been inserted into DEAL_ACTUALS_ITEM_LOC table.
  6. Run DEALINC.  Observe that the performance is poor because all DEAL_ACTUALS_ITEM_LOC records for the reporting period are being processed one-by-one, even though there is no turnover.

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