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?
How to upload Inventory Items
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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'
)
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'
)
Who is online
Users browsing this forum: No registered users and 3 guests