My Oracle Support Banner

Effective Precedence and Incompatibility Resolution in Pricing Results in Error Duplicate Price List (Doc ID 362711.1)

Last updated on JULY 24, 2024

Applies to:

Oracle Order Management - Version 11.5.9 and later
Oracle Advanced Pricing - Version 11.5.9 and later
Oracle Shipping Execution - Version 12.2.4 and later
Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
"Failed to resolve incompatibility between price list"
Order Management Sales Order Form will display the error note: Failed to resolve incompatibility between price lists (returns inventory item) Duplicate Price List Lines (i.e. equal precedence): Returns Price List A and Price List B
Intercompany Invoicing INCIAR
Intercompany Trip Stop May show error: status DUPLICATE_PRICE_LIST
Executable:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS



Symptoms

The pricing engine is failing to resolve incompatibility processing, even though the two competing price lists have different precedence on the attached qualifiers groups.
The significance of loss is not being able to deploy our pricing strategy. Precedence processing is working if we change the precedence of the item but we do not what to
change it for other business reasons, we want only to change the precedence on the qualifiers groups attached to the price list.

Item is Z, product precedence is changed to 900 Phase 0 User search flags are checked. Qualifier that is attached to the price lists default precedence of 260

Case 1
Price List A has a qualifier Q1 Customer = Y with a qualifier precedence of 260
Price List B has a qualifier Q1 Customer = Y with a qualifier precedence of 260

Sales order is enter without price list, and item is entered with qty of 1. Engine fails to resolve incompatibility as it should. Log file will show error messages like:
Failed to resolve incompatibility between price list or DUPLICATE_PRICE_LIST.

Case 2
Price List A has a qualifier Q1 Customer = Y with a qualifier precedence of 260
Price List B has a qualifier Q1 Customer = Y with a qualifier precedence of 259

Sales order is enter without price list, and item is entered with qty of 1. Engine returns price from price list B. This example provided to explain our business requirement.

 

Cause

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
Symptoms
Cause
 Price List Incompatibility Resolution
Solution
References

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