Using MTL_SYSTEM_ITEMS_INTERFACE and MTL_ITEM_REVISIONS_INTERFACE

2647980

Hi -

I would like to update one column on an item (in MTL_SYSTEM_ITEMS_B) using the interface tables MTL_SYSTEM_ITEMS_INTERFACE and MTL_ITEM_REVISIONS_INTERFACE.  What are the minimum required fields I must provide to do this?

It would also be helpful to see sample calls.

Regards - Kirsten

Sanjay Desai EBS

Hi,

Following minimum fields are required to update the columns on mtl_system_items_b

segment1,

segment2,

segment3,

segment4,

transaction_type ,

process_flag ,

set_process_id ,

organization_id ,

last_updated_by ,

last_update_date

and required column(s) you need to update.

If you using Item Revision control concept then you need to populate the mtl_item_revision_interface, otherwise not.