Wrong Modifier Applied To Sales Order Line During Incompatibility Processing Using Best Price Evaluation (Doc ID 1475506.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The best price supplier ship and debit contract does not apply to a sales order line. This is found to happen when the selling price/list price of the item is 0.

STEPS TO REPRODUCE
--------------------------------------------
The best price supplier ship and debit contract does not apply to a sales order line. This is found to happen when the selling price/list price of the item is 0.
Example: For Item X, there are three contracts with the same qualifying conditions. The contracts are as below:

Contract # 001 with request header id # 7 for ITem X for UOM 'BX' with approved value as 16.39,
Contract # 002 with request header id # 120 for ITem X for UOM 'BX' with approved value as 10.02,
Contract # 002 with request header id # 905 for ITem X for UOM 'BX' with approved value as 17.059

All of the above supplier ship and debit contracts have the same incompatibility group, same precedence, same bucket and the same phase.The pricing phase has the incompatibility resolve code set to 'Best Price' Ideally, contract # 002 should have been applied to the sales order as it satisfies the 'Best Price' logic applies. However Contract # 001 with request header id # 7 is the one that gets applied.

1. Create a sales order
2. Create the sales order line for Item X
3. Populate sales order line attributeXX as it satisfies the qualifier defined for all 3 contracts
4. Save the record
5. From the line > Actions > View Adjustments -> we can see that the contract with the lowest request header id is applied

Changes

Another method to explain this scenario:
Create 3 modifiers applicable for an Item in the same phase  having the Incompatibiltiy code set as Best price for that phase    
         Modifier1 with new price as 16                                      
         Modifier2 with new price as 10                                      
         Modifier3 with new price as 23                                      
        
       The price list for that item should be zero.                        
        
 Before this fix , when the Sales Order is created for this item,  Modifier1 gets applied.

Cause

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