Best Price Functionality In Conjunction With Pricing Formulas Used Within Modifiers Is Not Working Correctly on R12 (Doc ID 1922562.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
Best price functionality in conjunction with pricing formulas

The company uses 2 price lists, one as a default price list and an other for special offers.


Some customer get's a discount of 50% (for example) on the default price list. Because of this some particular special offers are more expensive than the dafault prices of this customer.

Against this background im looking for a solution, that the customers always get's the best price, irrespective of the price list, they are based on.


My idea for the issue:

1. Created a new pricing context "Special offer price". A function tranfers the special offer prices from the price list to this context (the value depends on the inventory_item_id of the order line).

2. Activated this context in a pricing formula and for some customers I adjust them with a special discount. (for example 10% discount on top every special price)

3. Integrate the prcing formula in a discount modifier with the parameters: Discount, List Line Adjustment, set Override and automatic flag.
    then selected the dynamic pricing formula and "New Price" as calculation method and left "Value" null (beause the value will come from the pricing formula).

In doing, one receives the right price in the order, the function and the formula are working fine, but the choice of the best price does not work
It appears that the pricing engine compares the empty value field for the choice of the best price.


PS: Price buckets for both modifiers: 1 , incompatibility groups for both: 1, Precedence of both modifier lines 290


EXPECTED BEHAVIOR
Expect Best Price to be evaluated with formula

STEPS
The issue can be reproduced at will with the following steps:
1. Order Management Super User
2. Create Order
The pricing does not consider the modifier with the formula even though this one would provide a lower price for the customer.

NOTES
If one enters  something in the column “value” of the modifier line, this entry gets used as the reference of the best price functionality.
But there is no relationship between the values in this column and the real price in the order, which is based in the pricing formula.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.