My Oracle Support Banner

Promotional Limits For Hard Adjust Amount Are Not Getting Applied (Doc ID 1664890.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Pricing Engine

Create a promotion for 10% discount for an item with max $50 discount allowed per order for that promotion.
Find that promotional limits are not getting applied correctly for an order line as a $100 discount is being applied.
Also on the discount Under Balances it shows and incorrect consumed and available balance; Consumed: -110 and Available: 160

Expects that the promotional limits will be applied correctly.
Expect the limit to fire and a hold be placed on the order.
Also that on the discount Under Balances it should show correct consumed and available balances.

The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
  Navigate to: Modifier > Modifier Setup
  Create a modifier with discount list with 10% discount
  Type: Discount Lists
  Name/Number: TESTxxxx
  Level: Line
  Pricing Phase: List Line Adjustments
  Item Number: Pxxxx
  Application Method: Percent
  Value: 10

2.Click on List limits & provide the limits
  Basis: Cumulative Discount Amount
  Enforced: Current Transaction
  Amount: 50
  Unit: USD
  Constraint 1: Qualifier Attribute
  Context 1: Order
  Attribute 1: Sales Order Number
  When Exceeded: Hard - Adjust Benefit Amount
  Hold? No

3.Navigate to sales order form & enter order for the item under promotion
  Shows sales order: nnnnnn
  Line 1.1 for item Pxxxx
  Qty: 100
  List Price: 10
  Unit Selling Price: 9
  Extended Price: 900
  * Notice that the modifier is applied on the order line.

4. Navigate to the modifier form & query for the modifier created in step1. Click on List limits.
  Under Balances it shows:
  Consumed: -110
  Available: 160

List price of the item = $10
10% discount = $1 per qty
Qty on order = 100
Total discount for this order = $100
The limits were not applied on the order as expected. Also, the consumed balance is captured incorrectly.


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.