INVItems
Use this transaction to convert inventory items from another inventory system, migrate assembly and component items from a legacy manufacturing system, convert purchased items from a custom purchasing system, and insert new items from a Product Data Management package.
When you import items using this transaction, it creates new Items in the item master organization or assigns existing Items to additional organizations. You can specify values for all item attributes, or you can use default or null values. This transaction also lets you import revision details, including past and future revisions and effective dates.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory
Open Interface
Item Transaction
Open Interface Tables
The open interface tables exposed by this transaction are:
MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_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_INTERFACE table. This parameter will accept wild cards. % returns all errors. |
Outputs
Field | Description |
ITEM_NUMBER | Item number in legacy system. |
CUSTOMER_ITEM_DESC | Description of item. |
TRANSACTION_TYPE | Transaction type (CREATE or UPDATE). |
PROCESS_FLAG | Process flag to indicate the processing state of the row. |
ERROR_EXPLANATION | Detailed error message. |