This content has been marked as final. Show 6 replies
I wrote a script to copy the item master description to the inventory organizations for the affected items.Did you update the item master directly?
If so, then try using the item interface to update the description in ITM.
Make sure that the item description attribute is controlled at master level.
I updated the item through SQL UPDATE command in a sql script. There are thousands of items with descriptions that are not synchronized so it is impractical to update the the items through the Inventory module, if that is what you mean. what do you mean by "Make sure that the item description attribute is controlled at master level."
1 person found this helpful
I updated the item through SQL UPDATE command in a sql script.It is a bad idea to update item description via sql. It won't work. Do not do it.
There are thousands of items with descriptions that are not synchronized so it is impractical to update the the items through the Inventory module,Agreed. But that is why Oracle has provided Item Interface.
You can try the following
And then run item import to make descriptions in child org = those in master
INSERT INTO mtl_system_items_interface (process_flag, set_process_id, segment1, description, organization_code, transaction_type) (SELECT 1, 123, msi.segment1, msi.description, mp.organization_code, 'Update' FROM mtl_system_items_b msi, mtl_parameters mp WHERE msi.organization_id = mp.master_organization_id AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi2 WHERE msi2.organization_id = mp.organization_id AND msi2.inventory_item_id = msi.inventory_item_id AND msi2.description != msi.description))
what do you mean by "Make sure that the item description attribute is controlled at master level."Inventory > setup > items > attribute controls
Look for description and make sure control is at master level
(I assume you want same description for a given item in all orgs)
I know that updating the item through sql won't work. Someone updated item descriptions during an upgrade and that is why we have the problem. I never wanted to write a script like this because it was obvious there was a lot more going on under the hood besideds the two base tables I listed previously. I considered the possibility that something like the system items interface existed but did not know where to look. This looks very promising. Do you know where the Interface is documented? Thank you.
The Mtl_System_Items_Interface & Import Items concurrent process are fine for updating the Inventory description but the catalog extract still does not move the changes to iProcurment.