My Oracle Support Banner

E1: 45: Preference Hierarchy Functionality for Advanced Pricing (P40073, P4074, P4071, P4072) (Doc ID 1346821.1)

Last updated on MAY 03, 2020

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version XE and later
Information in this document applies to any platform.


The Preference Hierarchy (P40073) is part of the mandatory set up in order for Advanced Pricing to work. Customers must determine their hierarchy and understand that the Preference Hierarchy program (P40073) is used by the system to search and apply the Price to an order either within the Price History (P4074) or directly to the detail line (Order level adjustments).

The Preference Hierarchy is designed to work from most specific to most general when doing a search for a price adjustment.

In this example, a simple, 4-level hierarchy might indicate “First search the details that match both the customer and item number specifically. If no adjustment is found, then search the details that use Customer Group and Item number” If any adjustments exist for the Customer Group/Item then the system will stop and apply the adjustment that has been found and no further search will occur.

Note: The user can enter up to 21 hierarchies, however Oracle recommends limiting the use to 3 to 4 hierarchies for better performance per adjustment. The more hierarchies found within the Preference Hierarchy program, the longer the system will take to find and return the adjustments to the order.


Advanced pricing uses the Preference Hierarchy to locate which adjustments need to be applied. Note this same program works for Base price and Advanced Preferences and functions exactly the same. This feature is available in all EnterpriseOne releases for both Sales and Procurement.


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
 Price Adjustment Definition (P4071)
 Price Adjustment Detail Revisions (P4072)
 Advanced Pricing Process Flow
 Frequently Asked Questions

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