Siebel Pricing Administration Guide > Siebel Pricer Technical Reference > Pricing Procedures and Workflow References >

Pricing Procedure - Aggregate Discounts Workflow


The Pricing Procedure - Aggregate Discounts workflow is the subprocedure that evaluates the Aggregate Discount Sequence adjustment. The workflow first aggregates quantities for each product across line items. It then checks if there are possible aggregate discounts set up by examining the price list on both the header and line item level.

The workflow then compares the aggregate discount with the product quantity aggregation it has evaluated earlier to see if it qualifies for any discounts.

Figure 19. Pricing Procedure - Bundle Discount Workflow Process

Workflow Description. This workflow does the following:

  1. Groups line items by Product ID and performs a quantity aggregation. The result of this operation is a property set with Product ID and corresponding aggregated quantities.
  2. Uses Query Transformation to check if there is an Aggregate Discount Sequence associated with the price list from the header, and whether that Aggregate Discount Sequence is effective. If all conditions are met, then the list of IDs of all the aggregate discounts under that sequence would be stored in a property set.
  3. This step is similar to the previous one except that it examines the Price List association of the line item. The IDs of all the possible aggregate discounts would be appended to the previously mentioned property set.
  4. Using Rule Set Lookup Transformation and the information from previous steps, it identifies which of the possible aggregate discounts are satisfied along with the corresponding multiplier for each aggregate discount. This information is used as input to the next step.
  5. Using Rule Set Lookup Transformation and the information from previous steps, it applies adjustments defined in the applicable aggregate discounts and put that on each of the line item. Line items having the same product would be ordered by their net price. Line items with a higher net price would have priority over items with a lower net price.

Table 21 lists the steps in the Pricing Procedure - Aggregate Discounts workflow with the business service and method that is called by each.

Table 21. Steps of the Pricing Procedure - Aggregate Discounts Workflow
Name
Type
Business Service
Method
Sub Process
Description

Sum Product Quantity

Business Service

Row Set Transformation Toolkit

Aggregate Transform

 

Sums up quantities of line items by Product ID.

Get Possible Bundles (Price List)

Business Service

Row Set Transformation Toolkit Service

Query Transform

 

Checks for the Aggregate Discount Sequence associated with the Price List from the Header.

Get Possible Bundles (Row)

Business Service

Row Set Transformation Toolkit Service

Simple Look-Up Transform

 

Checks for the Aggregate Discount Sequence associated with the Price Lists from the Line Items.

Identify Applicable Bundles

Business Service

Row Set Transformation Toolkit Service

Rule Set Look-Up Transform

 

Identifies applicable Aggregate Discounts and corresponding Multiplier.

Apply Bundle Adjustments

Business Service

Row Set Transformation Toolkit Service

Rule Set Look-Up Transform

 

Applies the adjustments defined in aggregate discounts.

Siebel Pricing Administration Guide Copyright © 2006, Oracle. All rights reserved.