Oracle A75089-02 - Manual (Page 67)

Assigning Column Rules
Interface Data File 5-9
Whenever a column rule is violated, the transaction is marked with a violation.
These are displayed in the View Staged Documents window.
◗◗ To assign column rules:
1. Navigate to the Assign Column Rules window. Do this by choosing Column
Rules from the Interface File Definition window.
2. Select a column rule from the List of Values.
Depending on what column rule you select, additional fields display and may
require additional data associated with the column rule. See the list of column
rules above to determine if and what additional data is required.
3. Select a rule action to assign to the column rule:
Abort Run: stops the processing of the document and sets status to Error.
Disabled: Prevents the rule from being enforced.
Log Only: Places a message in the log file and continues processing.
Skip Document: Skip current document and processes the next.
4. Save your work.
See Also
Inbound Exception Processing on page 6-2
Changing the Interface Data File Record Layout on page 5-2
Assigning Process Rules on page 5-5.
Valueset Lookup Compares the value in
the assigned column
to an Oracle
Applications Valueset.
You must select a
valueset from the List
of Values. Select a standard Oracle valueset from a list
of values.
Value is Required Checks if the incoming
data for a given
column has a non null
value. If it is null, the
rule is violated. None required.
Table 5–2 Column Rules and Additional Parameters
Column Rule Description Additional Parameters Needed