Updating Collection Import
You can find, view, update, delete, and resubmit records (rows) that have failed validation and remain in the Collection Import Interface Table (QA_RESULTS_ INTERFACE). You can view the error messages associated with failed records. Error messages assist you in updating failed records prior to resubmission.
You cannot insert new collection import records using this window.
Prerequisites
Insert quality results data into the Collection Import Interface Table. See: Collection Import Interface, Oracle Manufacturing Open Interfaces, Release 11.
To display all collection import records for a collection plan:
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. See: Using a List of Values.
When you select a collection plan, all collection import records that are associated with that collection plan are displayed.
1. In the Update Collection Import window, select the failed row.
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.
- 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.
Attention: The list of values that are displayed for dependent context elements contain all values. For example, if you are updating a row that includes a Revision and an Item, the list of values associated the Revision context element list all Revisons, not just those for the Item specified in the row.
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: Selecting Multiple Records.
2. Choose the Resubmit button to mark the record or records for resubmission.
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: Selecting Multiple Records.
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.
