Business Process Automation
This page is accessed via Business Process Automation > Agents and Milestones > Threshold. Click the Threshold Definition tab.
Use this page to define the threshold attributes.
Choose an object attribute from Column.
Some of the attributes are calculated fields and do not appear on any of the manager screens.
Calculated fields cannot be used as a threshold comparison. For example, the order release weight thresholds cannot be used since they are a calculated field.
Agents do not support thresholds with object attribute names beginning with "Total." For instance, "Total Gross Weight."
Selecting a Date attribute
displays a series of prompts to enter a time change (day/minute/hour)
from the current value. The threshold is triggered by a change of the
current date value to any value greater than the current date/time plus
the threshold displacement, or any value less than the current value minus
the threshold displacement. The modify event would be raised for any change
meeting the following definition (current value - displacement) > new
value > (current value + displacement). Date columns do not allow for
a percentage change, only a delta.
For all other attribute types, the following three controls are presented.
a prompt for entering the numeric value of the threshold.
a list to select the unit of measure.
a list to select whether to use percentage change or delta change.
change ignores any unit of measure selected as they will be the same as
the underlying value.
Delta is the difference between two values. A delta threshold looks at the difference between the old value and the new value. For example if the old value was 50 and the new value is 40, then the delta is 10.
If you use both a delta and a percentage threshold on the same column, if either threshold fails to be met, the event is called.
If the units of the threshold are different than the original data value's units, then the threshold value and the current data value is converted to a common unit of measure before comparison.
After completing a threshold, create a threshold profile for your threshold.
The threshold condition appears as follows:
table_name.column_name=Numeric Value Unit of Measure Threshold Type
ob_ship_unit.weight=25 TON Delta
ob_ship_unit.weight=25 TON %
Date thresholds are expressed as the number of seconds representing the day/minute/hour duration.