Importing Customer Items
To import customer items
2. Enter Import Customer Items in the Name field. The Parameters window appears.
3. Indicate whether to Abort on Error:
Yes indicates that the interface will automatically abort execution if an error is encountered during validation of a record. No additional records will be processed. The ERROR_CODE and ERROR_EXPLANATION columns in the MTL_CI_INTERFACE table are populated with the appropriate error code and explanation for the record that caused the error. Successfully validated records are transferred to the Oracle Inventory MTL_CUSTOMER_ITEMS table.
No, the default, indicates that processing of the records in the interface table will continue until the end of the table is reached. If an error is encountered during validation of records, the ERROR_CODE and ERROR_EXPLANATION columns in the MTL_CI_INTERFACE table are populated with the appropriate error code and description. Successfully validated records are transferred to the Oracle Inventory MTL_CUSTOMER_ITEMS table.
4. Choose Yes or No to indicate whether to Delete Successfully Validated Records from the MTL_CI_INTERFACE table after they have been copied to the Oracle Inventory MTL_CUSTOMER_ITEMS table.
5. Choose OK to close the Parameters window, then choose Submit.
See Also
Open Item Interface
Integrating Your Systems: Oracle Manufacturing Implementation Manual, Release 10