Siebel Order Management Guide Addendum for Industry Applications > Setting Up Network Ordering > Process of Defining Network Compound Products >

Defining Simple Expression Rules for Compound Products


The simple expression checker business service allows product administrators to use Siebel Query Language to create simple expressions that are used to validate a compound product.

This task is a step in Process of Defining Network Compound Products.

For each rule, you define a simple expression and select an error message that you defined using the Unified Messaging Service. If the expression is true, the application displays the error message to the end user and the compound product is invalid.

For more information about Siebel Query Language, see the section about operators, expressions, and conditions in Siebel Developer's Reference.

To define simple expression rules for compound products

  1. Navigate to the Administration - Product screen.
  2. In the Products list, click the name of the product that was defined as the compound product for the network.
  3. Click the Compound Products view tab.
  4. In the link bar, click Simple Validation Expression Rules.
  5. In the Compound Products list, add one or more new records and complete the necessary fields. Some fields are described in the following table:
    Field
    Comments

    Sequence

    Enter the sequence in which the rules are executed.

    Message

    Select the error message that is displayed if the expression is true.

    Search Expression

    Enter an expression in Siebel Query Language.

    The expression can refer to fields in the following business components.

    • Asset Mgmt - Asset
      • Asset Mgmt - Asset XA
    • Quote Item
      • Order Item XA
    • Order Entry - Line Item
      • Order Item XA

    Aggregate Function

    Enter the type of query to be run. Valid values are Count, Sum, Min, Max, and Avg.

    Aggregate Field

    If the expression uses an aggregate function of Sum, Min, Max, or Avg enter the name of the field to aggregate.

    Group By Fields

    If the expression uses an aggregate function, optionally enter a comma separated list of fields by which to group the Aggregate function.

    Having Expression

    If the expression uses an aggregate function, enter an expression that must be met to generate an error. For example, if you use the [Count] function to count the number of records with an error, you would not want to generate an error message when [Count] = 0, so in this field, you should enter [Count] >= 1.

Siebel Order Management Guide Addendum for Industry Applications Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.