Oracle A75089-02 User 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
Changing the Interface Data File Record Layout
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