Previous	Next		Contents	Index	Navigation	Glossary	Library

Attention: You can only update one row at a time when you run the Collection Import Manager program.

When the Collection Import Manager program is submitted, the system searches the Collection Import Interface Table (QA_RESULTS_ INTERFACE) and creates or updates quality results records in the quality results database table (QA_RESULTS) for each row that passes validation. Records in the Collection Import Interface Table that have their update flag set to 2, update current records in QA_RESULTS while those with an update flag other than 2, create new quality results records. If a row fails validation, an error message is entered in the errors table (QA_INTERFACE_ERRORS) and the invalid rows remain in the Collection Import Interface Table. You can update these failed rows and resubmit them.

Prerequisites

   Insert rows into the collection import table. See: Collection Import, Oracle Manufacturing Open Interfaces Manual, Release 11.

   To specify the number of import workers to use and launch the import manager:

1. Navigate to the Launch Collection Import Manager window. The Parameters window appears.

2. Enter the number of Worker Rows. This is the number of rows each Collection Import Worker processes.

3. Choose OK.

The Collection Import Manager polls the Collection Import Interface Table, validates each row of data and either creates or updates quality results records for that row or enters an error messages in the Errors table. Invalid rows remain in the Collection Import Interface Table.

4. Choose Submit.

   To specify print options, define run options, and submit the request:

• See: Submitting a Request.