The following insert statement inserts the data into the item import interface table which further
creates inventory item.
Please fill in the values appropriately.
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
LAST_UPDATE_DATE --SYSADTE
,LAST_UPDATED_BY --USERNAME
,CREATION_DATE --SYSDATE
,CREATED_BY --USERNAME
,SEGMENT1 --item code
,DESCRIPTION
,PRIMARY_UOM_CODE
,INVENTORY_ITEM_STATUS_CODE
,ORGANIZATION_CODE
,TEMPLATE_ID
,ORGANIZATION_ID
,LONG_DESCRIPTION
,PROCESS_FLAG -- should be 1
,TRANSACTION_TYPE--TRANSACTION_TYPE MAY BE CREATE OR UPDATE
)
now import item with item import program in inventory resposibility.
cheers
