My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

Applies to:

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


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.


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

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