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.

Customer items in Oracle Order management

1.    How to identify whether a user entered a customer item (in ordered_item column in oe_order_lines_all) or internal item in order lines screen:

SELECT ITEM_IDENTIFIER_TYPE

FROM OE_ORDER_LINES_ALL

WHERE HEADER_ID= 54328710