My Oracle Support Banner

How to Apply Promotional Modifier Based on Unit Selling Price, Not on List Price? (Doc ID 2586887.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

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


Promotion is adding seeded volume order amount attribute to the custom attribute used

Using a custom volume attribute to determine discounting tiers on a promotional modifier. It is working in that it is returning the right value (looking at the pricing request viewer attributes).
The problem is that the pricing engine is adding my custom volume attribute to the seeded order amount volume attribute and using that number in the discounting tiers (Also visible in the pricing request viewer)


Expect Promotional Modifier Based on Unit Selling Price, Not on List Price.

The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User and Pricing
2. Navigate: Pricing > Create custom attribute

For example:
Need modifier which automatically add a promotional item for every $10 spend
on other cosmetic products. There is already a discount modifier which
discount the list price and the promotional modifier applying based on the
list price not on the discounted price (unit selling price)

eg item A
List price $9
Unit selling price $7 (After the discount modifier applied)
Qty 5
Order Total = $7 * 5 =35

Expected result : Count of Promotional item B = 35/10 = 3
Current Result : Count of promotional item B = 4 (which is (5*9)/10=45/10)


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.