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.
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: TEST LIMITS
Pricing Phase: List Line Adjustments
Item Number: PPK_FG1
Application Method: Percent
2.Click on List limits & provide the limits
Basis: Cumulative Discount Amount
Enforced: Current Transaction
Constraint 1: Qualifier Attribute
Context 1: Order
Attribute 1: Sales Order Number
When Exceeded: Hard - Adjust Benefit Amount
3.Navigate to sales order form & enter order for the item under promotion
Shows sales order: 8037095
Line 1.1 for item PPK_FG1
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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms