INVCustomerItemsCrossReference
Use this transaction to import cross‐references between customer Items and existing Oracle Inventory Items into your master Organization. If you set Item Definition Level 3 while Customer Category is required for Item Definition Level 2, Customer Address is required.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory
Open Interface
Customer Items Cross Reference
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
MTL_CI_XREFS_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
MTL_CI_XREFS_INTERFACE
FND_USER_VIEW
Inputs
Field | Description |
WM_USER | User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction. |
Outputs
Field | Description |
CUSTOMER_ ITEM_NUMBER | Customer item number in old 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. |
Usage Comments
To create Customer Items Cross‐References use a TRANSACTION_TYPE of CREATE.
We have experienced a bug in Oracle Applications. If you set the
Delete Processed rows option to
Yes, the records should be removed from the open interface tables after the import. However, the records are not removed and are not updated to show they have been processed.
*PROCESS FLAG and PROCESS_MODE columns report the status of the record after the import and validation process is complete. These columns are required on insert and should be populated with the value
1.
INACTIVE_FLAG is a required field. Set it to
1 for Yes and
2 for No.
Oracle Applications does not allow update through this open interface. If you use a TRANSACTION_TYPE of UPDATE, the import will treat it as a CREATE and you receive a
Customer Item Cross Reference already exists error.
Oracle Applications does not allow deletion through this open interface. You may set a Customer Item Cross Reference to Inactive using the Oracle Applications GUI.
To import Items, run the
Import Customer Items Cross Reference function, which is under the Inventory module.