INVItems
Use this transaction to import customer items from any legacy system into Oracle Inventory. For each customer item, you must define related information such as the Customer and Item Definition Level. 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 Transaction
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
MTL_CI_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
MTL_CI_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_DESC | Description of item. |
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 import Customer Items, run the
Import Customer Items function, which is under the Inventory module.
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.
DEP_PLAN_REQUIRED_FLAG and DEP_PLAN_PRIOR_BLD_FLAG fields have required values of
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 already exists error.
Oracle Applications does not allow deletion through this open interface. You may set a Customer Item to Inactive using the Oracle Applications GUI.