Item upload thru Item interface

Item upload thru Item interface:

1. Gather all your data in excel sheet.

2. We need to enter data in the table mtl_system_items_interface. Below is the statement.(Here extra dta are entered but can be increase or decrease more data but some mandatory are to be needed.

insert into mtl_system_items_interface(item_number,description,transaction_type,organization_id,organization_code,unit_weight,weight_uom_code,
primary_unit_of_measure,attribute_category,process_flag,set_process_id,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,attribute12,attribute13,attribute14,attribute15)

3. To enter the data in the table best way is to first enter data in the customised table and then insert in the mtl_system_items_interface table.

Below is the example:

create table X

(ITEM VARCHAR2(200),
DESCRIPTION VARCHAR2(300),
TRANS VARCHAR2(200),
ORGID VARCHAR2(200),
ORGCODE VARCHAR2(200),
UNIT_WEIGHT VARCHAR2(200),
WEIGHT_UOM_CODE VARCHAR2(200),
PRIMARY_UNIT_OF_MEASURE VARCHAR2(200),
ATTCAT VARCHAR2(200),PROFLAG VARCHAR2(200),
SETPROID VARCHAR2(200),
ATTRIBUTE1 VARCHAR2(200),
ATTRIBUTE2 VARCHAR2(200),
ATTRIBUTE3 VARCHAR2(200),
ATTRIBUTE4 VARCHAR2(200),
ATTRIBUTE5 VARCHAR2(200),
ATTRIBUTE6 VARCHAR2(200),
ATTRIBUTE7 VARCHAR2(200),
ATTRIBUTE8 VARCHAR2(200),
ATTRIBUTE9 VARCHAR2(200),
ATTRIBUTE10 VARCHAR2(200),
ATTRIBUTE11 VARCHAR2(200),
ATTRIBUTE12 VARCHAR2(200),
ATTRIBUTE13 VARCHAR2(200),
ATTRIBUTE14 VARCHAR2(200),
ATTRIBUTE15 VARCHAR2(200))

Data can be enter in the table X through below command:@C:\Prod_All_length_items.txt;

where the Prod_All_length_items.txt is a text file stored in the c drive containg all the rows to be inserted in the table X in below format

Insert into Length_Items values('AL100-100-10-10*CA*R','ANGLE 100MM X 100MM X 10MM, ASTM A572 GR50 X MM','CREATE','230','CAN','CAN Length
Raw Material','15','KG','Millimeter','CAN','1','88888','15','L100X100X10','ASTM A572 GR50');

Then insert data as below statement:
insert into mtl_system_items_interface(item_number,description,transaction_type,organization_id,organization_code,unit_weight,weight_uom_code,
primary_unit_of_measure,attribute_category,process_flag,set_process_id,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,attribute12,attribute13,attribute14,attribute15)select * from x

4. After data are entered in the mtl_system_items_interface check the data

select * from mtl_system_items_interface.

5. To import the items follow the below navigation

Under Inventory responsibility:

Items-->Import--> Import Items
In the parameter all will be default except Process set. Enter Set_process_id value which was entered in the mtl_system_items_interface.
The last parameter is by default 1 which is for creating new item. If you want to update existing one enter value 2 here.

6. After completion the request see the log if any error is there. Correct that fault and update the process flag as 1 in the mtl_system_items_interface table and again import the items.

Error can be seen in the below table also:
select * from MTL_INTERFACE_ERRORS

update mtl_system_items_interfaceset process_flag=1where organization_id=230

7. Before creating items in the child org first item must be created in master org then same process must be followed for other organization by simply updating the org_id in the mtl_system_items_interface table.

Category Updation for existing item thru interface:

1. Arrange data in the correct format.

2. We need to enter data in the table MTL_ITEM_CATEGORIES_INTERFACE. Below is the statement.(Here extra data are entered but can be increase
or decrease more data but some mandatory are to be needed.

insert into MTL_ITEM_CATEGORIES_INTERFACE(inventory_item_id,category_set_id, category_id,process_flag,organization_id,OLD_CATEGORY_ID,set_process_id, transaction_type)values('341980',1,1136,1,22,1135,88888,'UPDATE')
insert into MTL_ITEM_CATEGORIES_INTERFACE(item_number,category_set_id, category_id,process_flag,organization_id,OLD_CATEGORY_ID,set_process_id, transaction_type)values('20-01*16*PC',1,1135,1,22,1136,88888,'UPDATE')

3. To import the items follow the below navigation
Under Inventory responsibility:
Items-->Import--> Item Category Assignment Open Interface
In the parameter all will be default except Record set id. Enter Record set id value which was entered in the MTL_ITEM_CATEGORIES_INTERFACE as set_process_id.

create table CAT_INT
( item_number VARCHAR2(200),
CATEGORY_NAME VARCHAR2(200),
category_set_id VARCHAR2(300),
process_flag VARCHAR2(200),
organization_id VARCHAR2(200),
OLD_CATEGORY_ID VARCHAR2(200),
set_process_id VARCHAR2(200),
transaction_type VARCHAR2(200))

insert into CAT_INT values ('35-05*723*PC','20.MP FITTING.RF-3',1,1,22,1,88888,'UPDATE');