Oracle Pricing.... (Qualifier and Modifier)

Oracle Pricing (Qualifier & Modifier)

Oracle Advanced Pricing provides a logical, flexible setup framework to handle complex pricing scenarios. It enables to break price creation into simple elements: define pricing rules, assign rules to create specific pricing actions, and designate pricing controls. Oracle Advanced Pricing also supports tailored pricing with built-in extensibility features.

Oracle Advance Pricing is part of Oracle Order Management, and integrates seamlessly with other Order Management applications, including Configurator and Order Management.

REQUIRMENT: For customer Bigmart (Customer Number 1168) give 10% discount on the unit price of the items present on sales order.

To fulfill this requirement one Qualifier and one Modifier need to be defined.

Pricing qualifiers controls, who is eligible for certain prices (price lists) and benefits.

The modifier provides price adjustments such as discounts, price breaks, surcharges, coupons, item and term substitutions, and other item discounts. Discount and surcharges modifiers affect the selling price; freight charge modifiers do not affect the selling price.

Now first qualifier needs to be defined and at time of defining modifier this qualifier needs to be attached to the modifier. Qualifier qualifies the pricing request and modifier modifies that.

Define Qualifier: Bigmart Disc.

As this qualifier is newly defined we need to run one concurrent request “Build Attribute Mapping Rules”. This request needs to be run on defining new qualifier, it is always recommended to run the same after doing change in the qualifier.







Defined Modifier: Disc. Bigmart


The requirement is to give 10% to all the line. So select Level as ‘Line’ to apply modifier at line level. Even though it is for all the lines there is a difference in giving 10% discount at all lines level and giving discount at header level. If it would be at Header level 10% will be given to charges also along with items. Also provide all other values relevant to the requirement as shown.



>

Attach Qualifier to the modifier: Click on ‘Line Qualifiers’ button to attach “Bigmart Disc.” to “Disc. Bigmart”.





Sales Order 56771 is entered before creating the Modifier:





Sales Order 56772 is entered after creating the Modifier:




See the difference in prices at line level on two Orders. On sales order 56772 unit price is 1,439.10, which came after 10% discount on the real price (i.e. 10% discount on 1599.00) and on Sales Order 56772 unit price is 1,599.00