You can use the Update Collection Import window to view, update, delete, and resubmit records (rows) that have failed validation and that remain in the Collection Import Interface Table (QA_RESULTS_ INTERFACE). You also can view contact information and error messages associated with failed records. Error messages assist you in updating failed records prior to resubmission. You cannot, however, use this window to insert new collection import records.

Prerequisites

• Insert quality results data into the Collection Import Interface Table. See: Collection Import Interface, Oracle Manufacturing APIs and Open Interfaces Manual.

   To display all collection import records for a collection plan:

1. Navigate to the Update Collection Import folder window. See: Customizing the Presentation of Data.

2. Select the Collection Plan.

   You can use the Find Plan button or the standard list of values to find and select a collection plan. After selecting a collection plan, you can use the previous plan/next plan arrow buttons, located to the right of the collection plan name, to scroll to another valid collection plan.

   When you select a collection plan, all collection import records that are associated with that collection plan are displayed.

   To display contact information for any record:

1. Navigate to the record.

2. Choose the Show Contact button.

   To view error details for a failed record:

1. In the Update Collection Import window, select the failed row.

2. Choose the Show Errors button. The Errors window appears.

   All errors for the selected row are displayed. Error Column indicates the name of the column in the Collection Import Interface Table that failed validation. Error Message indicates why the transaction failed. Messages that are not specific to a Column may also be displayed.

   To update failed collection import records:

From the records displayed in the Update Collection Import window, select a failed record and update as required. You can update any column of any record.

Records that are updated are not automatically resubmitted.

   To resubmit failed collection import records:

1. From the records displayed in the Update Collection Import window, select the record or records to resubmit. You can select or deselect records as required. See: Multiple-Record Selection.

2. Choose the Resubmit button to mark the record or records for resubmission.

3. Save your work.

   When you save your work, marked records are resubmitted. Resubmitting records resets their process status flags to 1 (Pending), and nulls their Group ID. The next time the Collection Import Manager polls the Collection Import Interface Table, these records are reprocessed and revalidated.

   To delete collection import records:

1. From the records displayed in the Update Collection Import window, select the record or records to resubmit. You can select or deselect records as required. See: Multiple-Record Selection.

   You can delete records of any processing status. When you delete records, their corresponding error messages are deleted from the Errors table (QA_INTERFACE_ERRORS).

2. Choose Delete from the Edit menu.

3. Choose Save to commit the deletion.