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 an error message. If the expression is true, the application displays the error message to the end user and the compound product is invalid.

For example, you can create a rule to check that every connection has a service address defined for both its endpoints. The error message states the number of connections that do not have both service addresses defined.

  • As the expression, enter: ([Network Element Type] = "Network Connection" AND ([Service Address] = ""OR [To Service Address] = ""))
  • As the error message, enter: [Count] [Product]s do not have a service address defined for both its endpoints.
  • Because the error message uses the aggregate function [Count], enter the other information needed when you use aggregate expressions, as detailed in the field list for the procedure.

If this expression is true, the connection does not have a service address for at least one of its end points, and the engine displays an error message to the user.

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 Expressions.
  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.

    Error Text

    Enter the error message that will be displayed if the expression is true.

    The error message can contain field names, attribute names and aggregate function names. Field names and aggregate function names are delimited by [ and ]; attribute names are delimited by { and }.

    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 © 2007, Oracle. All rights reserved.