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

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 the Siebel application uses to validate a compound product. For each rule, you define a simple expression and select an error message that you define using the Unified Messaging Service. If the expression is true, the Siebel application displays the error message to the user and does not validate the compound product.

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

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

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 compound product for the network.
  3. Click the Product Validation view tab.
  4. In the link bar, click Product Validation Expression Rules.
  5. In the Product Validation Expression Rules list, add one or more new records and complete the necessary fields. Some fields are described in the following table.
    Field
    Description

    Sequence

    The sequence in which the rule is executed.

    Message

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

    Search Expression

    Enter an expression in Oracle's 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 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 generates an error message. For example, if you use the [Count] function to count the number of records with an error, you do not want to generate an error message when [Count] = 0, so in this field, enter [Count] >= 1.

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