Exception Records Overview
An exception is a record that may contain one or more data errors. A workflow adds a record to a correct exceptions task when a Mapping task cannot determine if the record is correct.
Records in a correct exceptions task might contain errors or empty fields. When you correct exception records, you examine the records and attempt to update each record with correct and complete data. The Analyst tool indicates which fields might contain errors in the records. You can select a field and correct the error.
After you review a record, you can update the record status. You can update the status of the records in one of the following ways:
- •If a record is valid, update the table metadata to confirm that the record is acceptable for persistent storage in the database.
- •If a record is not valid, update the table metadata to confirm that you reject the record for persistent storage in the database.
- •If you cannot confirm the record status, update the table metadata so that the record returns to the workflow for further processing in a Mapping task.
When you review all the records in a task, you can indicate that you completed work on the task. The task menu options define the next step for the task data. The workflow determines the options that you can choose from.
After a correct exceptions task, the next step might be to review exceptions. In this step, a user reviews the work that another user performed. In the review exceptions step, a user can change the actions of the other user. The reviewer can approve the record changes, or clear the record status to reject the changes. The review exceptions step is an optional step.