Oracle A75089-02 - Manual (Page 66)

Assigning Column Rules
5-8 Oracle e-Commerce Gateway User’s Guide
Null Dependency Checks if the incoming
data for a given
column has a null or
not null dependency
based on the following
conditions.
More than one set of
condition parameters
can be entered at the
same time.
Check boxes for Must be Null or Cannot be
Null for the data in the column to be
reviewed.
Then enter the Column Name, the
Dependency, and Value for the condition.
The dependency must be Null, Not Null, or
Equal. Multiple dependencies are read as
AND conditions.
For example, set the check box to Cannot be
Null and enter the following conditions:
TRADING_PARTNER Is Not Null; SHIP_
TO_SITE Is Not Null; COUNTRY Equal USA.
This means that the column being reviewed
cannot be null if the three listed conditions
are true.
Predefined List Checks if the incoming
data for a given
column is equal to or
not equal to a value in
a predefined list in the
e-Commerce Gateway. Check must be either Must Equal or Not
Equal to indicate the comparison condition.
The incoming value must match one of the
values in the list.
Simple Lookup Compares the value in
the assigned column
with the results of a
SQL statement that is
dynamically created
with this column rule.
The assigned column
value must match one
of the values returned
by the SQL statement
for this column rule to
pass data validation
during inbound
processing.
Specify any table and
column and optionally
define a condition (a
WHERE clause) that
will be appended to
the dynamic SQL.
Then validate the
dynamic SQL using
the Validate button.
Enter a table name, a column, and a
condition where the condition is a SQL
WHERE clause.
Perform validation to confirm that the table,
column, and condition are valid.
For example, the table name is ECE_
LOOKUP_VALUES, the column is
LOOKUP_CODES, and the condition is
LOOKUP_TYPE=’DOCUMENT’.
Table 5–2 Column Rules and Additional Parameters
Column Rule Description Additional Parameters Needed