My Oracle Support Banner

Deal Income Calculated Incorrectly for Billback Deal with Threshold Limit Type of 'Quantity' and Multiple Deal Components with Threshold Value as 'Amount' and 'Percentage' (Doc ID 1947410.1)

Last updated on MAY 01, 2021

Applies to:

Oracle Retail Merchandising System - Version to 13.1 [Release 13.0 to 13.1]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.0.x, the dealinclib income calculation logic appears to be faulty in the following scenario:

In this scenario, notice that the income for the Amount component is grossly misstated.

Steps to Reproduce:

  1. Set up a straight billback deal with Threshold Limit Type of Q.
  2. Create two components, one with Threshold Value Type of A, the other as P.  For the A threshold, set the minimum units to 1 (so that the first is excluded) and then set the threshold to $10/unit.
  3. Prior to running dealinc, confirm both components have turnover of 2 units.
  4. Based on the component and threshold setup, and turnover of 2 units, the A component should generate $10 income. Instead note that it generates $1,630 income.


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.