Tier Aggregation Across a Quote

Oracle CPQ 25B introduces Quantity Aggregation for volume and tier pricing. When Quantity Aggregation is enabled, the aggregate quantity of a part number in a quote is used to calculate price, instead of the quantity on a line item. The quantity is aggregated based on the part number, regardless of whether a line item is a stand-alone part number or BOM item.

The Quantity Aggregation option is disabled by default. To enable the Quantity Aggregation option for Volume and Tier dynamic pricing types, administrators click the Mange Columns icon, and select the Quantity Aggregation option when adding a product price or charge to a Price Model Item.

Quantity Aggregation

Oracle CPQ 25B introduces the new Pricing Option Include relevant line items when triggering pricing in quotes to support quantity aggregation. This option is disabled by default and must be enabled to enable quantity aggregation at runtime.

  • This Boolean type option is set to Off, by default.
  • Set this option to On to enable Quantity Aggregation.

When the pricing engine is triggered during quoting, it may price only a subset of the line items to optimize performance. For instance, when new line items are added via actions like Add from Catalog or Add from Part Search, only those newly added items are priced. When incremental pricing is enabled, only modified line items are priced.

However, when the option is enabled for Quantity Aggregation, the system will also include quote line items that share the same part numbers as the priced items. This ensures that items of the same part number are priced together.

When Pricing Option Include relevant line items when triggering pricing in quotes is enabled and Quantity Aggregation is selected for a product price or charge, the aggregate quantity of a part number is used in a quote instead of the quantity on a line item. The quantity is aggregated based on the part number, irrelevant of whether a line item is a stand-alone part number or BOM item.

For example, assume a customer has a charge with the following Volume pricing defined:

  • Quantity Aggregation: selected
  • Volume Tier 1: Quantity From: 0, Quantity To: 10, Item Price: $600
  • Volume Tier 2: Quantity From: 10, Quantity To: Maximum Value, Item Price: $500

Quantity Aggregation with Volume Pricing

Then a sales user wants to send products to two different locations, so they create a quote with two lines for the same product:

  • Line Item 1: quantity 5
  • Line Item 2: quantity 6

The quantity from both line items is aggregated and both line items are priced at the aggregated quantity (11). The Unit Price for both lines will be $500. Without aggregation, the Unit Price for both line items would be $600.

Quote with Aggregation Pricing

New 'Extended List Amount' Pricing Attribute

Oracle CPQ 25B introduces the new standard Extended List Amount (extendedAmount) attribute to support quantity aggregation. This is the line unit price multiplied by the quantity. Similar to Unit Price, this attribute is not directly accessible in pricing engine, except in BML. By default, this attribute is mapped to Commerce Charge array set, but customers can also add mapping to the line attribute.

Customers can apply volume and tier pricing when the same product occurs multiple times on the sales transaction.

Steps to Enable

Enable Quantity Aggregation

Complete the following steps to enable quantity aggregation.

  1. Navigate to Admin > Pricing Portal > Pricing Options.

  2. Click Edit.

  3. Set the Include relevant line items when triggering pricing in quotes option to On.

  4. Click Update.