How to upload Inventory Items

[AIMAM]

Hi,
We are working on oracle apps 11i. There is a new requirement to add hundreds of items to the system.
Is there any way or scipt that help us to upload these items specially that there are already quantities on hand for most of these items in the main warehause subinventory.
In other words, how can we upload the items and their opening balance as well?

[admin]

Upload in the interface tables then import. thanks

[AIMAM]

where can i find the stansard scripts?

Thank you

[ahmadbilal]

Use following in Control File and Upload information MTL_SYSTEM_ITEMS_INTERFACE and go to inventory run the item upload request

LOAD DATA
INFILE 'item.csv'
INSERT
INTO TABLE MTL_SYSTEM_ITEMS_INTERFACE
REPLACE FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
SEGMENT1 "trim(substr(:SEGMENT1,2))",
SEGMENT2 "trim(substr(:SEGMENT2,2))",
SEGMENT3 "trim(substr(:SEGMENT3,2))",
SEGMENT4 "trim(substr(:SEGMENT4,2))",
SEGMENT5 "trim(substr(:SEGMENT5,2))",
SEGMENT6 "trim(substr(:SEGMENT6,2))",
SEGMENT7 "trim(substr(:SEGMENT7,2))",
DESCRIPTION "trim(:DESCRIPTION)",
LONG_DESCRIPTION "trim(:LONG_DESCRIPTION)",
PRIMARY_UOM_CODE "trim(:PRIMARY_UOM_CODE)",
REVISION,
--SECONDARY_UOM_CODE,
TEMPLATE_ID,
PREPROCESSING_LEAD_TIME,
POSTPROCESSING_LEAD_TIME,
INTERNAL_ORDER_FLAG "trim(:INTERNAL_ORDER_FLAG)",
CUSTOMER_ORDER_FLAG "trim(:CUSTOMER_ORDER_FLAG)",
INVOICE_ENABLED_FLAG "trim(:INVOICE_ENABLED_FLAG)",
ORGANIZATION_ID,
--ATTRIBUTE_CATEGORY "trim(:ATTRIBUTE_CATEGORY)",
--ATTRIBUTE1 "trim(:ATTRIBUTE1)",
--ATTRIBUTE2 "trim(:ATTRIBUTE2)",
last_update_date constant '16-FEB-09',
last_updated_by constant 0,
last_update_login constant 0,
created_by constant 0,
creation_date constant '16-FEB-09',
PROCESS_FLAG constant 1,
TRANSACTION_TYPE constant 'CREATE',
--ITEM_NUMBER,
SET_PROCESS_ID constant 1,
ENABLED_FLAG constant 'Y',
START_DATE_ACTIVE constant '16-FEB-09'
)

[AIMAM]

Thanks Bilal,

Kindly,I also need to know how to upload the onhand quantities

Thank you