3 Replies Latest reply: Jun 5, 2013 5:38 AM by kamalakarg RSS

    Issue with ITEM IMPORT transaction Type 'UPDATE'

    957509
      hello ,

      I am trying to update the item description of an existing item in Master Org.After running the Item import i did not find any errors.but item description was not updated.
      IN Mtl_system_items_interface Process Flag is still '1', INVENTORY_ITEM_STATUS_CODE ='Active', request id Column is populated.
      no record in mtl_interface_errors...

      the query i am using to insert data is

      INTO MTL_SYSTEM_ITEMS_INTERFACE
      (
      INVENTORY_ITEM_ID ,
      ORGANIZATION_ID ,
      LAST_UPDATE_DATE ,
      LAST_UPDATED_BY ,
      CREATION_DATE ,
      CREATED_BY ,
      LAST_UPDATE_LOGIN ,
      DESCRIPTION ,
      SEGMENT1 ,
      INVENTORY_ITEM_STATUS_CODE ,
      PROCESS_FLAG ,
      TEMPLATE_ID ,
      TRANSACTION_TYPE ,
      WIP_SUPPLY_SUBINVENTORY ,
      SET_PROCESS_ID
      )
      VALUES
      (
      v_inventory_item_id, --INVENTORY_ITEM_ID
      v_master_org_id, --MASTER ORGANIZATION ID
      SYSDATE, --LAST_UPDATE_DATE
      fnd_global.user_id, --LAST_UPDATE_BY
      SYSDATE, --CREATION_DATE
      fnd_global.user_id, --CREATED_BY
      NULL, --LAST_UPDATE_LOGIN
      item_rec.item_description, --ITEM_DESCRIPTION
      item_rec.item_number, --SEGMENT1
      'Active', --INVENTORY_ITEM_STATUS_CODE
      1,--PROCESS_FLAG
      v_template_id, --TEMPLATE_ID
      CASE WHEN v_inventory_item_id IS NULL THEN 'CREATE' ELSE 'UPDATE' END, --TRANSACTION_TYPE
      NULL, --SUPPLY_SUBINVENTORY
      1 --SET_PROCESS_ID
      );

      Thanks