Master Oracle's dynamic pricing engine: Price Lists, Modifiers, and Qualifiers.
Oracle Advanced Pricing (QP) is a rules-based engine that calculates the price of an item on a Sales Order. Instead of just picking a static price from a list, it can apply complex discounts, surcharges, freight charges, and promotions dynamically based on who the customer is, what they are buying, and when they are buying it.
You cannot price an item until it exists in the Inventory Item Master and is marked as "Customer Orders Enabled".
Ensure profile options like "QP: Item Validation Organization" and "QP: Source System Code" are set correctly.
Pricing Administrator
Pricing Administrator
Pricing Administrator
Pricing Administrator
Actor: Pricing Administrator | Module: Advanced Pricing (QP)
The Price List is the foundation. It contains the base price of your items. Every sales order must be associated with a price list to determine the starting price before discounts are applied.
Example: Create a "Corporate Price List" in USD. Add item "Laptop-X1" with a base price of $1,000.
Navigation Path:
Pricing Administration > Manage Price Lists
Key Actions:
Define the Header, then add items or item categories to the price list lines.
Actor: Pricing Administrator | Module: Advanced Pricing (QP)
Qualifiers are the "Who" or "When". They act as eligibility rules. A qualifier restricts a Price List or a Modifier so that it only applies to specific customers, customer classes, or order types.
Example: Add a Qualifier to a 10% Discount Modifier so it only applies if the Customer Class is "Gold Tier".
Navigation Path:
Pricing Administration > Manage Pricing Matrix / Strategy
Key Actions:
Fusion uses a matrix-based approach called "Pricing Strategies" to determine who gets what price list.
Actor: Pricing Administrator | Module: Advanced Pricing (QP)
Modifiers adjust the base price. They can be Discounts (reduce price), Surcharges (increase price), Freight Charges, or Promotional Goods (Buy 1 Get 1 Free).
Example: Create a Modifier of type "Discount". Line level: If Item = "Laptop-X1", apply a 10% discount.
Navigation Path:
Pricing Administration > Manage Discount Lists
Key Actions:
Fusion separates these into Discount Lists, Surcharge Lists, and Freight/Cost Lists.
Actor: Pricing Administrator | Module: Advanced Pricing (QP)
If you cannot determine a price using a static list, you can use a Pricing Formula to calculate it dynamically based on variables, costs, or other lists.
Example: Create a formula: `Item Cost + (Item Cost * 0.20)`. This sets the price to a guaranteed 20% markup over cost.
Navigation Path:
Pricing Administration > Manage Pricing Formulas
Key Actions:
Build the formula using standard mathematical operators and map it to price list lines.
Understand how Order Management calls the Advanced Pricing engine.
Read Guide