After you confirm that there are no open transactions or on-hand quantity
TRUNCATE TABLE INV.MTL_SYSTEM_ITEMS_INTERFACE;
TRUNCATE TABLE INV.MTL_INTERFACE_ERRORS;
TRUNCATE TABLE INV.MTL_ITEM_REVISIONS_INTERFACE;
TRUNCATE TABLE INV.MTL_ITEM_CATEGORIES_INTERFACE;
commit;
Then here is the script I ran in my instance and it worked perfectly --
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(ORGANIZATION_ID,
DESCRIPTION,
INVENTORY_ITEM_ID,
LOT_CONTROL_CODE,
PROCESS_FLAG,
TRANSACTION_TYPE,
SET_PROCESS_ID
)
VALUES
(7852, ---this is the Master Organization ID for your
'TD Item1 UPDATE VIA IOI', -- your Item description
209955, --your item id
'2',
1,
'UPDATE', --CREATE or UPDATE
101);
commit;
Now Navigate..
Choose the Master Organization
Inventory --Items--Import--Import items
All Organizations = Yes
Validate Items = yes
Process Items = yes
Delete Processed Rows = No
Process Set = 101
Create or Update = 2
Gather Statistics = yes
OK
Submit
TRUNCATE TABLE INV.MTL_SYSTEM_ITEMS_INTERFACE;
TRUNCATE TABLE INV.MTL_INTERFACE_ERRORS;
TRUNCATE TABLE INV.MTL_ITEM_REVISIONS_INTERFACE;
TRUNCATE TABLE INV.MTL_ITEM_CATEGORIES_INTERFACE;
commit;
Then here is the script I ran in my instance and it worked perfectly --
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(ORGANIZATION_ID,
DESCRIPTION,
INVENTORY_ITEM_ID,
LOT_CONTROL_CODE,
PROCESS_FLAG,
TRANSACTION_TYPE,
SET_PROCESS_ID
)
VALUES
(7852, ---this is the Master Organization ID for your
'TD Item1 UPDATE VIA IOI', -- your Item description
209955, --your item id
'2',
1,
'UPDATE', --CREATE or UPDATE
101);
commit;
Now Navigate..
Choose the Master Organization
Inventory --Items--Import--Import items
All Organizations = Yes
Validate Items = yes
Process Items = yes
Delete Processed Rows = No
Process Set = 101
Create or Update = 2
Gather Statistics = yes
OK
Submit
No comments:
Post a Comment