Modifier Using GET_CUSTOM_PRICE Is Not Being Evaluated Correctly in Best Price Evaluation
Last updated on JULY 26, 2017
Applies to:Oracle Advanced Pricing - Version 12 and later
Oracle Order Management - Version 12 and later
Information in this document applies to any platform.
New modifier using get_custom_price that is set as automatic.
The formula is working correctly an returning the correct price, but it is
not used in the best price processing.
So although it is the best price, a different modifier is used.
The pricing engine request viewer shows the "Best Percent" as 0 which
does not seem correct.
The formula takes the item and the customer and returns the lowest price that
we actually sold the product at to that customer. the actual formula is
NVL(1,2) with 2 being the code in get_custom_price.
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