INVCustomerItemCrossRef

Use this transaction to import cross‐references between customer Items and existing Oracle Inventory Items into your master Organization.

For more information about this transaction, see your Oracle Applications documentation.

Oracle Applications Module

Inventory

Open Interface

Customer Item Cross Reference

Open Interface Tables

The open interface table exposed by this transaction is:

MTL_CI_XREFS_INTERFACE

Error SQL

Inputs

Field	Description
WM_USER	Name of the user for the corresponding user ID in the CREATED_BY column of the MTL_CI_XREFS_INTERFACE table. This parameter will accept wild cards. % returns all errors.

Outputs

Field	Description
CUSTOMER_ITEM_NUMBER	Customer item number in legacy system.
INVENTORY_ITEM_ID	Existing inventory Items ID. TRANSACTION_TYPE Transaction type (CREATE or UPDATE).
PROCESS_MODE	Process flag to indicate whether processing of row is succeeded or failed.
CUSTOMER_NAME	Customer name
ERROR_EXPLANATION	Detailed error message.