How to Import Customer Items in Oracle Apps

To import customer items
1. Navigate to the All Reports window.
2. Enter Import Customer Item Cross References 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_XREFS_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_XREFS 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_XREFS_INTERFACE table are populated with the appropriate error code and description. Successfully validated records are transferred to the Oracle Inventory MTL_CUSTOMER_ITEMS_XREFS table.
4. Choose Yes or No to indicate whether to Delete Successfully Validated Records from the MTL_CI_XREFS_INTERFACE table after they have been copied to the Oracle Inventory MTL_CUSTOMER_ITEMS_XREFS table.

5. Choose OK to close the Parameters window, then choose Submit.