# Oracle EBS Advanced Pricing: Price Lists, Modifiers, Qualifiers and Formulas > Source: https://netray.co/erp-help/oracle-ebs-advanced-pricing-setup-modifiers-price-lists-qualifiers > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Oracle Advanced Pricing sets a base price from a price list (optionally calculated by a formula) and then applies modifiers such as discounts, surcharges and promotional goods in a defined order of phases. Qualifiers decide who and what a list or modifier applies to. When a price or discount does not apply, check the qualifier, the pricing phase, the effective dates, the incompatibility group and the attribute mapping. ## Kind how-to ## System oracle-ebs ## Erp Oracle E-Business Suite R12 (Advanced Pricing) ## Module Advanced Pricing / Order Management ## Query oracle ebs advanced pricing ## Alternate Queries - oracle advanced pricing modifiers setup - oracle ebs price list qualifiers - oracle advanced pricing formulas - oracle ebs pricing engine not applying modifier ## Applies To Oracle E-Business Suite R12.1 and R12.2 with Advanced Pricing licensed and Order Management or Quoting calling the pricing engine. ## Steps ### Basic setup sequence **Items:** - Confirm the Advanced Pricing responsibility and profile options (such as the source system code and pricing transaction entity) are set for your products. - Set up pricing attributes and contexts, and run the attribute mapping process so that order and item attributes can be used in pricing rules. - Create price lists and add lines by item or item category, with unit of measure, price and effective dates. - Create qualifier groups for customer, price list, order type or other criteria, so that you can reuse them. - Create modifier lists, and add lines such as discount, surcharge, freight charge or promotional goods, each with a level (line or order), phase and incompatibility group. - Define formulas where a price depends on a calculation, such as cost plus a markup, using formula lines of type function, numeric or price list. - Test with a sales order, and use the pricing request viewer to see which lists and modifiers were considered and why. ## Sections ### How the engine works **Body:** The pricing engine takes a request from the calling application with the item, quantity, customer and other attributes. It first picks a price list line to get the base price, then evaluates modifiers in phases, such as line-level adjustments and order-level adjustments. Each modifier passes only if its qualifiers and pricing attributes match the request and it is not blocked by another modifier in its incompatibility group. Understanding phases matters because it controls order of application. A percentage discount applied before a surcharge produces a different result than the reverse, and 'best price' incompatibility rules decide which of several competing discounts wins. ### Qualifiers and attributes **Body:** A qualifier limits who gets a list or modifier: a customer, customer class, price list, order type or other attribute. Qualifiers can be set on the list header, applying to all lines, or on a single line. Group qualifiers with AND and OR logic carefully, since overlapping groups often explain why a discount did not apply. Pricing attributes limit what the line applies to, such as an item, item category or a product attribute. These require the attribute mapping to be built so the engine can read the order data. ### Why a price or discount does not apply **Body:** Work through a short list: does the customer meet the qualifier, are the dates effective, is the modifier active and approved, is the unit of measure matched, is the phase correct, and is another modifier in the same incompatibility group giving a better price? Also check that attribute mapping ran after any change to pricing attributes. Use the pricing engine request viewer, where available, and the debug option to log the pricing call. The log shows which lists were considered and which modifiers were rejected and why, and it is the quickest way to move from guessing to fact. **Code:** SELECT h.list_header_id, h.name, h.list_type_code, h.start_date_active, h.end_date_active FROM qp_list_headers_vl h WHERE h.active_flag = 'Y' ORDER BY h.name; ## Pitfalls - Changing pricing attributes without rebuilding the attribute mapping. - Overlapping modifiers with the wrong incompatibility group, so a different discount wins. - Setting qualifiers on both header and lines with conflicting logic. - Not testing end dates, so a price list silently expires. - Editing production lists without a test copy and a documented rollback. ## Ai Angle Pricing complaints come as questions like why did this customer get that price. An assistant grounded in your EBS pricing tables and order data can trace which price list and modifiers apply to a given customer and item, show the SQL, and stay read-only. Netray deploys it on-prem so price lists and customer terms remain inside your network. ## Faq ### What is the difference between a price list and a modifier? **Answer:** A price list gives the base price of an item. A modifier changes that price afterward, for example with a discount, surcharge, freight charge or free goods. Both can be restricted by qualifiers. ### What are qualifiers in Oracle Advanced Pricing? **Answer:** Qualifiers decide who or what a price list or modifier applies to, such as a customer, customer class or order type. They can be defined on the header or on a line and combined in groups with AND and OR logic. ### Why is my modifier not applying to the order? **Answer:** Check qualifiers, effective dates, active status, phase, level, unit of measure and incompatibility groups. Also confirm attribute mapping ran. A pricing debug log will show whether the modifier was considered and why it was rejected. ### Can I base prices on a formula? **Answer:** Yes. Formulas can calculate a price using price list values, numeric constants, functions and factor lists, for example cost plus a percentage. Test them carefully, since errors in a formula affect every order using the line. ## Search terms oracle ebs advanced pricing, oracle advanced pricing modifiers, oracle ebs price list setup, oracle advanced pricing qualifiers, oracle pricing formulas, oracle advanced pricing phases, oracle pricing engine request viewer, qp_list_headers --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json