Hi all, i was tried following to import the item from backend... first - insert into mtl_system_items_interface (process_flag, set_process_id, transaction_type,. Updating item master attributes using item interface 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. To create an item using api in oracle, 1st you need to put data in interface table mtl_system_items_interface. following insert script will help you to insert data:- insert into mtl_system_items_interface.
Create items (sku’s) and revisions using mtl_system_items_interface. leave a reply. create item and item revisions using mtl_system_items_interface. interface tables used: mtl_system_items_interface: simple script to insert data into mtl systems items interface table.. The unique_id column in mtl_interface_errors is populated from the sequence mtl_system_items_interface_s. thus, for a given row, the sequence of errors can be determined by examining unique_id for a given transaction_id.. When launching items into the master item org, the child records are copied into mtl_system_items_interface for validation, and are identified with a transaction_type of 'auto_child'. updating item attributes to null the method to update columns to null is to use the following values:
