My Oracle Support Banner

Sales Order Is Picking Up The Wrong Price List (Doc ID 2244160.1)

Last updated on MAY 16, 2023

Applies to:

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


After upgrade from 12.1.3 to 12.2.5, the following scenario was noticed:

The primary price list XXXX has no price list lines; primary price list has several secondary price lists.  The item on the sales order in question exists on 2 of the secondary price lists YYYY and ZZZZ.

The secondary price list YYYY has precedence (150) with no qualifiers attached to it.

Another secondary price list ZZZZ has precedence (160) and has qualifier on line type (AAAA).


When a sales order is created with primary price list on header, on sales order line has no default line type, the secondary price list YYYY is getting populated as expected.

But, when the line type on the sales order is changed to  'AAAA' , the price is pulled from secondary price list ZZZZ which has a precedence 160.

Price to be pulled from Secondary Price List example YYYY ( which has higher precedence 150) and no qualifiers attached to it. And this expected behavior is seen in R12.1.3.

The issue can be reproduced at will with the following steps:
1. Enter sales order with Header Price List as XXXX
2. Enter sales order line with line type as blank, one of the secondary price list YYYY with precedence 150 contains the item defaulted
3. Change the line type ''AAAA'' , the price is pulled from another secondary price list ZZZZ which has lower precedence 160 and has qualifier as Line type 'AAAA'


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.