Oracle A75089-02 Manual de usuario descargar pdf (Pagina 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 mu st sel ect 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

1 2 ... 62 63 64 65 66 67 68 69 70 71 72 ... 143 144

Sin comentarios

Oracle A75089-02 Manual de usuario Pagina 67