How Does the Pricing Engine Check Range Overlap for Pricing Attributes? (Doc ID 2122630.1)

Last updated on MAY 19, 2016

Applies to:

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

Goal

Created two price list lines as follows:

Price List Line 1:  Quantity is between 10 to 20 (Defined in pricing attributes)* Price=11$ * Precedence: 1
Price List Line 2:  Quantity is between 15 to 20 (Defined in pricing attributes)* Price= 9$ * Precedence 1


As the quantity ranges overlap, is this an absence of validation per design or a malfunction that we are observing?

 

With above, for a sales order line with qty = 16, pricing engine yields error "Failed to resolve incompatibility between price lists <price list> Duplicate price list lines." This of course can be resolved by changing the precedence on price list line 1 to 5 (any number greater than 1).
 

Solution

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