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 Oracle's Siebel Query Language, see the section about operators, expressions, and conditions in Siebel Developer's Reference. To define simple expression rules for compound products
- Navigate to the Administration - Product screen.
- In the Products list, click the name of the product that was defined as the compound product for the network.
- Click the Compound Products view tab.
- In the link bar, click Simple Validation Expression Rules.
- In the Compound Products list, add one or more new records and complete the necessary fields. Some fields are described in the following table.
|
|
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 Oracle's Siebel Query Language. The expression can refer to fields in the following business components.
- Asset Mgmt - Asset
- Quote Item
- Order Entry - Line Item
|
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. |
|