Siebel Pricing Administration Guide > Creating Discount Matrices > Process of Creating a Discount Matrix >

Modifying the Pricing Procedure - Calculate Net Price Workflow to Include a Discount Matrix


When you use a discount matrix, you must added an additional step to the workflow Pricing Procedure - Calculate Net Price to apply the discount matrix to the pricing. For more information about this workflow, see Pricing Procedure - Calculate Net Price Workflow.

To modifying the Pricing Procedure - Calculate Net Price workflow to include a discount matrix

  1. In Siebel Tools, select the Pricing Procedure - Calculate Net Price workflow process. Revise and edit this workflow process.
  2. After the Tiered Volume Discount Upsell step, add a new business service step that queries the appropriate discount matrix business component for any discounts associated with each account type.
    1. Define the step as shown in the following table.
      Name
      Type
      Business Service Name
      Business Service Method

      Account Type Adjustments

      Business Service

      Row Set Transformation Toolkit

      Simple Look-Up Transform

    2. Define the input arguments as shown in the following table.
      Input Argument
      Type
      Value
      Property Name

      Context

      Process Property

       

      Context

      Row Set

      Process Property

       

      Row Set

      Business Object

      Literal

      Adjustment Group

       

      Business Component

      Literal

      Product-Based Adjustment

       

      Process Condition

      Literal

      {Row.Product Id} IS NOT NULL AND {Context.Account Type} IS NOT NULL

       

      Search Specification

      Literal

      [Adjustment Group Name] = 'Account Type Discount' AND [Account Type] = {Context.Account Type}

       

      On First Match 1

      Literal

      {Row.Net Price} = AdjustPrice({Row.Net Price}, {Row.Currency Code}, LookupName("PRICER_CALCULATION_SIMPLE_TYPE",

      {Match.Adjustment Type}), {Match.Adjustment Amount}, {Match.Currency Code}, {Row.Exchange Date})

       

      On First Match 2

      Literal

      {Row}.{Net Price Waterfall} += New("Waterfall", [Adjustment Amount] = {Match.Adjustment Amount}, [Adjustment Type] = {Match.Adjustment Type}, [Price] = {Row.Net Price}, [Currency Code] = {Row.Currency Code}, [Text] = LookUpMessage ("Pricer - Account Type Discount",[Account Type] = {Match.Account Type} ,[Discount Matrix] = {Match.Adjustment Group Name}))

       

    3. Define the output arguments as shown in the following table.
      Output Argument
      Property Name
      Type

      Context

      Context

      Output Argument

      Row Set

      Row Set

      Output Argument

  3. Deploy the updated workflow process.
Siebel Pricing Administration Guide Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.