Showing posts with label Pricing. Show all posts
Showing posts with label Pricing. Show all posts

Friday, October 17, 2014

Query to derive Qualifier Attribute and Context from Modifier Name

Query :

  c.list_line_no "Modifier Line No", "Modifier Name",
  b.description  "Modifier Description",
FROM qp_qualifiers_v a,
  qp_list_headers b,
  qp_list_lines c
WHERE a.list_header_id=b.list_header_id
and c.list_header_id=b.list_header_id
and c.list_line_id = a.list_line_id
and = &Modifier_Name
ORDER BY a.creation_date DESC;

Monday, October 6, 2014

Buckets in Oracle Pricing Modifiers


Pricing buckets control how discounts and other benefits are calculated across phases. Grouping discounts and benefits into buckets helps determine the net selling price across all pricing phases.
Null Bucket.

Modifiers that are assigned to a Null bucket are applied last and always adjust from the list price. Order level modifiers must be in the Null bucket. The pricing engine uses the following steps when calculating the selling price for Null buckets:

  1. Calculates percent discounts using the list price.
  2. Sums all bucket modifier values to create a bucket subtotal.
  3. Applies the subtotal after the last numbered bucket.

Suppose that the following buckets are set up, each with a different adjustment:

  • Null bucket: a 50% discount is assigned to the Null bucket.
  • Bucket 1: a 10% discount is assigned.
  • Bucket 2: a 10% surcharge is assigned.

The buckets are used to calculate the price for an SP ATO Model with a list price of $55. The following table shows how the final price is calculated:

The below are the steps to assign modifiers to different buckets in Oracle Apps R12.

Update Profile Option

Goto:  System Administrator -> Profile Options

Name: QP: Allow Buckets For Manual Modifiers
Value: Yes

Update Pricing Modifier Setup to add buckets

Modifier Name: One-Time Discount

Bucket: 4

Once the buckets are assigned, the modifiers are applied on the priority basis.

Friday, August 29, 2014

Oracle Pricing Setup : Qualifiers In Oracle Apps

Qualifiers in Oracle Pricing are used to determine the eligibility criteria for the modifiers (Discounts, Surcharge and Promotion) to get applied. Qualifiers are used in sync with Price Lists and Modifiers
Qualifiers can be set according to the business needs. Oracle also defines predefined set for Qualifiers.
The following table displays several predefined qualifier structures that you can use to determine benefit eligibility.

Qualifier Context
Qualifier Attributes
Customer Name, Bill To, Sales Channel
Order Type, Shipment Date, Line Type
Payment Term, Freight Terms, Shipping Method
Order Amount, Line Volume
Note: Order Amount as a qualifier refers to the sum of the list prices on all active order lines. It is not the same as Order Total in Oracle Order Management, which can include the effect of modifiers. Order amount also excludes lines for recurring charges. Order lines that have a charge periodicity associated (such as Monthly, Yearly) are recurring charges.

Creating Qualifiers
A qualifier consists of one or more conditions that define eligibility for a discount, promotion, or surcharge). You can create qualifiers and assign qualifier groups to modifiers lists, modifier lines, and price lists. You can create different qualifying conditions depending on how you set up your qualifiers. The different qualifying rules are outlined as follows:

Qualifier Conditions
A qualifier condition defines an eligibility rule, for example, the Order Source name must be “Legacy”. You can set up one or more conditions for a single qualifier. Multiple conditions within the same qualifier are joined to each other by AND:
Condition 1: Order Source must be “Legacy”
Condition 2: Order Type must be “Standard”  AND
Condition 3: Payment term must be “Net”

Unique Qualifiers
Each separate qualifier created for a modifier or price list is called a unique qualifier. Unique qualifiers are evaluated by an OR condition; for example, either Qualifier 1 OR Qualifier 2 can qualify before the price list or modifier is applied.
Each unique qualifier may consist of one or more conditions. The conditions for each unique qualifier are still joined by AND and must evaluate as true before the modifier or price list is applied:
Qualifier 1
Order Source= Legacy
AND (Within Qualifier 1, these conditions are ANDed together.)
Order Type = Standard
Qualifier 2 : Payment Term = Net 30
Common Qualifier
A Common Qualifier is used to create a mandatory condition across all qualifiers. A common qualifier consists of conditions that are joined by AND to all qualifiers in a table. When created, it displays on the qualifier table as a Common Qualifier.
Select the Common Qualifier box to make the qualifier a common qualifier.
For example, suppose you wanted to give a 15percent discount with the following qualifying conditions.
Qualifier 1: Customer is preferred status.
Qualifier 2: Customers must order more than $500from your web site.

Responsibility : Oracle Pricing Manager 

Qualifier Setup


 Enter Mandatory Values

  • Name
  • Context
  • Attribute
  • Operator
  • Value


Thursday, August 28, 2014

Oracle Pricing Setup : Modifiers In Oracle Apps

Modifiers enable you to set up discounts,surcharges,free goods,coupons,freight and special charges that can be applied immediately to pricing requests or accrued for later disbursement. You can setup advanced deals and promotions as well

The following list describes the main modifier concepts and related entities:
• Modifier lists contain one or more modifiers. Modifiers have list level and line level components. Each list level must have one or more lines associated with it.
• By defining qualifiers at the list and line levels, you define a customer's eligibility for the modifier.
• Control features that influence modifiers are products and product groups, pricing attributes, phases, incompatibility groups, levels, and buckets.
• The use of modifiers can result in volume breaks, additional buy/get products, and benefits.

Go to : Oracle Pricing Manager Responsibility 

Navigate to Modifier Setup 

Populate all Mandatory Fields

Mandatory Fields are below :

  • Type : Deal, Discount List, Freight, Promotion and Surcharge List
  • Name : Unique Modifier Identifier
  • Number : Unique Modifier Identifier
  • Modifier Number : Unique Modifier Identifier
  • Level  : Order/Line
  • Modifier Type : Discount/Surcharge
  • Pricing Phase :  Header or Line Adjustment
  • Application Method : This Can be Percent, Lump sum