Forum Stats

  • 3,767,816 Users
  • 2,252,720 Discussions
  • 7,874,335 Comments

Discussions

Using MTL_SYSTEM_ITEMS_INTERFACE and MTL_ITEM_REVISIONS_INTERFACE

2647980
2647980 Member Posts: 1
edited Jul 28, 2015 12:14AM in Oracle Call Interface (OCI)

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

Answers

  • Sanjay Desai EBS
    Sanjay Desai EBS Member Posts: 1,778
    edited Jul 28, 2015 12:14AM

    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.

This discussion has been closed.