Oracle Apps Pricing Modifiers - Modifier scenarios

Scenario 1

If the customer is a preferred customer or customer spends more than 150 currency units, they receive 10% off the order.

Scenario 2

For any ten compact discs purchased by April 2000, the customer receives 2 currency units off.

Scenario 3

For every eight currency units spent on cat food, the customer accrues five shopper points.

Scenario 4

Customers mentioning the Summer Special Promotion receive 5 currency units off of any tennis racket except the FastFireIII model

Scenario 5

Customers who buy two bottles of shampoo receive one currency unit off of the third bottle of shampoo.

Scenario 6

Customers in the National Accounts territory who spends less than 1000 currency units per order receives a 2% surcharge.

Scenario 7

Any customers placing a rush order (delivery required within two days) for replacement motors receives a 50 currency unit surcharge.

Scenario 8

All employees in Company ABC's mobile phone plan receive per minute discounts based on minutes used, as follows:

0-120 minutes: 0.5 currency units per minute

121-240 minutes: 0.10 currency units per minute

241-420 minutes: 0.12 currency units per minute

> 421 minutes: 0.15 currency units per minute

A customer who uses 150 minutes receives the following discounts:

0.5 currency unit per minute discount on 120 minutes

0.10 currency unit per minute discount on 30 minutes

Scenario 9

Customers who buy cases of TY brand products across an order receive a percent rebate per case as follows:

1 - 500 cases: 2% rebate per case

501 - 1000 cases: 3% rebate per case

> 1000 cases: 5% rebate per case

Scenario 10

Customers who buy more than three meters of fabric across an order receive 10% off thermal curtain linings and 5% off drapery services.

Scenario 11

Customers who buy a set of six chairs, a coffee table, or two standard lamps receive 400 currency units off of a dining table.

Scenario 12

Customers who buy one bottle of shampoo receive a free bottle of conditioner.

Scenario 13

Customers who buy two bottles of shampoo receive 10% off the purchase of a third bottle of shampoo.

Scenario 14

Customers who spend over 45 currency units on an order receive a free cosmetic bag.

Scenario 15

Customers who buy any product in the Chubo brand receive 10% off any item in the Chubo brand on their next order.

Scenario 16

Customers ordering from the website receive a coupon for 10% off a future order.

Scenario 17

With any order, receive a coupon for two free bags of coffee on a future order.

Scenario 18

Customers who order a standard video recorder before end of April 2000 receive a deluxe video recorder for the same price.

Scenario 19

Customers who buy a shirt receive the shirt and a tie for the shirt price.

Scenario 20

Customers who spend more than 1000 currency units on a sofa pay nothing for shipping.

Scenario 21

Customers who buy more than 100 currency units of one item on an order receive terms of 2% 30/NET 60.

Scenario 22

For all low priority shipments, calculate shipping charges by order line total weight as follows:

0 - 500 kg: 2.50 currency units

501 - 1000 kg: 3.50 currency units

> 1000 kg: 5.00 currency units

Profile Option QP: Line Weight UOM Code is kg.

Scenario 23

Calculate freight handling charge as a 10% markup of actual handling cost.

Modifier Scenarios

The following scenarios illustrate how to meet business needs by creating modifiers. The scenarios are organized by the following modifier concepts:

• Discount
• Surcharge
• Price break
• Other item discount
• Promotional goods
• Coupon issue
• Item upgrade
• Terms substitution
• Freight and special charges
• Newprice

Each scenario is identified by a number and the numbers do not re-start with one at the beginning of each modifier concept; they are continuous throughout the appendix.

Discount

Scenario 1

If the customer is a preferred customer or customer spends more than 150 currency units, they receive 10% off the order.

ü  Create a modifier.

ü  Modifier Type: Discount

ü  Modifier Level: Order

ü  Application Method: Percent

ü  Value: 10

In the Line Qualifiers window, create two line qualifiers.

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Order Amount

ü  Operator: Between

ü  Value From: 150

ü  Grouping Number: 2

ü  Qualifier Context: Customer

ü  Qualifier Attribute: Customer Class

ü  Operator: =

ü  Value From: Preferred

Scenario 2

For any ten compact discs purchased by April 2000, the customer receives 2 currency units off.

ü  Create a modifier.

ü  Modifier Type: Discount

ü  Modifier Level: Line

ü  End Date: 30 April 2000

ü  Product Attribute: Item Category

ü  Product Attribute Value: CD

ü  Volume Type: Item Quantity

ü  Break Type: Recurring

ü  Value From: 10

ü  Application Method: Lumpsum

ü  Value: 2

Scenario 3

For every eight currency units spent on cat food, the customer accrues five shopper points.

ü  Create a modifier.

ü  Modifier Type: Discount

ü  Modifier Level: Line

ü  Product Attribute: Item Category

ü  Product Attribute Value: Cat Food

ü  Volume Type: Item Amount

ü  Break Type: Recurring

ü  Value From: 8

ü  Select Accrue

ü  Benefit Quantity: 5

ü  Benefit UOM: Shopper Point

Scenario 4

Customers mentioning the Summer Special Promotion receive 5 currency units off of any tennis racket except the FastFireIII model

ü  Create a modifier.

ü  Modifier No: SUMMER SPECIAL

ü  Modifier Type: Discount

ü  Modifier Level: Line

ü  Product Attribute: Item Category

ü  Product Attribute Value: Tennis Rackets

ü  Application Method: Amount

ü  Value: 5

In the Exclude window, create an excluded item.

ü  Product Attribute: Item

ü  Product Value: FastFire III

ü  Select Exclude

Scenario 5

Customers who buy two bottles of shampoo receive one currency unit off of the third bottle of shampoo.

ü  Create a modifier.

ü  Modifier Type: Discount

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Shampoo

ü  Volume Type: Item Quantity

ü  Break Type: Recurring

ü  UOM: Each

ü  Value From: 3

ü  Application Method: Lumpsum

ü  Value: 1

Surcharge

Scenario 6

Customers in the National Accounts territory who spends less than 1000 currency units per order receives a 2% surcharge.

ü  Create a modifier.

ü  Modifier Type: Surcharge

ü  Modifier Level: Order

ü  Application Method: Percent

ü  Value: 10

In the Line Qualifiers window, create two line qualifiers for the modifier.

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Order Amount

ü  Operator: Between

ü  Value To: 1000

ü  Grouping Number: 1

ü  Qualifier Context: Customer

ü  Qualifier Attribute: Customer Class

ü  Operator: =

ü  Value From: National Accounts

Scenario 7

Any customers placing a rush order (delivery required within two days) for replacement motors receives a 50 currency unit surcharge.

ü  Create a modifier.

ü  Modifier Type: Surcharge

ü  Modifier Level: Line

ü  Product Attribute: Item Category

ü  Product Attribute Value: Motors, Spare

ü  Application Method: Amount

ü  Value: 50

In the Line Qualifiers window, create a qualifier for the modifier. You have created qualifier attribute Days to Requested Delivery and created the appropriate sourcing rules for this attribute.

ü  Grouping Number: 1

ü  Qualifier Context: Order

ü  Qualifier Attribute: Days to Requested Delivery

ü  Operator: Between

ü  Value To: 2

Price Break

Scenario 8

All employees in Company ABC's mobile phone plan receive per minute discounts based on minutes used, as follows:

0-120 minutes: 0.5 currency units per minute

121-240 minutes: 0.10 currency units per minute

241-420 minutes: 0.12 currency units per minute

> 421 minutes: 0.15 currency units per minute

A customer who uses 150 minutes receives the following discounts:

0.5 currency unit per minute discount on 120 minutes

0.10 currency unit per minute discount on 30 minutes

ü  Create a modifier.

ü  Modifier Type: Price Break Header

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Minutes

ü  Volume Type: Item Quantity

ü  Break Type: Range

ü  Adjustment Type: Discount

ü  In the Price Break Lines region, enter the break lines.

ü  Value From: 0

ü  Value To: 120

ü  Application Method: Amount

ü  Value: 5

ü  Value From: 121

ü  Value To: 240

ü  Application Method: Amount

ü  Value: 10

ü  Value From: 241

ü  Value To: 420

ü  Application Method: Amount

ü  Value: 12

ü  Value From: 421

ü  Application Method: Amount

ü  Value: 15

In the Line Qualifiers window, create a qualifier for the price break modifier.

ü  Grouping Number: 1

ü  Qualifier Context: Customer

ü  Qualifier Attribute: Customer Name

ü  Operator: =

ü  Value From: ABC

Scenario 9

Customers who buy cases of TY brand products across an order receive a percent rebate per case as follows:

1 - 500 cases: 2% rebate per case

501 - 1000 cases: 3% rebate per case

> 1000 cases: 5% rebate per case

ü  Create a modifier.

ü  Modifier Type: Price Break Header

ü  Modifier Level: Group of Lines

ü  Product Attribute: Item Category

ü  Product Attribute Value: TY

ü  Volume Type: Item Quantity

ü  Break Type: Point

ü  UOM: Case

ü  Adjustment Type: Discount

ü  Select Accrue

ü  In the Price Break Lines window, enter the break lines.

ü  Value From: 1

ü  Value To: 500

ü  Application Method: Percent

ü  Value: 2

ü  Value From: 501

ü  Value To: 1000

ü  Application Method: Percent

ü  Value: 3

ü  Value From: 1001

ü  Application Method: Percent

ü  Value: 5

Other Item Discount

Scenario 10

Customers who buy more than three meters of fabric across an order receive 10% off thermal curtain linings and 5% off drapery services.

ü  Create a modifier.

ü  Modifier Type: Other Item Discount

ü  Modifier Level: Group of Lines

ü  Product Attribute: Item Category

ü  Product Attribute Value: Fabric

ü  Volume Type: Item Quantity

ü  Break Type: Point

ü  UOM: Yard

ü  Value From: 10

ü  In the modifier details, enter the get products.

ü  Product Attribute: Item

ü  Product Value: Thermal Linings

ü  Application Method: Percent

ü  Value: 10

ü  Product Attribute: Item

ü  Product Value: Drapery Services

ü  Application Method: Percent

ü  Value: 5

Scenario 11

Customers who buy a set of six chairs, a coffee table, or two standard lamps receive 400 currency units off of a dining table.

ü  Create a modifier.

ü  Modifier Type: Other Item Discount

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Dining Chair

ü  Volume Type: Item Quantity

ü  Break Type: Point

ü  UOM: Each

ü  Value From: 6

ü  In the modifier details, enter the related product.

ü  Group No: 1

ü  Product Attribute: Item

ü  Product Value: Coffee Table

ü  UOM: Each

ü  Group No: 2

ü  Product Attribute: Item

ü  Product Value: Standard Lamp

ü  Pricing Attribute: Item Quantity

ü  Operator: Between

ü  Value From: 2

ü  UOM: Each

ü  In the modifier details, enter the get product.

ü  Product Attribute: Item

ü  Product Value: Dining Table

ü  Application Method: Amount

ü  Value: 400

ü  Promotional Goods

Scenario 12

Customers who buy one bottle of shampoo receive a free bottle of conditioner.

ü  Create a modifier.

ü  Modifier Type: Promotional Goods

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Shampoo

ü  Volume Type: Item Quantity

ü  Break Type: Recurring

ü  UOM: Each

ü  Value From: 1

ü  In the modifier details, enter the get product.

ü  Product Attribute: Item

ü  Product Value: Conditioner

ü  Get Quantity: 1

ü  Get Price: <price list line for conditioner>

ü  Get UOM: Each

ü  Application Method: Percent

ü  Value: 100

Scenario 13

Customers who buy two bottles of shampoo receive 10% off the purchase of a third bottle of shampoo.

ü  Create a modifier.

ü  Modifier Type: Promotional Goods

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Shampoo

ü  Volume Type: Item Quantity

ü  Break Type: Recurring

ü  UOM: Each

ü  Value From: 2

ü  In the modifier details, enter the get product.

ü  Product Attribute: Item

ü  Product Value: Shampoo

ü  Get Quantity: 1

ü  Get Price: <price list line for shampoo>

ü  Get UOM: Each

ü  Application Method: Percent

ü  Value: 10

Scenario 14

Customers who spend over 45 currency units on an order receive a free cosmetic bag.

ü  Create a modifier.

ü  Modifier Type: Promotional Goods

ü  Modifier Level: Order

ü  In the Line Qualifiers window, create a qualifier.

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Order Amount

ü  Operator: Between

ü  Value From: 45

ü  In the modifier details, enter the get product.

ü  Product Attribute: Item

ü  Product Value: Cosmetic Bag

ü  Get Quantity: 1

ü  Get Price: <price list line for cosmetic bag>

ü  Get UOM: Each

ü  Application Method: Percent

ü  Value: 100

Coupon Issue

Scenario 15

Customers who buy any product in the Chubo brand receive 10% off any item in the Chubo brand on their next order.

ü  Create a modifier list

ü  Main region

ü  Type: Promotion

ü  Number: Coupon15

ü  Select Active

ü  Name: Coupon15

ü  Clear Automatic

ü  Create a modifier line for the discount.

ü  Modifiers Summary tabbed region

ü  Modifier Level: Line

ü  Modifier Type: Discount

ü  Product Attribute: Item Category

ü  Product Attribute Value: Chubo

ü  Discounts/Charges tabbed region

ü  Application Method: Percent

ü  Value: 10

ü  Create a second modifier line for the coupon issue and assign it to the modifier from step 1.

ü  Modifier Type: Coupon Issue

ü  Modifier Level: Line

ü  Product Attribute: Item Category

ü  Product Attribute Value: Chubo

ü  Coupon Modifier: <discount modifier from previous step>

Scenario 16

Customers ordering from the website receive a coupon for 10% off a future order.

ü  Create a modifier line.

ü  Modifier Type: Discount

ü  Modifier Level: Order

ü  Application Method: Percent

ü  Value: 10

ü  Create a second modifier line for the coupon issue and assign it to the modifier from step 1.

ü  Modifier Type: Coupon Issue

ü  Modifier Level: Order

ü  Coupon Modifier: <modifier from step 1>

In the line qualifiers window, create a qualifier for the coupon issue modifier from step 2. You have created the qualifier attribute Website Domain and created the appropriate sourcing rules for it.

ü  Grouping Number: 1

ü  Qualifier Context: Customer

ü  Qualifier Attribute: Website Domain

ü  Operator: =

ü  Value From: co.uk

Scenario 17

With any order, receive a coupon for two free bags of coffee on a future order.

ü  Create a modifier line.

ü  Modifier Type: Promotional Goods

ü  Modifier Level: Order

ü  In the modifier details, enter the get product.

ü  Product Attribute: Item

ü  Product Value: Coffee

ü  Get Quantity: 2

ü  Get Price: <price list line for bag of coffee>

ü  Get UOM: Bag

ü  Application Method: Percent

ü  Value: 100

ü  Create a second modifier line for the coupon issue and assign it to the modifier from step 1.

ü  Modifier Type: Coupon Issue

ü  Modifier Level: Order

ü  Coupon Modifier: <modifier from step 1>

ü  Item Upgrade

Scenario 18

Customers who order a standard video recorder before end of April 2000 receive a deluxe video recorder for the same price.

ü  Create a modifier.

ü  Type: Promotion or Deal

ü  Date Type: Requested Ship Date

ü  End Date: 31 April 2000

ü  Assign a modifier line to the modifier list in Step 1. You have defined the item relationship between the standard video recorder and deluxe video recorder.

ü  Modifier Type: Item Upgrade

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Video Recorder Standard

ü  Upgrade Item: Video Recorder Deluxe

Scenario 19

Customers who buy a shirt receive the shirt and a tie for the shirt price.

ü  Create a modifier. You have defined the item relationship between the shirt and the marketing bill shirt and tie pack.

ü  Modifier Type: Item Upgrade

ü  Modifier Level: Line

ü  Product Attribute: Item

ü  Product Attribute Value: Shirt

ü  Upgrade Item: Marketing item shirt and tie pack

ü  Terms Substitution

Scenario 20

Customers who spend more than 1000 currency units on a sofa pay nothing for shipping.

ü  Create a modifier.

ü  Modifier Type: Terms Substitution

ü  Modifier Level: Line

ü  Product Attribute: Item Category

ü  Product Attribute Value: Sofa

ü  Volume Type: Item Amount

ü  Break Type: Point

ü  UOM: Each

ü  Value From: 1000

ü  Terms Attribute: Shipping Terms

ü  Terms Value: No Charge

Scenario 21

Customers who buy more than 100 currency units of one item on an order receive terms of 2% 30/NET 60.

ü  Create a modifier.

ü  Modifier Type: Terms Substitution

ü  Modifier Level: Line

ü  Terms Attribute: Payment Terms

ü  Terms Value: 2% 30/NET 60

ü  In the Line Qualifiers window, create a qualifier.

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Line Amount

ü  Operator: Between

ü  Value From: 100

ü  Freight and Special Charges

Scenario 22

For all low priority shipments, calculate shipping charges by order line total weight as follows:

0 - 500 kg: 2.50 currency units

501 - 1000 kg: 3.50 currency units

> 1000 kg: 5.00 currency units

Profile Option QP: Line Weight UOM Code is kg.

ü  Create a modifier.

ü  Modifier Type: Freight Charge

ü  Modifier Level: Line

ü  Application Method: Lumpsum

ü  Value: 2.50

ü  In the Line Qualifiers window, create a qualifier for the modifier from step 1.

ü  Grouping Number: 1

ü  Qualifier Context: Order

ü  Qualifier Attribute: Shipment Priority

ü  Operator: =

ü  Value From: Low

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Line Weight

ü  Operator: =

ü  Value From: 0

ü  Value To: 500

ü  Create a second modifier.

ü  Modifier Type: Freight Charge

ü  Modifier Level: Line

ü  Application Method: Lumpsum

ü  Value: 3.50

ü  In the Line Qualifiers window, create a qualifier for the second modifier from step 3.

ü  Grouping Number: 1

ü  Qualifier Context: Order

ü  Qualifier Attribute: Shipment Priority

ü  Operator: =

ü  Value From: Low

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Line Weight

ü  Operator: =

ü  Value From: 501

ü  Value To:1000

ü  Create a third modifier.

ü  Modifier Type: Freight Charge

ü  Modifier Level: Line

ü  Application Method: Lumpsum

ü  Value: 3.50

ü  In the Line Qualifiers window, create a qualifier for the third modifier from step 5.

ü  Grouping Number: 1

ü  Qualifier Context: Order

ü  Qualifier Attribute: Shipment Priority

ü  Operator: =

ü  Value From: Low

ü  Grouping Number: 1

ü  Qualifier Context: Volume

ü  Qualifier Attribute: Line Weight

ü  Operator: =

ü  Value From: 1001

Scenario 23

Calculate freight handling charge as a 10% markup of actual handling cost.

ü  Create a formula.

ü  Formula Name: Handling Cost

ü  Formula: 1 * 2

ü  Create a formula line.

ü  Formula Line Type: Pricing Attribute

ü  Pricing Attribute Context: Pricing Attribute

ü  Pricing Attribute: Handling Cost Amount

Step: 1

ü  Formula Line Type: Constant

ü  Component: 1.1

Step: 2

ü  Create a modifier.

ü  Modifier Type: Freight Charge

ü  Modifier Level: Line

ü  Application Method: Lumpsum

ü  Formula: <reference formula Handling Cost from step 1>

ü  In the Line Qualifiers window, create a qualifier for the third modifier from step 2.

ü  Grouping Number: 1

ü  Qualifier Context: Order

ü  Qualifier Attribute: Freight Cost Type

ü  Operator: =

ü  Value From: Handling

ü  Newprice

Scenario 24

The following table states the scenario for this newprice example. Following the table, the text analyzes the scenario:

Table: Newprice Scenario: List Price 1000, Selling Price 25

Incompatibility Level	Precedence	Bucket	Operator	Value	Engine Selects
1	10	1	NEWPRICE	30	No
1	10	1	NEWPRICE	25	Yes
1	10	1	NEWPRICE	40	Yes

Within the same incompatibility group, when all of the lines have the same Precedence, the pricing engine performs best price processing. The final selling price is in line 2, 25 currency units. In this scenario, the bucket is not important to the result.

Scenario 25

The following table states the scenario for this newprice example. Following the table, the text analyzes the scenario:

Table: Newprice Scenario: List Price 1000, Selling Price -1005

Incompatibility Level	Precedence	Bucket	Operator	Value	Engine Selects	Adjusted Amount
1	10	1	NEWPRICE	30	Yes	-970
2	10	1	NEWPRICE	25	Yes	-975
3	10	1	NEWPRICE	40	Yes	-960

With different incompatibility levels, the pricing engine evaluates the lines according to buckets. Since all of the lines are in the same bucket, the pricing engine calculates Adjusted Amount from the list price. It calculates the selling price as follows:

List Price - Sum of the Adjusted Amounts

1000 - (970 + 975 + 960) = 1000 - 2095 = -1905

Scenario 26

The following table states the scenario for this newprice example. Following the table, the text analyzes the scenario:

Table: Newprice Scenario 3: List Price 1000, Selling Price 40

Incompatibility Level	Precedence	Bucket	Operator	Value	Engine Selects	Adjusted Amount
1	10	1	NEWPRICE	30	Yes	-970 (Base price: 1000)
2	10	2	NEWPRICE	25	Yes	-5 (Base price: 30)
3	10	3	NEWPRICE	40	Yes	15 (Base price: 25)

With different incompatibility levels, the pricing engine evaluates the lines according to buckets. Since each line is in a different bucket, the pricing engine calculates Adjusted Amount from the base price of the previous bucket (list price is in bucket 0). It calculates the selling price as follows:

List Price - Sum of the Adjusted Amounts

1000 - (970 + 5 - 15) = 1000 - 960 = 40

As the pricing engine evaluates the eligible list lines, it resolves incompatibilities in all phases. You can set up your modifiers such that the pricing engine determines most of the list line eligibility at the search stage. Then, the pricing engine calculates the final selling price bucket by bucket.

Formula Scenarios

Splinters Glass Company manufactures windshields for cars and trucks. It sells both to wholesale customers and to retail customers.

Scenario 1

To its retail customers, Splinters prices windshields based on the dimension of the sheet of glass according to the formula 3 currency units * Width * Height * Thickness Factor.

The following table shows the thickness factors.

Table:

Glass Thickness	Thickness Factor
< 5 mm	10%
5 mm - 10 mm	15%
> 10 mm	20%

Splinters sets up Oracle Pricing to use formula and factor-based pricing.

Step 1

1. In the flexfield definition window, query the pricing attributes flexfield.

2. Define three new pricing attributes flexfield segments--width, height, and thickness. Use the context Pricing Attributes.

3. Save your work and close the window.

Step 2

Create a pricing formula.

1. Create a formula header.

Formula Name: Glass Pricing Formula and Formula = 1 * 2 * 3 *4

2. Create a formula line.

Formula Type: Numeric Constant

Component: 3

Step Number: 1

3. Create a second formula line.

Formula Type: Pricing Attributes

Pricing Attribute Context: Pricing Attributes

Pricing Attribute: Width

Step Number: 2

4. Create a third formula line.

Formula Type: Pricing Attributes

Pricing Attribute Context: Pricing Attributes

Pricing Attribute: Height

Step Number: 3

5. Create a fourth formula line.

Formula Type: Factor List

Component: Thickness Factor

Step Number: 4

6. Click Factors.

7. In the Base Pricing Attributes region, create a row.

Base Pricing Attribute: Thickness

Comparison Operator: Between

Value From: 0

Value To: 5

Adjustment Factor: 0.10

8. Create a second row in the Base Pricing Attributes region.

Base Pricing attribute: Thickness

Comparison Operator: Between

Value From: 5

Value To: 10

Adjustment Factor: 0.15

9. Create a third row in the Base Pricing Attributes region.

Base Pricing Attribute: Thickness

Comparison Operator: Between

Value From: 10

Adjustment Factor: 0.20

10. Save your work and close the window.

Step 3

Create a price list for retail customers, create a list line, and attach the formula.

1. Create a price list.

Name: Retail

2. Select the Qualifiers tabbed region.

3. Add a qualifier.

Context: Customer

Attribute: Customer Class

Value: Retail

4. Create a new list line.

Item: Windshield

UOM: Each

Dynamic Formula: Glass Pricing Formula

Method: Amount

Line Type: PLL

5. Save your work and close the window.

Scenario 2

To its retail customers, Splinters charges for its windshield warranty protection plan at 10% of the cost of the replacement windshield. The formula is 10% * price of the Windshield item on the Replacement price list).

Splinters sets up Oracle Pricing to use formula-based pricing.

Step 1

Create a new pricing formula.

1. Create a formula header.

Formula Name: Warranty Pricing Formula

Formula: 1*2

2. Create a formula line.

Formula Type: Numeric Constant

Component: 0.10

Step Number: 1

3. Create a second formula line.

Formula Type: Price List Line

Component: Windshield line of Replacement price list

Step Number: 2

4. Save your work and close the window.

Step 2

Create a price list for retail customers, create a list line, and attach the formula.

1. Create a price list.

Name: Warranties

2. In the Qualifiers region, add a qualifier.

Context: Customer

Attribute: Customer Class

Value: Retail

3. Create a list line.

Item: Protection Plan

UOM: Each

Dynamic Formula: Warranty Pricing Formula

Method: Amount

Line Type: PLL

4. Save your work and close the window.