Siebel Order Management Infrastructure Guide > PSP Engine > Row Set Transformation Toolkit Methods >

Simple Look-Up Method


The Simple Look-Up method looks up each input row in a business component using a simple search expression. For example, it could be used to look up list price or exclusive eligibility.

Arguments
Input Argument
Description

Context

Optional. Property set of variables shared across all rows.

Row Set

The set of rows to process.

Output Row Set

Optional. The property set used for output.

Process Condition

A Boolean condition that is evaluated to determine whether to process each row.

Business Object

The business object to query.

Business Component

The business component to query.

Search Specification

A search expression comprised of business component fields, literals, and variable values from {Context} and {Row}. For example:

[Price List Id] = {Row.Price List Id} AND [Product Id] = {Row.Product Id}

In Memory Search Specification

Optional. Additional terms that are ANDed with the Search Specification. The In Memory Search Specification is executed in memory. This can be used only if Cache Enabled is Y.

Cache Search Specification

Optional. Additional terms that define the key values for the Level 1 cache; for example:

[Price List Id] = {Row.Price List Id})

For more information, see About PSP Cache.

Sort Specification

Optional. A comma-separated list of business component fields used to sort the query result.

Cache Enabled

Optional. Specifies whether to cache query results. Y or N. The default is N.

On First Match [1..20]

Actions to perform on the first query result for each input row.

On Match [1..20]

Actions to perform on every query result for each input row.

On Last Match [1..20]

Actions to perform on the last query result for each input row.

On No Match [1..20]

Actions to perform if there are no query results for an input row.

Example

Figure 31 shows an example of arguments for a PSP procedure step named In Price List, which uses the Simple Look-Up method.

Figure 31. Example of Arguments for Simple Look-Up Method
Click for full size image

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