My Oracle Support Banner

Modifier Using GET_CUSTOM_PRICE Is Not Being Evaluated Correctly in Best Price Evaluation (Doc ID 1533482.1)

Last updated on FEBRUARY 24, 2019

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.




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.