6 Replies Latest reply on Mar 18, 2015 5:57 PM by rioman

    problem in trigger on table mtl_material_transactions_temp

    2679576

      I created a trigger which should update a value in an attribute1 in table MTL_TXN_REQUEST_LINES after deleting a ligne in mtl_material_transactions_temp. when i delete the line directly from the table attribute1 is updated but when i annulate affectation in the form INVTOTRX which is corresponding of deleting a line in mtl_material_transactions_temp the attribute1 is not updated this is the code of the trigger . please could you help me

      create or replace 
      TRIGGER top_after_delete_temp
      After DELETE
         ON mtl_material_transactions_temp
         FOR EACH ROW
      BEGIN
      if(:old.organization_id=85) and (:old.transaction_type_id= 64) then 
      UPDATE MTL_TXN_REQUEST_LINES
      SET attribute1='N'
      where line_id=:old.MOVE_ORDER_LINE_ID;
      end if;
      END;