Validation Template for Processing Constraints in Oracle OM

Order Management provides you the ability to define your own validation conditions by the use of validation templates. A validation template names a condition and defines the semantics of how to validate that condition. Validation templates can be used in the processing constraints framework to specify the constraining conditions for a given constraint.

These conditions are based on:
• Where the entity is in its workflow
• The state of attributes on an entity
• Any other validation condition that cannot be modeled using the above methods

API based validation templates are not available if constrained entity is different from the entity for which the validation template has been defined (or the Validation templates are not available even if the record set being used is anything other than the primary key record set).

For example, API based Validation template Pick Released has been set up for entity Order Line. If you set up a constraint for attribute Ship To on Order Line, the validation template Pick Released is available but for a constraint on attribute Ship To on Order Header, Pick Released will not be available.

For attribute Ship To on Order Line, if the constraint condition uses any record set (ATO Configuration, for example) other than the primary key record set Order Line, the validation template Pick Released will not be available.

Define a validation template:


Validation Types
Select the Validation Type to be performed by the condition. Select from:
WF: (validation is based on the workflow status of this entity):
        Select the Activity for the condition
        Select the Activity Status for the condition. Select from: Active, Complete, Error, Notified, and suspended
        Select the activity Result for the condition
        Save your work
API (validation is completed through an Application Program Interface):
        Select the PL/SQL Package you wish to interface with the constraint condition
        Enter the Procedure name of the API
        Save your work
TBL (validation is based on the values of database columns on this entity):
        Select the Attribute Column name on the entity for the constraint condition
        Select the Validation Operation for the constraint condition. Select from: = (Equal To), <> (Not Equal To), Is NULL, Is Not NULL
        Select the Value String you want to validate against the value of the column