Monday, August 31, 2009

Inventory item creation in R12

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

1 comment: