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

Last updated on OCTOBER 26, 2016

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.

Symptoms

On : 12.1.3 version, Pricing Engine

ACTUAL BEHAVIOR
---------------
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

EXPECTED BEHAVIOR
-----------------------
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.

STEPS
-----------------------
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: TEST LIMITS
  Level: Line
  Pricing Phase: List Line Adjustments
  Item Number: PPK_FG1
  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: 8037095
  Line 1.1 for item PPK_FG1
  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.


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