Translate

Thursday, March 14, 2013

Updating Item Master attributes Using Item Interface

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

No comments:

Post a Comment