How One Could Use the Sales Order Header Flexfield to Determine Applicable Price Lists for the Sales Order? (Doc ID 1382400.1)

Last updated on DECEMBER 02, 2022

Applies to:

Goal

 How can one achieve a setup to meet the following business needs for how price lists are used in sales orders based on the customer "status" when one cannot use custom class assignments?

Business Case
Four price lists:
   Price List A  in currency = EUR
   Price List B in currency = USD
   Price List C in currency = EUR
   Price List D in currency = EUR
.
For standard customers pricing should look up a price of an item in the following sequence:

1. Price List A
2. Price List B
3. Price List C

.
For major customers the search sequence should be:

1. Price List D
2. Price List C
3. Price List A

Solution

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