APEX

I have a big big problem...

One field (closure date) in one of my tables modified itself and I can't find the reason. 174 records modified the field with this value: 19-NOV-2012 15:54:39.

I have this trigger to set the closure date value when the status is closed:

create or replace TRIGGER "SD_INCIDENTS_TIME2"
BEFORE
update on "PROBLEMS"
for each row
begin
    IF (:new.STATUS='CLOSED') THEN
    :new.CDATE :=SYSTIMESTAMP AT TIME ZONE '-3:00';
    END IF;
end;

I have been doing tests to determine if this trigger did the problem but not....

The other thing that I want to know is where can I find the logs to see who did those changes or what triggered that..

Thanks, Bernardo

Regards