Oracle A75089-02 - Manual (Page 65)

Assigning Column Rules
Interface Data File 5-7
See Also
Inbound Exception Processing on page 6-2
Changing the Interface Data File Record Layout on page 5-2
Assigning Column Rules on page 5-7
Assigning Column Rules
Use the Assign Column Rules window to assign one to six data validation rules to
any data element. You can assign multiple column rules to any column. You can
also assign the same column rule type multiple times.
In a few transactions, required data fields may have been seeded with the required
data element rule. You can remove that requirement, but the application’s open
interface may fail its required data edit.
If needed, you can disable a column rule.
The Assign Column Rules window shows a column in the selected transaction and
all associated column rules. These fields are read-only. For each of the column rules,
select the appropriate action. Certain column rules require additional parameters
that appear in other windows.
The column rules listed below:
Table 5–2 Column Rules and Additional Parameters
Column Rule Description Additional Parameters Needed
Datatype Checking Compare the
datatypes of the data
in the file to the
datatype defined in
the e-Commerce
Gateway transaction
table ECE_
INTERFACE_
COLUMNS. None required.
Default if Null Move a default value
to the staging table
column if the field is
null (blank) in the
interface data file. The default can either be a literal (a constant)
or from a value in another column. Check
either Literal Value or Column Name to
indicate the source of the default value. Then
enter the value of the column name
depending on the box chosen.