To specify the number of import workers to use and launch the import manager:You can load quality results data from external systems into the quality data repository using the Collection Import Interface. For example, you can load data from sources such as test equipment and gauges into the Collection Import Interface.
From the Launch Collection Import Manager window, you open the Collection Import Manager, which validates records in the Collection Import Interface, then imports the data into the quality data repository. Quality results data that fails validation or processing is marked. You can use the Update Collection Import window to view, update, and resubmit this information.
The Collection Import Manager allows you to insert multiple rows of data into the quality data repository, and to update existing rows of data. When you launch the Collection Import Manager, you can either insert multiple rows or update a single row at a time. You cannot, however, both insert and update rows at the same time.
Caution: The Collection Import Interface does not automatically relate imported parent and child collection plan records.
You can use the Collection Import Manager program to add quality results to the quality data repository and to update quality results already in the quality data repository.
When the Collection Import Manager program is launched, 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.
Insert rows into the collection import table. See: Collection Import, Oracle Manufacturing APIs and Open Interfaces Manual.
To specify the number of import workers to use and launch the import manager:Navigate to the Launch Collection Import Manager window. The Parameters window appears.
Enter the number of Worker Rows. This is the number of rows each Collection Import Worker processes.
Select the Transaction Type from the field's list of values. The Transaction Type window opens.
If you select Update Transaction, Quality updates existing records in the database.
If you select Insert Transaction, Quality inserts multiple records into the database.
Choose OK to close the Transaction Type window.
Choose OK to close the Parameters window.
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 message in the Errors table. Invalid rows remain in the Collection Import Interface Table.
Attention: If a collection element value in the Collection Import Interface Table is null, the null value is inserted in the database even if the existing collection plan in the database specifies a default value for the collection element.
Choose Submit.
To specify print options, define run options, and submit the request:See: Standard Request Submission.
Other Sources
See: Collection Import Interface, Oracle Manufacturing APIs and Open Interfaces Manual
